IBM Mainframe Forum

by **NicC** » Wed Feb 13, 2013 6:28 pm

Anyway, nothing to do with JCL - moving to the correct part of the forum.

by **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 -

Select all

//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?

by **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.

by **jatin_compsci** » Thu Feb 14, 2013 1:18 pm

Hi Billy,

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

Select all

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

Select all

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

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

Select all

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.

by **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.

Select all

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.

by **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

by **jatin_compsci** » Thu Feb 14, 2013 3:01 pm

But 1 question any handy manual for the DFSORT concepts?

by **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.

by **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

IBM Mainframe Forum

How to include header in a file

Re: How to include header in a file

Re: How to include header in a file

Re: How to include header in a file

Re: How to include header in a file

Re: How to include header in a file

Re: How to include header in a file

Re: How to include header in a file

Re: How to include header in a file

Re: How to include header in a file

Re: How to include header in a file