Good morning,
I have a SORT step that uses ICETOOL to perform a SELECT for a group of records.
In addition I have included NULLOFL=RC4 with the SORT Control Statements.
Basically, I wanted to raise RC=4 when the output file from the SORT is empty.
I can work around this, but wanted to check to see if I am missing something.
When the SORT STEP completes, I now see an empty file and a return code of zero.
When I SORT an empty file, I see a RC=0 rather than RC=4.
Is NULLOFL ignored when ICETOOL is present?
ICETOOL Control Statements:
SELECT FROM(LOG31IN)-
TO(LOG31OUT)-
ON(001,49,CH)-
LAST-
USING(LG31)
SORT Control Statement:
INCLUDE COND=((029,08,CH,EQ,C'DRKBM100',OR,
029,08,CH,EQ,C'DRKBM300'),AND,
111,04,CH,EQ,C'001H',OR,
111,04,CH,EQ,C'002H')
INREC FIELDS=(049,19,
111,04,
003,26,
071,01,
108,03,
171,18,
131,18)
SORT FIELDS=(001,19,A,
020,04,A,
041,26,A,
050,01,D),FORMAT=BI
OUTFIL FNAMES=LOG31OUT,NULLOFL=RC4
END
Thanks
Cameron Conacher
Senior Engineer
American Express Canada Inc.
GCICS
2225 Sheppard Avenue East, Toronto, ON M2J 5C2
[email protected]<mailto:[email protected]>
Office: 1-437-836-5265
Mobile: 1-416-409-5147
https://amex.webex.com/join/cameron.conacher
________________________________
American Express made the following annotations
________________________________
This e-mail was sent to you by a representative of Amex Bank of Canada, P.O.
Box 3204, Station "F", Toronto, ON, M1W 3W7, www.americanexpress.ca. If you no
longer wish to receive these e-mails, please notify the sender by reply e-mail.
This e-mail is solely for the intended recipient and may contain confidential
or privileged information. If you are not the intended recipient, any
disclosure, copying, use, or distribution of the information included in this
e-mail is prohibited. If you have received this e-mail in error, please notify
the sender by reply e-mail and immediately and permanently delete this e-mail
and any attachments. Thank you.
American Express a fait les remarques suivantes
Ce courriel vous a ?t? envoy? par un repr?sentant de la Banque Amex du Canada,
C.P. 3204, succursale F, Toronto (Ontario) M1W 3W7, www.americanexpress.ca. Si,
par la suite, vous ne souhaitez plus recevoir ces courriels, veuillez en aviser
les exp?diteurs par courriel.
Ce courriel est r?serv? au seul destinataire indiqu? et peut renfermer des
renseignements confidentiels et privil?gi?s. Si vous n'?tes pas le destinataire
pr?vu, toute divulgation, duplication, utilisation ou distribution du courriel
est interdite. Si vous avez re?u ce courriel par erreur, veuillez en aviser
l'exp?diteur par courriel et d?truire imm?diatement le courriel et toute pi?ce
jointe. Merci.
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
