Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Finding total number of records in PDS

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
meetasn

New User


Joined: 23 May 2006
Posts: 8

PostPosted: Thu Aug 13, 2009 3:05 am    Post subject: Finding total number of records in PDS
Reply with quote

I have flat file which contains 140 pds member names.
I have PDS with 1200 members.

Question: How to find total number of lines for all(140) the pds members comparing with PDS that has 1200? Is it posible to do it in one shot, how to achieve it?
Back to top
View user's profile Send private message

gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Thu Aug 13, 2009 4:14 am    Post subject:
Reply with quote

Hi,

can you please explain what this means
Quote:
Is it posible to do it in one shot, how to achieve it?



Does one shot mean 1 step, 1 job or something else ?


Gerry
Back to top
View user's profile Send private message
meetasn

New User


Joined: 23 May 2006
Posts: 8

PostPosted: Thu Aug 13, 2009 7:36 am    Post subject:
Reply with quote

Is it possible to achieve in one step or we need multiple steps to do it? If so please some one can tell me how to achieve it.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Aug 13, 2009 7:53 am    Post subject:
Reply with quote

Hello,

Use the file with the member names to generate the jcl to concatenate all of the members as a single sort input file. Then use your sort product to either create an output file with only a trailer containing the count or copy the file to a dummy output file and the count will be in the informational output generated by the sort.
Back to top
View user's profile Send private message
meetasn

New User


Joined: 23 May 2006
Posts: 8

PostPosted: Thu Aug 13, 2009 8:20 am    Post subject:
Reply with quote

Thanks Dick
I understand the second step. But question in first step

Use the file with the member names to generate the jcl to concatenate all of the members as a single sort input file?

1.does we need to put manually concatenation for all pds members in sortin.

Like edit sequential file and using ispf edit commands changing all members names look like // dd dsn=uid.XX.pds(member),disp=shr , cut and copying all this lines into sortin file of sort step in jcl.

Please let me know, If there is any other easy way to get it done?

I have another question

If we have 50 member names in sequential file, how copy all those members from a pds having 1500 memers to another new pds? Is ther any good trick to do this
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Aug 13, 2009 8:31 am    Post subject:
Reply with quote

Hello,

Quote:

1.does we need to put manually concatenation for all pds members in sortin.
Manually with the editor (which i'd probably do for ao 1-time requirement) or with some bit of code (rexx, sort control, cobol, whatever)

Quote:
Is ther any good trick to do this
Not a trick, but simply allocate the new pds and copy (tso/ispf 3.3 maybe) the 50 members from the original pds to the new one by placing an "S" on the member names to be copied.
Back to top
View user's profile Send private message
meetasn

New User


Joined: 23 May 2006
Posts: 8

PostPosted: Thu Aug 13, 2009 8:45 am    Post subject:
Reply with quote

Thank you very much dick

Quote:
Not a trick, but simply allocate the new pds and copy (tso/ispf 3.3 maybe) the 50 members from the original pds to the new one by placing an "S" on the member names to be copied.

For 50 members we can do copy option, suppose if we have 500 members to copy it will take more time for selecting from 1500 members. So thats why I asked Is there any way to do it programatically?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Aug 13, 2009 8:54 am    Post subject:
Reply with quote

Hello,

Sure, it can be done programatically. Similar to generating the concatenated DDs for a sort input, generate all of the copy statements.

The questions one must answer is:
Is it a one-time shot or will this be needed periodically?
If there is nothing to "clone" from to do this, how long will it take to create and test?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts what is meaning of the number in dcl Martylin PL/I & Assembler 2 Thu Mar 09, 2017 7:18 am
No new posts Join giving more records than expected Danielle.Filteau SYNCSORT 2 Thu Mar 09, 2017 3:28 am
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts Extract set of records matching on ac... bhaskar_kanteti DFSORT/ICETOOL 3 Mon Mar 06, 2017 7:19 am
No new posts GDG version number PANDU1 JCL & VSAM 4 Sat Mar 04, 2017 8:28 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us