DB Change Utility "ucybchng" does not change contents of pre-process tab of JOB Script

Document ID : KB000088196
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
N/A

The DB change utility, ucybchng, does not change the contents of the pre-process tab of a JOB Script.

Investigation

Script:
REPLACE_PART *, *ETL.DWMSSS*, SCRIPT, 'GAS1', 'GAS_PROD'
 
Before change:
:SET &USER# = GET_LOGIN(&LOGIN#,GAS1,GAS1,LOGIN_INFO) :SET &PASSWD# = GET_LOGIN(&LOGIN#,GAS1,GAS1,PASSWORD)

After change:
:SET &USER# = GET_LOGIN(&LOGIN#,GAS1,GAS1,LOGIN_INFO) :SET &PASSWD# = GET_LOGIN(&LOGIN#,GAS1,GAS1,PASSWORD)

The same script works on the process tab of a JOBI.
Environment:
OS Version: N/A
Cause:
Cause type:
Other
Root Cause: When using the DB change utility you must distinguish which tab the Automic script is on that you want to change in the transport case.
Resolution:
When using the DB Change Utility, you need to distinguish which tab the Automic script is on that you want to change in the transport case.

Only the Process tab script is changed when SCRIPT is used in the script statement below:
 
REPLACE_PART *, *ETL.DWMSSS*, SCRIPT, 'GAS1', 'GAS_PROD'

To replace the script on the Pre-Process and Post-Process tabs, the PSCRIPT and OSCRIPT attributes must be used. So to make a change on the Pre-Process tab, you would use the following:

REPLACE_PART *, *ETL.DWMSSS*, PSCRIPT, 'GAS1', 'GAS_PROD'


Fix Status: No Fix

Fix Version(s):
N/A
Additional Information:
Workaround :
N/A