MVSFORUMS.com :: View topic

through

[^/[Print]\]

MVSFORUMS.com -> Job Control Language(JCL)

#1: SORT CARD Author: arun.chand,

Posted: Fri Oct 06, 2006 1:51 am
—
Hi,

Can anyone please help me to deal with the following situation.

I have to sort some records based on a particular field. But I want to exclude the record if that particular field in the record is NOT numeric or Alphabetic. That is if the field has values(#$%&^@!), I want to eliminate that record from the output file. My output file should contain records with numeric or alphabet for that particular field. How to prepare my sort card.

Thx
Arun

#2: Author: kolusu, Location: San Jose

Posted: Fri Oct 06, 2006 5:11 am
—
arun.chand,

Try this

Code:

OMIT COND=(10,1,SS,EQ,C'!@#$%^&*()')
SORT FIELDS=(P,M,F)

where p = position of the field to be sorted
m = length of the field to be sorted
f = format of the field to be sorted

Hope this helps...

Cheers

Kolusu

MVSFORUMS.com -> Job Control Language(JCL)

output generated using printer-friendly topic mod. All times are GMT - 5 Hours

Page 1 of 1