Posted: Fri Feb 26, 2010 7:53 pm Post subject: Syncsort - with OR/AND conditions
I don't understand what this Syncsort syntax error is below...
Code:
//STEP1 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD *
E ABCDEFG
A ABCDEFG
C ABCDEFG
E TUVWXYZ
A TUVWXYZ
E SSSSSSS
/*
//SORTOF1 DD SYSOUT=*
//SYSIN DD *
SORT FIELDS=COPY
OUTFIL FILES=1,
INCLUDE COND=((3,7,EQ,C'ABCDEFG',OR,3,7,EQ,C'TUVWXYZ'),AND,
(1,1,EQ,C'E'))
END
/*
//
Code:
SYNCSORT FOR Z/OS 1.3.2.1N U.S. PATENTS: 4210961, 5117495
SYSIN :
SORT FIELDS=COPY
OUTFIL FILES=1,
INCLUDE COND=((3,7,EQ,C'ABCDEFG',OR,3,7,EQ,C'TUVWXYZ'),AND,
*
(1,1,EQ,C'E'))
*
END
WER268A OUTFIL STATEMENT : SYNTAX ERROR
WER275A NO KEYWORDS FOUND ON CONTROL STATEMENT
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Fri Feb 26, 2010 8:20 pm Post subject:
You have INCLUDE COND= for OUTFIL instead of INCLUDE= and you are missing the format fields. This works with DFSORT so I assume it will work with Syncsort as well (I don't usually answer Syncsort questions, but the Syncsort guys on the East Coast have probably gone home by now and I'm feeling generous with the weekend coming up).
_________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum