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
 

 

how to merge data sets using IEBGENER

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

New User


Joined: 18 Jan 2008
Posts: 30
Location: mumbai

PostPosted: Tue Jan 22, 2008 2:25 pm    Post subject: how to merge data sets using IEBGENER
Reply with quote

how to merge data sets using IEBGENER.
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Tue Jan 22, 2008 4:26 pm    Post subject:
Reply with quote

Do you mean concatenate ?
Back to top
View user's profile Send private message
hac

New User


Joined: 18 Jan 2008
Posts: 30
Location: mumbai

PostPosted: Tue Jan 22, 2008 4:31 pm    Post subject: Reply to: how to merge data sets using IEBGENER
Reply with quote

yes
Back to top
View user's profile Send private message
Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1288
Location: Chennai, India

PostPosted: Tue Jan 22, 2008 5:05 pm    Post subject: Reply to: how to merge data sets using IEBGENER
Reply with quote

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
View user's profile Send private message
the_gautam

Active User


Joined: 05 Jun 2005
Posts: 165
Location: Bangalore

PostPosted: Tue Jan 22, 2008 5:11 pm    Post subject:
Reply with quote

do you mean the concatenation of dataset names or the merging of data?
Back to top
View user's profile Send private message
hac

New User


Joined: 18 Jan 2008
Posts: 30
Location: mumbai

PostPosted: Tue Jan 22, 2008 5:42 pm    Post subject: Reply to: how to merge data sets using IEBGENER
Reply with quote

thanx Aaru

what if i want to merge data
Back to top
View user's profile Send private message
Phrzby Phil

Active Member


Joined: 31 Oct 2006
Posts: 962
Location: Richmond, Virginia

PostPosted: Tue Jan 22, 2008 6:24 pm    Post subject:
Reply with quote

This is not an IEBGENER question - just a concatenate question. You concatenate datasets the same way for any program.
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Tue Jan 22, 2008 6:27 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


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

PostPosted: Tue Jan 22, 2008 11:04 pm    Post subject:
Reply with quote

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:

www.ibm.com/servers/storage/support/software/sort/mvs/srtmpub.html
Back to top
View user's profile Send private message
hac

New User


Joined: 18 Jan 2008
Posts: 30
Location: mumbai

PostPosted: Wed Jan 23, 2008 9:29 am    Post subject: Reply to: how to merge data sets using IEBGENER
Reply with quote

thanx for the help Frank Yaeger
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 Data replication from multiple Db2 ta... kishpra DB2 5 Mon Mar 27, 2017 9:58 pm
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Append data from two files into a sin... Praveen04 DFSORT/ICETOOL 5 Thu Mar 16, 2017 7:29 pm
No new posts SPUFI -- Joining 3 tables – data in... Sysaron DB2 2 Wed Mar 08, 2017 4:18 am
No new posts Overriding PS data in rexx Shaheen Shaik CLIST & REXX 8 Fri Mar 03, 2017 5:08 pm


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