Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Copying VSAM to VSAM with variable records.

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

New User


Joined: 12 Oct 2015
Posts: 1
Location: India

PostPosted: Mon Oct 12, 2015 5:00 pm    Post subject: Copying VSAM to VSAM with variable records.
Reply with quote

Hi,
This is my first post here, I have the following scenario. Could someone provide your suggession,

I need to copy a VSAM file with LRECL of 442 to LRECL of 642 and reformat the records like this -

VSAM1: The minimum record length is 221 and maximum of 442.
VSAM2: The minimum record length is 321 and maximum of 642.

The condition here is - if position 85,3,CH = 88,3,CH, then,
Build - (1:1,221,222:100X)
if condition doesnt match i.e, 85,3,CH Not = 88,3,CH, then,
Build (1:1,221,222:100X,322:222,221,543:100X).

Please note my vsam is defined with noreuse. Could you please provide a solution to this ?
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7312

PostPosted: Mon Oct 12, 2015 5:28 pm    Post subject: Reply to: Copying VSAM to VSAM with variable records.
Reply with quote

Firstly, you are making life difficult for yourself and others with your BUILD, by including columns where they are not needed:
Code:

Build - (1:1,221,222:100X)
Build (1:1,221,222:100X,322:222,221,543:100X)


Code:
BUILD=(1,221,100X)
BUILD=(1,221,100X,222,221,100X)


And even using BUILD:

Code:
OVERLAY=(1,221,100X)


The second BUILD you can leave as BUILD for clarity. To use OVERLAY you'd have to use columns, and be careful with the order of them. So stick to BUILD.

However, if you want variable-length VSAM records, you need to tell DFSORT that. Look at the RECORD Control Statement in the Application Programming Guide and note what is needed for VSAM.

If your output is NOREUSE, you should be able to deal with that in the normal way.
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 Need SQL for two latest records havin... Q5P418 DB2 10 Sun May 10, 2020 8:24 am
No new posts Unable to download the JDBC driver to... mrayandutta Java & MQSeries 1 Tue Apr 28, 2020 8:59 pm
No new posts Compare Two datasets and Override Mat... ArunkumarGanesan DFSORT/ICETOOL 7 Mon Apr 27, 2020 7:45 pm
No new posts Splice multiple records into single r... sarankriya DFSORT/ICETOOL 4 Wed Apr 15, 2020 10:55 pm
No new posts Include Group record based on detail ... guptae DFSORT/ICETOOL 11 Thu Mar 12, 2020 1:54 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us