Page 2 of 3

Re: How to include header in a file

PostPosted: Wed Feb 13, 2013 6:28 pm
by NicC
Anyway, nothing to do with JCL - moving to the correct part of the forum.

Re: How to include header in a file

PostPosted: Thu Feb 14, 2013 12:28 pm
by jatin_compsci
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?

Re: How to include header in a file

PostPosted: Thu Feb 14, 2013 12:51 pm
by BillyBoyo
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.

Re: How to include header in a file

PostPosted: Thu Feb 14, 2013 1:18 pm
by jatin_compsci
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 :)

Re: How to include header in a file

PostPosted: Thu Feb 14, 2013 2:02 pm
by enrico-sorichetti
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.

Re: How to include header in a file

PostPosted: Thu Feb 14, 2013 2:50 pm
by BillyBoyo
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.

Re: How to include header in a file

PostPosted: Thu Feb 14, 2013 2:59 pm
by jatin_compsci
ok, will go through it first and then come to you :)

Thanks for the help guys.

Regards,
Jatin

Re: How to include header in a file

PostPosted: Thu Feb 14, 2013 3:01 pm
by jatin_compsci
But 1 question any handy manual for the DFSORT concepts?

Re: How to include header in a file

PostPosted: Thu Feb 14, 2013 3:04 pm
by BillyBoyo
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.

Re: How to include header in a file

PostPosted: Thu Feb 14, 2013 3:22 pm
by enrico-sorichetti
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