View previous topic :: View next topic
|
Author |
Message |
anad99
New User
Joined: 26 Sep 2006 Posts: 6
|
|
|
|
//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 |
|
|
superk
Global Moderator
Joined: 26 Apr 2004 Posts: 4652 Location: Raleigh, NC, USA
|
|
|
|
Edit it:
TSO EDIT 'A.B.C(D)' DATA NONUM
TOP
C * '$DEV' '$PROD' ALL
TOP
END SAVE |
|
Back to top |
|
|
murali922
New User
Joined: 25 Jul 2005 Posts: 92 Location: India
|
|
|
|
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 |
|
|
anad99
New User
Joined: 26 Sep 2006 Posts: 6
|
|
|
|
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 |
|
|
|