Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 sort records based on length exceeds ... maxsubrat DFSORT/ICETOOL 7 Wed Oct 04, 2017 4:48 pm
No new posts Addition of two records on 2 fields amar143 SYNCSORT 8 Tue Oct 03, 2017 11:14 am
No new posts Execute JCL step based on the content... sprikitik JCL & VSAM 2 Tue Oct 03, 2017 10:03 am
This topic is locked: you cannot edit posts or make replies. PS file data should be passed as symb... d_sarlie JCL & VSAM 15 Tue Oct 03, 2017 5:18 am
No new posts Garbage on output file Hervey Martinez SYNCSORT 4 Wed Sep 27, 2017 12:50 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us