IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Find counts of 'PS files' which are inside a PS file.


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
techslam

New User


Joined: 03 Dec 2010
Posts: 87
Location: India

PostPosted: Tue Jan 17, 2012 6:40 pm
Reply with quote

Hi,

I have an input file which has 10 records. These 10 records are infact names of different PS files.

Input File - LRECL=80, FB
Code:

FILE0 TESTFILE.INPUT0.ABC
FILE1 TESTFILE.INPUT1.ABC
FILE2 TESTFILE.INPUT2.ABC
FILE3 TESTFILE.INPUT3.ABC
FILE4 TESTFILE.INPUT4.ABC
FILE5 TESTFILE.INPUT5.ABC
FILE6 TESTFILE.INPUT6.ABC
FILE7 TESTFILE.INPUT7.ABC
FILE8 TESTFILE.INPUT8.ABC
FILE9 TESTFILE.INPUT9.ABC


Expected output file must have the record count(at position 30 and length=5) details of each of the file names present inside the above input file --

Expected Output . LRECL=80, FB
Code:

FILE0 TESTFILE.INPUT0.ABC    1000
FILE1 TESTFILE.INPUT1.ABC    3000
FILE2 TESTFILE.INPUT2.ABC    0500
FILE3 TESTFILE.INPUT3.ABC    0001
FILE4 TESTFILE.INPUT4.ABC    1485
FILE5 TESTFILE.INPUT5.ABC    5246
FILE6 TESTFILE.INPUT6.ABC    7854
FILE7 TESTFILE.INPUT7.ABC    0023
FILE8 TESTFILE.INPUT8.ABC    1201
FILE9 TESTFILE.INPUT9.ABC    0010


Please guide if this is possible through SORT.

Thanks a lot !
Back to top
View user's profile Send private message
Gnanas N

Active Member


Joined: 06 Sep 2007
Posts: 792
Location: Chennai, India

PostPosted: Tue Jan 17, 2012 7:16 pm
Reply with quote

Hi,

Just a pointer.

You can use ICETOOL's Count operation from REXX.

In REXX, Read input and get the data set names, form ICETOOL call and get/write the record count, write into out data set.

Submit REXX exec in batch.

Here is the example to call ICETOOL from REXX.

publib.boulder.ibm.com/infocenter/zos/v1r12/index.jsp?topic=%2Fcom.ibm.zos.r12.icea100%2Fice1ca50259.htm

Please correct me if I'm wrong.
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Tue Jan 17, 2012 7:44 pm
Reply with quote

Another possibility, from a similar previous discussion, here.
Back to top
View user's profile Send private message
techslam

New User


Joined: 03 Dec 2010
Posts: 87
Location: India

PostPosted: Thu Jan 19, 2012 2:45 pm
Reply with quote

@Bill

Thanks for above link. That did help icon_smile.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files(F1 & F2) and writ... JCL & VSAM 8
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 8
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
Search our Forums:

Back to Top