SORT CARD To Extract Numeric Data



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

SORT CARD To Extract Numeric Data

Postby rtammire » Tue Nov 27, 2012 1:25 am

Hi All,

I want to extract numeric data from a record.

Input Record format is as follows
--------------------------------------
Loaded 138 rows into database
Loaded 12345 rows into database
Loaded 1 row into database
Loaded 1234567 rows into database

Now i want to extract only counts from these records

Expected Output
-------------------
00000138
00012345
00000001
01234567

Can any one please let me know how to get this by using sort card.. Thanks in advance
rtammire
 
Posts: 12
Joined: Tue Nov 27, 2012 1:19 am
Has thanked: 1 time
Been thanked: 0 time

Re: SORT CARD To Extract Numeric Data

Postby enrico-sorichetti » Tue Nov 27, 2012 1:36 am

Can any one please let me know how to get this by using sort card.. Thanks in advance


find out what sort product You are using and ask again in the proper forum section

WER***** messages are issued by SYNCSORT
ICE***** messages are issued by DFSORT

and... as You have already noticed there are forum sections for both products
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: SORT CARD To Extract Numeric Data

Postby rtammire » Tue Nov 27, 2012 8:20 am

We are using SYNCSORT.. OK i will update the same question in proper forum.. Thanks Enrico
rtammire
 
Posts: 12
Joined: Tue Nov 27, 2012 1:19 am
Has thanked: 1 time
Been thanked: 0 time


Return to JCL

 


  • Related topics
    Replies
    Views
    Last post