Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Change values 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: Wed Sep 27, 2006 6:07 pm    Post subject: Change values 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.

MLOAD is load module in Teradata to load data into table from files.

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

//DATABASE SET DATABASE='$PROD'

I don't want to do it manually.. Like CHANGE ALL ..
Could you please help??
Thanks
Anand
Back to top
View user's profile Send private message

Kevin

Active User


Joined: 25 Aug 2005
Posts: 234

PostPosted: Wed Sep 27, 2006 8:43 pm    Post subject: Re: Change values in SYSIN member
Reply with quote

Anand:

The subject title for your post is "Change values in SYSIN member".

In the first line of your post, you state:
Quote:

In member D, I have value '$DATABASE'. I want to change all occurance of '$DATABASE' to 'DEV'.

I provided a possible solution to this in your other post for the same topic.

However, you then go on to state:
Quote:

My requirment is just to change DATABASE name in JCL '$DEV' to '$PROD'

Well, which is it? Do you need to change the contents of the PDS member, or do you need to change the contents of the job? You say:
Quote:

I don't want to do it manually.

How do you want this done? In batch? Through some sort of TSO or ISPF process?
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 LOW VALUES as a KEY juares castro DB2 10 Sat Apr 07, 2018 1:06 am
No new posts Repeat Sequence Number Until change i... rahulabvp DFSORT/ICETOOL 6 Thu Mar 29, 2018 12:51 pm
No new posts Query to compare 2 values of 1 column... Poha Eater DB2 13 Fri Mar 09, 2018 10:45 am
No new posts attchmvs from rexx subroutine that re... harisukumaran CLIST & REXX 1 Fri Jan 19, 2018 5:29 am
No new posts How to change the logon screen info o... sakthikumarT TSO/ISPF 4 Fri Dec 29, 2017 6:44 pm

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