MVSFORUMS.com

Veera333 · Beginner Joined: 16 Jul 2010 Posts: 7 Topics: 5

Hi,

I have a requirement as follows

I have a file with Columns: Name,Designation, Band

I have to extract all the records with designation as 'Engineer'

Then If band is 'E' i have populate 10 after Band field else i have to populate 0 (conditional population)

Please suggest me a sort card/Icetool for this requirement.

Thanks in advance,
Veera

Nic Clouston · Posted: Sun Dec 05, 2010 9:55 am Post subject:

1 - why not post in the SORT section?
2 -What is the layout of your input record, column start/end of your fields and datatype of your fields? By the way, input records have fields not columns, or is your input a DB2 table?
3 - What is the layout of your output record?
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.

kolusu · Posted: Sun Dec 05, 2010 3:20 pm Post subject:

Veera333,

As Nic Pointed out, you need to provide more details. Here is a untested DFSORT JCL which will give you the desired results.

I assumed the name is 20 bytes and designation is 10 bytes and band is 1 byte and the update of the level is at position 35