Sort syntax



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

Sort syntax

Postby oksk » Mon Dec 24, 2007 6:02 pm

hi all,

please let me know is something wrong with the syntax.

INCLUDE COND=((1,2,PD,EQ,X'0000',OR,1,2,PD,EQ,X'FFFF'),OR,(166,5,CH,NE,C'CAUST',AND,166,5,CH,NE,C'MORTG',AND,166,5,CH,NE,C'HIREP'))

i'm getting syntax error.

Rgds,
oksk
oksk
 
Posts: 3
Joined: Thu Dec 20, 2007 5:35 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Sort syntax

Postby Frank Yaeger » Mon Dec 24, 2007 10:10 pm

There are a couple of problems with your INCLUDE statements.

They appear to overrun column 72 (although it's hard to tell since you didn't use code tags).

You're trying to use a PD field with a hexadecimal constant - that's not allowed. You can use a BI field with a hexadecimal constant, or a PD field with a numeric constant (e.g. +0). In your case, it looks like you should be using a BI field with a hex constant since you're not testing for a PD value.

This DFSORT INCLUDE statement will work:

  INCLUDE COND=((1,2,BI,EQ,X'0000',OR,1,2,BI,EQ,X'FFFF'),OR, 
    (166,5,CH,NE,C'CAUST',AND,                               
    166,5,CH,NE,C'MORTG',AND,                                 
    166,5,CH,NE,C'HIREP'))                                   
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: Sort syntax

Postby oksk » Wed Dec 26, 2007 4:42 pm

Thanks a lot Frank!!!!
oksk
 
Posts: 3
Joined: Thu Dec 20, 2007 5:35 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post