View previous topic :: View next topic
|
Author |
Message |
prabs2006
Active User
Joined: 12 Jan 2006 Posts: 103
|
|
|
|
Hi,
Is it possible for us to perform all sort features on a VSAM file?
T & R
Prabs |
|
Back to top |
|
|
priyesh.agrawal
Senior Member
Joined: 28 Mar 2005 Posts: 1448 Location: Chicago, IL
|
|
|
|
Prabs,
I have been using VSAM files with SORT ... are you asking for any perticular SORT feature....
Regards,
Priyesh. |
|
Back to top |
|
|
prabs2006
Active User
Joined: 12 Jan 2006 Posts: 103
|
|
|
|
No. I have just asked generally. So whatever sort features applied to flat file can be applied for VSAM file, right?
T & R
Prabs |
|
Back to top |
|
|
Pollyannaish
New User
Joined: 09 Jul 2005 Posts: 31 Location: Pune, India
|
|
|
|
Ya prabs
you are right but it is just that you can't concatenate VSAM files while sorting as you can do with sequential files . |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Quote: |
I have just asked generally. So whatever sort features applied to flat file can be applied for VSAM file, right? |
If you're asking about DFSORT control statements and parameters, the answer is generally yes. However, there are some DFSORT parameters specifically for VSAM files such as VSAMIO, RESET, CINV and VSAMEMT.
You also have the option of processing VSAM input files as variable-length or fixed-length.
See the following for more information:
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA10/1.8.3.4?SHELF=&DT=20050222160456&CASE=
Quote: |
you can't concatenate VSAM files while sorting as you can do with sequential files |
True, but note that's a system restriction, not just a DFSORT restriction. |
|
Back to top |
|
|
prabs2006
Active User
Joined: 12 Jan 2006 Posts: 103
|
|
|
|
So how about the output file then? I believe it would be already created and defined. What will be the properties given?(disp=shr) Can you please give me a sample example (to copy or extract some recs)?
Also I would like to know whether the properties of both the input and output files shud be strictly same?
T & R
Prabs |
|
Back to top |
|
|
prabs2006
Active User
Joined: 12 Jan 2006 Posts: 103
|
|
|
|
I think I shud make myself clear with my Q in the previous post.
What would be the output file(a FLAT or VSAM file?) when sorting an input VSAM file? Is it possible to give a vsam file in the output?
Please bear with me if am going awfully wrong.Thanks
T & R
Prabs |
|
Back to top |
|
|
Rupesh.Kothari
Member of the Month
Joined: 27 Apr 2005 Posts: 463
|
|
|
|
HI,
Quote: |
What would be the output file(a FLAT or VSAM file?) when sorting an input VSAM file? Is it possible to give a vsam file in the output? |
I believe, output file should be flat file.
Regards
Rupesh |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
You decide whether the output file will be a VSAM file or non-VSAM file by specifying the appropriate SORTOUT DD statement. If you want a non-VSAM file, DFSORT will fill in the attributes. If you want a VSAM file, you have to define the attributes in the normal way
Quote: |
Also I would like to know whether the properties of both the input and output files shud be strictly same? |
Again, that's up to you. For example, you could use OUTREC to change the length of the output records. |
|
Back to top |
|
|
|