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.

Posts: 3
Joined: Thu Dec 20, 2007 5:35 pm

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:

Code: Select all
  INCLUDE COND=((1,2,BI,EQ,X'0000',OR,1,2,BI,EQ,X'FFFF'),OR, 
Frank Yaeger - DFSORT Development Team (IBM) -
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at
User avatar
Frank Yaeger
Global moderator
Posts: 1082
Joined: Sat Jun 09, 2007 8:44 pm

Re: Sort syntax

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

Thanks a lot Frank!!!!
Posts: 3
Joined: Thu Dec 20, 2007 5:35 pm



  • Related topics
    Last post