Page 1 of 1

Issue with DFSORT

PostPosted: Fri Nov 27, 2009 1:58 pm
by naveenkumar sudha
Hi all,

I got the following error when i run the following jcl.I have also mentioned my input file contents starting from position 1 and error message.

Could any one help me.

I am trying to add values from position 19 of length 3 for records whose 1 to 3 has value 111.

//TXZNS611 JOB (CGK9205,55),NAV,CLASS=A,MSGCLASS=B,NOTIFY=&SYSUID
//SORTPGM EXEC PGM=SORT
//SORTIN DD DSN=THHH.OSU.NS6.SORT,DISP=SHR
//SORTOUT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSIN DD *
INCLUDE COND=(1,3,CH,EQ,C'111')
SORT FIELDS=(1,3,CH,A)
SUM FIELDS=(19,3,BI)
/*


File contents:

111g11fgdfgjdfgsdf111
111g11fgdfgjdfgsdf111
222ghdfgdfghd
222ghdfgdfghd
333ffffffffffffffffffffsd
333ffffffffffffffffffffsd


Error message:

ICE000I J - CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R5 - 09:46
INCLUDE COND=(1,3,CH,EQ,C'111')
SORT FIELDS=(1,3,CH,A)
SUM FIELDS=(19,3,BI)
ICE201I J RECORD TYPE IS F - DATA STARTS IN POSITION 1
ICE109A J SUM FIELD DISPLACEMENT OR LENGTH VALUE ERROR
ICE052I J END OF DFSORT

Thanks,
Naveen S

Re: Issue with DFSORT

PostPosted: Sat Nov 28, 2009 6:00 am
by Frank Yaeger
Sigh. If you had looked up the ICE109A error message, you would have found that you can only SUM a BI field of 2, 4 or 8 bytes, not 3.

But the field you want to SUM appears to be ZD, not BI, so the appropriate SUM statement would be:

   SUM FIELDS=(19,3,ZD)


and you would get this output:

111g11fgdfgjdfgsdf222

Re: Issue with DFSORT

PostPosted: Sun Nov 29, 2009 2:30 pm
by naveenkumar sudha
Many Thanks Frank Yaeger. Could you please also clarify when we have to use BI,PDand others.

Re: Issue with DFSORT

PostPosted: Sun Nov 29, 2009 9:38 pm
by dick scherrer
Hello,

Could you please also clarify when we have to use BI,PDand others
When to use these depends on the data being processed. You use the data type that is appropriate for the data in the field. Most people use a copybook to determine field types if they do not already know them.

Re: Issue with DFSORT

PostPosted: Mon Nov 30, 2009 11:21 pm
by Frank Yaeger
Could you please also clarify when we have to use BI,PDand others.


See the following for more information on DFSORT's data types:

http://publibz.boulder.ibm.com/cgi-bin/ ... 0527161936

Re: Issue with DFSORT

PostPosted: Tue Dec 01, 2009 5:57 pm
by naveenkumar sudha
Thanks alot for your help.