How to include header in a file



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Re: How to include header in a file

Postby NicC » Wed Feb 13, 2013 6:28 pm

Anyway, nothing to do with JCL - moving to the correct part of the forum.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: How to include header in a file

Postby jatin_compsci » Thu Feb 14, 2013 12:28 pm

Hi Billy,

Thanks for the great help , but the problem is now is data in the output file is coming like -

ORDER_NR BNR MOTTAGEN_KVT_BPK;ORDERRAD_STS FORVANTAD_ANK_DAT; 
00789753006538200000OP                   2012-09-22
00824766000721100000OP                   2013-02-10
00826145006538200000OP                   2012-07-05
00826147006538200100DL                   2012-07-10
00884274006039801287DL                   2012-10-09
00884314007285900000OP                   2012-10-04
00918760008199900000OP                   2013-01-16
00918251000553300000OP                   2013-01-16



Right now i am using the below card -



//S1       EXEC  PGM=ICEMAN                             
//SYSOUT   DD   SYSOUT=*                                 
//SORTIN   DD DSN=VTENK.UNLOAD.FTDT.TORDRAD4.OUT,DISP=SHR
//SORTOUT  DD DSN=VTENK.UNLOAD.FTDT.TORDRAD5.OUT,       
//             DISP=(NEW,CATLG,DELETE),                 
//             SPACE=(CYL,(1000,1000),RLSE),             
//             DCB=(LRECL=62,BLKSIZE=31000,RECFM=FB),   
//             UNIT=(TEST,25)                           
//SYSIN    DD    *                                       
  OPTION COPY                                           
  OUTFIL REMOVECC,                                       
          HEADER1=('ORDER_NR BNR MOTTAGEN_KVT_BPK;',     
                   'ORDERRAD_STS FORVANTAD_ANK_DAT;'),   
          BUILD=(1,8,10,7,18,5,24,2,42:27,10,11X)       
                                                         
/*                                                       




What could be the reason?
jatin_compsci
 
Posts: 17
Joined: Wed Feb 13, 2013 1:30 pm
Has thanked: 1 time
Been thanked: 0 time

Re: How to include header in a file

Postby BillyBoyo » Thu Feb 14, 2013 12:51 pm

OK, but remember that you know what the data should look like, we don't, so you'll have to let us in on that.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: How to include header in a file

Postby jatin_compsci » Thu Feb 14, 2013 1:18 pm

Hi Billy,


Yes sure, Below is the how the data should look like -

ORDER_NR BNR     MOTTAGEN_KVT_BPK ORDERRAD_STS FORVANTAD_ANK_DAT
00789753 0065382 00000            OP           2012-09-22
00824766 0007211 00000            OP           2013-02-10





And it would be great for me if you can explain the below build also


BUILD=(1,8,10,7,18,5,24,2,42:27,10,11X)



It feels great to gain knowledge from the experienced people like you :)
jatin_compsci
 
Posts: 17
Joined: Wed Feb 13, 2013 1:30 pm
Has thanked: 1 time
Been thanked: 0 time

Re: How to include header in a file

Postby enrico-sorichetti » Thu Feb 14, 2013 2:02 pm

BUILD=(1,8,10,7,18,5,24,2,42:27,10,11X)


if You keep up using sort knowing the basic syntax of the most common statements will come pretty handy.
So what about spending a bit of time looking at the manuals,
no reason for anybody to rewrite them.
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: How to include header in a file

Postby BillyBoyo » Thu Feb 14, 2013 2:50 pm

In your first BUILD you were using "columns", but columns which, except for the last, would cause overwriting of data from the BUILD, which is not allowed.

You want one space between your first fields. Two main ways: columns or specifying a space.

  BUILD=(1,8,X,10,7,X,18,5,X,24,2,42:27,10,11X)


I agree with enrico. You will get more by looking in the manual for the BUILD posted than by anyone just telling you what it does. If, after reading the manual and experimenting, you still have questions, post what you have understood, and the problem you still have, and someone will assist.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: How to include header in a file

Postby jatin_compsci » Thu Feb 14, 2013 2:59 pm

ok, will go through it first and then come to you :)

Thanks for the help guys.

Regards,
Jatin
jatin_compsci
 
Posts: 17
Joined: Wed Feb 13, 2013 1:30 pm
Has thanked: 1 time
Been thanked: 0 time

Re: How to include header in a file

Postby jatin_compsci » Thu Feb 14, 2013 3:01 pm

But 1 question any handy manual for the DFSORT concepts?
jatin_compsci
 
Posts: 17
Joined: Wed Feb 13, 2013 1:30 pm
Has thanked: 1 time
Been thanked: 0 time

Re: How to include header in a file

Postby BillyBoyo » Thu Feb 14, 2013 3:04 pm

Click where it says DFSORT/ICETOOL/ICEGENER, look at the postings (sticky) at the top of the forum, and you'll find sufficient reference material.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: How to include header in a file

Postby enrico-sorichetti » Thu Feb 14, 2013 3:22 pm

for all You might want to know on the content of IBM manuals
start from
http://www-03.ibm.com/systems/z/os/zos/ ... index.html

and navigate to the bookshelf related to Your zOS level
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

PreviousNext

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post