|
View previous topic :: View next topic
|
| Author |
Message |
Brahmananda Reddy Manipi
Currently Banned
New User
Joined: 22 Jul 2008
Posts: 13
Location: Bangalore
|
|
|
|
| Hi All Please let me know how to concatinate two VSAM datsets in ICETOOL STEP. |
|
| Back to top |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
You CAN NOT concatenate VSAM files as you do with normal non VSAM files.
You need to develop some sort of logic to do what you want - maybe copy the two VSAM files to two flat files and then sort the concatenated flat files. |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
Hi,
Please check this link :
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DGT2D430/CCONTENTS?DT=20040624112123
section "3.6.3 Concatenating Data Sets Sequentially":
| Quote: |
A sequential concatenation can include sequential data sets, PDS members, PDSE members, and UNIX files. With sequential concatenation, the system treats a PDS, PDSE, or UNIX member as if it were a sequential data set. The system treats a striped extended-format data set as if it were a single-volume data set.
Rule: You cannot concatenate VSAM data sets. |
|
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
Hello Brahma,
What exactly you want to accomplish, if you tell us that - may be there can be some alternatives, something like:
1. REPRO both files into flat files.
2. Concatenate the files and eliminate any duplicates in key(SORT)
3. Load to your new VSAM. |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
This thread has come up with some "glue" I think..I keep on coming..Hello again.. 
You could merge them using;
| Code: |
//SORTIN01 DD DISP=SHR,vsam.file1
//SORTIN02 DD DISP=SHR,vsam.file2
MERGE FIELDS=(....) |
But this presumes they are already in the sort-order that you desire.
Hopethis helps.. |
|
| Back to top |
|
|
|
|
