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

Replace Value in SYSIN member


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

New User


Joined: 26 Sep 2006
Posts: 6

PostPosted: Tue Sep 26, 2006 5:56 pm
Reply with quote

//STEP1 EXEC MLOAD
//DATABASE SET DATABASE='$DEV'
//SYSIN DD DSN=A.B.C(D)

In member D, I have value '$DATABASE'. I want to change all occurance of '$DATABASE' to 'DEV'. I tried with IEBGENER/IEBCOPY/IEBUPDT and others. I couldn't abla to replace values in member.


My requirment is just to change DATABASE name '$DEV' to '$PROD' while moving code from development to Production.

Could you please help??
Back to top
View user's profile Send private message
superk

Global Moderator


Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA

PostPosted: Tue Sep 26, 2006 6:07 pm
Reply with quote

Edit it:

TSO EDIT 'A.B.C(D)' DATA NONUM
TOP
C * '$DEV' '$PROD' ALL
TOP
END SAVE
Back to top
View user's profile Send private message
murali922

New User


Joined: 25 Jul 2005
Posts: 92
Location: India

PostPosted: Tue Sep 26, 2006 6:10 pm
Reply with quote

What is member D ? Is it a catalogued procedure ?
What is MLOAD is a COBOL program ?

If it is a catalogued procedure, try

Code:
//STEP1 EXEC <catalogued prcedure name>,DATABASE=DEV


this would replace all occurances of DATABASE with DEV
Back to top
View user's profile Send private message
anad99

New User


Joined: 26 Sep 2006
Posts: 6

PostPosted: Tue Sep 26, 2006 6:17 pm
Reply with quote

This is MLOAD is Teradata Database utility for loading records from files to table. But I want to change $DEV to $PROD and send it client for production. like below

//STEP1 EXEC MLOAD
//*DATABASE SET DATABASE='$DEV'
//DATABASE SET DATABASE='$PROD'
//SYSIN DD DSN=A.B.C(D)

I don't want to do manually...
Thanks..
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 Replace each space in cobol string wi... COBOL Programming 3
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts replace word 'MONTH' with current mon... SYNCSORT 11
No new posts How to copy the -1 version of a membe... TSO/ISPF 4
No new posts Searching for a member but don't know... TSO/ISPF 6
Search our Forums:

Back to Top