MVSFORUMS.com

[mitvvce]

Hi,
I am a beginner and i think this is a very basic question..
suppose i have the following input record

aaaaa 11111
bbbbb 22222

Out Put should like

11111
22222

Can anybody help me with the JCL

[Nic Clouston]

JCL cannot help you with this. I presume this is a DB2 table in that you mention COLUMN in the topic title.

Assume the table is called ATABLE and the columns are called COL1 and COL2:

SELECT COL2
FROM ATABLE;
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.

[mitvvce]

Thanks for the quick response.
I wanted to use some sort utility in JCL to extract only the second column values from the Input Sequential file. I tried OUTREC and it Worked..