I am trying to output multiple SORTOUT records from a single input record in a
SORT step when a "LABEL1" line is processed. This is the syntax I am using and
the error message that I get:
OPTION COPY
OUTFIL FNAMES=SORTOUT,
IFTHEN=(WHEN=(9,6,CH,EQ,C'LABEL1'),
BUILD=(1,4,C' SELECT *',/,
*
1.4,C' FROM DBXX.TABLE1 WHERE',/,
1,4,C' FIELD1 IN (''XXXXXXX')),
IFTHEN=(WHEN=NONE,
BUILD=(1,4,C' , ''',9,7,C''''))
WER813I INSTALLATION OPTIONS IN MFX LOAD LIBRARY WILL BE USED
WER271A OUTFIL STATEMENT : NUMERIC FIELD ERROR
WER578I SORTL INSTRUCTION NOT USED; REASON CODE=FE
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
I can't seem to format this example precisely in plain text email, but the "*"
syntax pointer is under the "/" entry on the first BUILD line. It does not
like the "/" entry for "new record", but I do not understand why that isn't
allowed. I have tried using both OUTFIL and OUTREC and neither one seems to
allow the "/" entry.
SORTIN and SOUTOUT are both RECFM=VB,LRECL=8192,DSORG=PS.
Would someone please point out what I need to code to accomplish this task?
Peter
--
This message and any attachments are intended only for the use of the addressee
and may contain information that is privileged and confidential. If the reader
of the message is not the intended recipient or an authorized representative of
the intended recipient, you are hereby notified that any dissemination of this
communication is strictly prohibited. If you have received this communication
in error, please notify us immediately by e-mail and delete the message and any
attachments from your system.
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
