IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

I want to concatenate 3 files and copy into out put file.


IBM Mainframe Forums -> JCL & VSAM
Post new topic   This topic is locked: you cannot edit posts or make replies.
View previous topic :: View next topic  
Author Message
kotesh

New User


Joined: 11 May 2005
Posts: 20

PostPosted: Wed Jul 20, 2011 11:38 am
Reply with quote

hi ,

I want to concatenate 3 files and copy into out put file.

I don't have any ICETOOL.
can we do it thru IEBGENER?

how to do it in a single step ...plz let me know the coding
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Wed Jul 20, 2011 11:47 am
Reply with quote

when You have questions You should start a new topic icon_evil.gif
Your other question on the same issue was deleted
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1742
Location: Tirupur, India

PostPosted: Wed Jul 20, 2011 11:58 am
Reply with quote

concatenating DD statements on SYSUT1 + IEBGENER.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Wed Jul 20, 2011 12:30 pm
Reply with quote

Vas, you are assuming that you have enough information from the OP here.

If the files are not of the same DSORG, RECFM and LRECL ?

So OP, can we have some useful information please icon_evil.gif

Suggest you also post which sort product and release level you have installed.
Back to top
View user's profile Send private message
balanaidu

New User


Joined: 18 Sep 2006
Posts: 3
Location: banglore

PostPosted: Wed Jul 20, 2011 1:40 pm
Reply with quote

kotesh wrote:
hi ,

I want to concatenate 3 files and copy into out put file.

I don't have any ICETOOL.
can we do it thru IEBGENER?

how to do it in a single step ...plz let me know the coding


I think you can do lik this

//STEP01 EXEC PGM=IEBGENER
//SYSUT1 DD DSN=DATASET1,DISP=OLD
// DSN=DATASET2,DISP=OLD
// DSN=DATASET3,DISP=OLD
//SYSUT2 DD DSN=DATASET4,DISP=OLD

Please correct me IF iam wrong

Thanks and Regards,
V.Bala Naidu
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Wed Jul 20, 2011 1:49 pm
Reply with quote

balanaidu

Please read my post above before commenting
Back to top
View user's profile Send private message
prasanth_thavva

New User


Joined: 28 Jul 2005
Posts: 86
Location: Chennai

PostPosted: Wed Jul 20, 2011 2:27 pm
Reply with quote

balanaidu ,

Yes , expat is obsolutly right, there is no proper information provided by the kotesh for RECFM,LRECL...etc information required for concatenation.other wise you need make all the files in the same format using syncsort and combine using IEBGENER.and also we need to know how the outfile should Fixed.Variable....LREC...all those information required.

Below jcl. DD keyword missing for 2nd and 3rd data sets.

//STEP01 EXEC PGM=IEBGENER
//SYSUT1 DD DSN=DATASET1,DISP=OLD
// DSN=DATASET2,DISP=OLD
// DSN=DATASET3,DISP=OLD

//SYSUT2 DD DSN=DATASET4,DISP=OLD
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Wed Jul 20, 2011 4:40 pm
Reply with quote

Prasanth Thavva wrote:
Below jcl. DD keyword missing for 2nd and 3rd data sets.


Prasanth Thavva
you did not bother to test either.

the DD keyword must be there. It is the reference name that is not present in the second and subsequent files within a concatenation.
Back to top
View user's profile Send private message
csai1987

New User


Joined: 18 Jul 2011
Posts: 3
Location: chennai

PostPosted: Wed Jul 20, 2011 4:45 pm
Reply with quote

hi Friends,

dbzTHEdinosauer & prasanth_thavva

if we omit the DD name then only it will be concatenated. please dont bother those things.


Thanks,
C.Sai krishna
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Wed Jul 20, 2011 5:01 pm
Reply with quote

C.Sai krishna -- you are quite wrong. The concatenation MAY work, but if kotesh (the o/p) wants to concatenate a file with RECFM=VB,LRECL=27994,BLKSIZE=27998 with a file that is RECFM=FB,LRECL=17,BLKSZIE=17 and a file that is RECFM=VBS,LRECL=32760,BLKSIZE=4096 -- just how will the posted "solutions" work? The point dbz and expart are attempting to make is that the original post does not contain enough information to properly answer the question. And you are not helping the issue by giving wrong suggestions without knowing the full details.
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Wed Jul 20, 2011 5:34 pm
Reply with quote

Quote:
expart


There's one I didn't think of :-)
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Wed Jul 20, 2011 6:35 pm
Reply with quote

expat -- sorry about the typo! icon_redface.gif
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Wed Jul 20, 2011 6:36 pm
Reply with quote

topic locked

too much sloppiness and carelessness

unwillingness on the TS side to provide appropriate info for good replies
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Wed Jul 20, 2011 7:31 pm
Reply with quote

Robert Sample wrote:
expat -- sorry about the typo! icon_redface.gif

Just as well you didn't change the P to an F as well then icon_lol.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies. View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Write line by line from two files DFSORT/ICETOOL 7
No new posts Access to non cataloged VSAM file JCL & VSAM 18
Search our Forums:

Back to Top