|
View previous topic :: View next topic
|
| Author |
Message |
hac
New User
Joined: 18 Jan 2008
Posts: 30
Location: mumbai
|
|
|
|
| how to merge data sets using IEBGENER. |
|
| Back to top |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
| Do you mean concatenate ? |
|
| Back to top |
|
|
hac
New User
Joined: 18 Jan 2008
Posts: 30
Location: mumbai
|
|
|
|
| yes |
|
| Back to top |
|
|
Aaru
Senior Member
Joined: 03 Jul 2007
Posts: 1287
Location: Chennai, India
|
|
|
|
hac,
Just provide the dataset names that needs to be concatenated only by one across the SYSUT1 DD.
| Code: |
//SYSUT1 DD DSN=FILE1,DISP=SHR
// DD DSN=FILE2,DISP=SHR
|
|
|
| Back to top |
|
|
the_gautam
Active User
Joined: 05 Jun 2005
Posts: 165
Location: Bangalore
|
|
|
|
| do you mean the concatenation of dataset names or the merging of data? |
|
| Back to top |
|
|
hac
New User
Joined: 18 Jan 2008
Posts: 30
Location: mumbai
|
|
|
|
thanx Aaru
what if i want to merge data |
|
| Back to top |
|
|
Phrzby Phil
Senior Member
Joined: 31 Oct 2006
Posts: 1042
Location: Richmond, Virginia
|
|
|
|
| This is not an IEBGENER question - just a concatenate question. You concatenate datasets the same way for any program. |
|
| Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA
|
|
|
|
| the_gautam wrote: |
| do you mean the concatenation of dataset names or the merging of data? |
IT MEANS THAT THE DATA FROM THE TWO SYSUT1 FILES WILL BE CONCATENATED IN THE OUTPUT FILE. IF YOU WANT TO MERGE THE TWO FILES YOU NEED TO USE A SORT PRODUCT. |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
hac,
If you want to merge the files, each file must already be in sorted order. A DFSORT merge looks like this:
| Code: |
//S1 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN01 DD DSN=... input file1
//SORTIN02 DD DSN=... input file2
//SORTOUT DD DSN=... output file
//SYSIN DD *
MERGE FIELDS=(p,m,f,s)
|
where p is the starting position of the key, m is its length, f is its format and s is A for ascending or D for descending. For example:
11,10,CH,A
You can also use DFSORT to sort or copy files.
If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:
Use [URL] BBCode for External Links |
|
| Back to top |
|
|
hac
New User
Joined: 18 Jan 2008
Posts: 30
Location: mumbai
|
|
|
|
| thanx for the help Frank Yaeger |
|
| Back to top |
|
|
|
|
