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

Merging vsam files with diff LRECL


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
prashantshinde

New User


Joined: 25 Nov 2005
Posts: 49
Location: Pune

PostPosted: Thu Jun 22, 2006 5:46 pm
Reply with quote

I have 5 vsam (ksds) files with different LRECL. Is it poss to merge these files? If yes... pls let me know?
Thanks
Back to top
View user's profile Send private message
DavidatK

Active Member


Joined: 22 Nov 2005
Posts: 700
Location: Troy, Michigan USA

PostPosted: Thu Jun 22, 2006 7:23 pm
Reply with quote

Is the KEY in the same location in each file?

Dave
Back to top
View user's profile Send private message
prashantshinde

New User


Joined: 25 Nov 2005
Posts: 49
Location: Pune

PostPosted: Thu Jun 22, 2006 7:29 pm
Reply with quote

Yes ,
key is at same location.

Plz give me the code
Back to top
View user's profile Send private message
DavidatK

Active Member


Joined: 22 Nov 2005
Posts: 700
Location: Troy, Michigan USA

PostPosted: Thu Jun 22, 2006 9:08 pm
Reply with quote

Define variable length VSAM file

Code:

//JS00100  EXEC PGM=IDCAMS                                           
//SYSIN DD *                                                         
  DEFINE                              -                               
      CLUSTER(                        -                               
          NAME(YOURID.VLR.TEST)        -                               
          KEYS(10 0)                  -                               
          RECSZ(30 60)                -   <== AVG AND MAX RECORD SIZE
          SPEED                       -                               
          REUSE                       -                               
          FSPC(0 0)                   -                               
          RECORDS(150))               -                               
      DATA(                           -                               
          NAME(YOURID.VLR.TEST.DATA)   -                               
          CISZ(4096))                 -                               
      INDEX(                          -                               
          NAME(YOURID.VLR.TEST.INDEX))                                 
/*                                                                   
//SYSPRINT DD SYSOUT=* 



REPRO your files into it

Code:

//JS00100  EXEC PGM=IDCAMS                       
//SYSPRINT DD SYSOUT=*                           
//SYSIN DD *                                     
  REPRO IDS('YOURID.PS.L30') ODS('YOURID.VLR.TEST')    <=== LRECL 30 file
  REPRO IDS('YOURID.PS.L60') ODS('YOURID.VLR.TEST')    <=== LRECL 60 file
/


Dave
Back to top
View user's profile Send private message
prashantshinde

New User


Joined: 25 Nov 2005
Posts: 49
Location: Pune

PostPosted: Fri Jun 23, 2006 10:19 am
Reply with quote

Hi Dave,

Thank u !!
ur code helped me !

Prashant.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 3
No new posts WER247A SORTOUT HAS INCOMPATIBLE LRECL SYNCSORT 7
No new posts Compare 2 files(F1 & F2) and writ... JCL & VSAM 8
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