Issue with DFSORT



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

Issue with DFSORT

Postby naveenkumar sudha » Fri Nov 27, 2009 1:58 pm

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
naveenkumar sudha
 
Posts: 21
Joined: Mon Nov 23, 2009 10:59 am
Has thanked: 0 time
Been thanked: 0 time

Re: Issue with DFSORT

Postby Frank Yaeger » Sat Nov 28, 2009 6:00 am

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
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

Re: Issue with DFSORT

Postby naveenkumar sudha » Sun Nov 29, 2009 2:30 pm

Many Thanks Frank Yaeger. Could you please also clarify when we have to use BI,PDand others.
naveenkumar sudha
 
Posts: 21
Joined: Mon Nov 23, 2009 10:59 am
Has thanked: 0 time
Been thanked: 0 time

Re: Issue with DFSORT

Postby dick scherrer » Sun Nov 29, 2009 9:38 pm

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Issue with DFSORT

Postby Frank Yaeger » Mon Nov 30, 2009 11:21 pm

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
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

Re: Issue with DFSORT

Postby naveenkumar sudha » Tue Dec 01, 2009 5:57 pm

Thanks alot for your help.
naveenkumar sudha
 
Posts: 21
Joined: Mon Nov 23, 2009 10:59 am
Has thanked: 0 time
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post