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
 

 

Pull records from a Master file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
alexshan

New User


Joined: 06 Apr 2007
Posts: 5
Location: China

PostPosted: Thu May 22, 2008 7:01 am    Post subject: Pull records from a Master file
Reply with quote

We are trying to pull a large number of records (2 million accounts) from a large data set(VSAM). I have one file(VSAM/NON-VSAM) that contains these 2 million account numbers. Can I do this using DFSORT? It's like a table lookup function, except in this case, the table is just a bit on the huge side. Thanks for any insight you can
provide me.
Back to top
View user's profile Send private message

gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Thu May 22, 2008 8:54 am    Post subject:
Reply with quote

Hi,
the above has been cut and pasted from Smart DFSORT tricks which also provides a fairly self explanatory example.

So I'm not sure why the question.


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

New User


Joined: 06 Apr 2007
Posts: 5
Location: China

PostPosted: Thu May 22, 2008 2:55 pm    Post subject:
Reply with quote

gcicchet wrote:
Hi,
the above has been cut and pasted from Smart DFSORT tricks which also provides a fairly self explanatory example.

So I'm not sure why the question.


Gerry


the example at Smart DFSORT tricks JCL only works at Non-Vsam
but I want pull some records from a Vsam
So I post them,ask this question

thanks for ur reply
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Thu May 22, 2008 9:07 pm    Post subject:
Reply with quote

You can use that trick with a VSAM file ... just copy the VSAM file to a nonVSAM file first.
Back to top
View user's profile Send private message
alexshan

New User


Joined: 06 Apr 2007
Posts: 5
Location: China

PostPosted: Fri May 23, 2008 7:03 am    Post subject:
Reply with quote

Frank Yaeger wrote:
You can use that trick with a VSAM file ... just copy the VSAM file to a nonVSAM file first.


it's a large data set....really large at my environment
it takes too many spaces when copy from VSAM to Non-VSAM
and long time...
So,I want pull some records directly from the VSAM master file

thank you for your reply
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Fri May 23, 2008 8:04 pm    Post subject:
Reply with quote

The problem is that you can't use concatenation with a VSAM file.

How about copying the VSAM file to a nonVSAM file on tape rather than disk?

This might be a case where it's better to write a program or exit (E15 or E35) that pulls the recods rather than using a DFSORT trick. It won't take as much space, but it might still take a "long time" depending on how you're pulling the records.
Back to top
View user's profile Send private message
alexshan

New User


Joined: 06 Apr 2007
Posts: 5
Location: China

PostPosted: Fri May 23, 2008 10:47 pm    Post subject:
Reply with quote

Frank Yaeger wrote:
The problem is that you can't use concatenation with a VSAM file.

How about copying the VSAM file to a nonVSAM file on tape rather than disk?

This might be a case where it's better to write a program or exit (E15 or E35) that pulls the recods rather than using a DFSORT trick. It won't take as much space, but it might still take a "long time" depending on how you're pulling the records.


I see...
anyway,I perfer DFSORT to do this kind of job thanks to its efficiency
So I recombine the small file (store the account number) as sort sysin
(include cond=...)
then use it pull record from the VSAM Master File

thank you for your help
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Fri May 23, 2008 11:07 pm    Post subject:
Reply with quote

Quote:
So I recombine the small file (store the account number) as sort sysin (include cond=...)


You originally said:

Quote:
We are trying to pull a large number of records (2 million accounts) from a large data set(VSAM).


which I interpreted as meaning that you had 2 million account numbers that you wanted to pull. Of course, you can't specify 2 million INCLUDE conditions so I didn't suggest that. If you're using INCLUDE to do this, then you must have a significantly smaller number of account numbers to pull (thousands or less).
Back to top
View user's profile Send private message
alexshan

New User


Joined: 06 Apr 2007
Posts: 5
Location: China

PostPosted: Fri May 23, 2008 11:31 pm    Post subject:
Reply with quote

Frank Yaeger wrote:
which I interpreted as meaning that you had 2 million account numbers that you wanted to pull. Of course, you can't specify 2 million INCLUDE conditions so I didn't suggest that. If you're using INCLUDE to do this, then you must have a significantly smaller number of account numbers to pull (thousands or less).


"2 million" this figure is appropriate
Therefore, I have just mentioned approach is not very appropriate...
So it seems now that conver the VSAMtoNon-VSAM is the fastest solution
right?
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Fri May 23, 2008 11:51 pm    Post subject:
Reply with quote

I would suspect so.
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Split file based on comparsion to 2 f... Div Grad DFSORT/ICETOOL 3 Thu Jul 27, 2017 9:16 pm
No new posts Extra character appears in file when ... Balu5491 All Other Mainframe Topics 1 Wed Jul 26, 2017 2:39 pm
No new posts SSH - known_hosts file configuration vasanthz All Other Mainframe Topics 2 Wed Jul 26, 2017 2:10 am
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Write out NODUPS but just from one file Jay Villaverde DFSORT/ICETOOL 8 Fri Jul 14, 2017 12:44 am


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