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

JCL to move the values of one file to another file


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
krishnasaikiah

New User


Joined: 14 Mar 2007
Posts: 24
Location: gurgaon

PostPosted: Tue May 13, 2008 2:32 pm
Reply with quote

HI all,

I have a input file like this

01. INRECX1.
05. EMP NAME PIC X(10).
05. EMP ID PIC X(5).
05. EMP SAL PIC X(8).

The other input file has these three fields in addition to other 10 fields.

I need to move the values of these 3 fields from the first input file to the second file.The values of the other fields in the 2nd input file will remain the same.

Thus, I need to have one output file after moving the values of these three fields into the second input file.

I want to know whether this can be done thru JCL.

Because I dont want to write a program for just moving in the values.

Thanks
Krishna
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


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

PostPosted: Tue May 13, 2008 2:42 pm
Reply with quote

is there no matching of records? what are your 'rules' for merging the two files. You have provided 3 fields for 1 input file. what does the other input file look like?

what kind of matching logic do you want?

also, record lengths, field lengths and offsets.
Back to top
View user's profile Send private message
satheeshkamal

New User


Joined: 09 Jan 2007
Posts: 28
Location: Chennai

PostPosted: Tue May 13, 2008 2:49 pm
Reply with quote

See the "Join fields from two files record-by-record" Smart DFSORT Trick at:

www.ibm.com/servers/storage/support/software/sort/mvs/tricks/
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 -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 1
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts INCLUDE OMIT COND for Multiple values... DFSORT/ICETOOL 5
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
Search our Forums:

Back to Top