Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Replace Value in SYSIN member

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
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    Post subject: Replace Value in SYSIN member
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

Moderator Team Head


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

PostPosted: Tue Sep 26, 2006 6:07 pm    Post subject: Re: Replace Value in SYSIN member
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    Post subject: Re: Replace Value in SYSIN member
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    Post subject: Re: Replace Value in SYSIN member
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    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Fileaid Update Replace with null string descann Compuware & Other Tools 4 Mon May 15, 2017 3:00 pm
No new posts member list compare jzhardy TSO/ISPF 6 Fri May 12, 2017 3:18 pm
No new posts Replace values in the input data Vikas Maharnawar DFSORT/ICETOOL 10 Thu May 11, 2017 2:18 pm
No new posts Browsing member from any PDS shiitiizz CLIST & REXX 7 Wed Mar 08, 2017 1:17 am
No new posts Bind plan as a member to another bind... rexx77 DB2 0 Thu Feb 16, 2017 2:02 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us