DB Change Utility Doesn't Replace Entries in VARAs

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

The REPLACE script element does not replace the value of a static VARA as expected.

Investigation
Example:
REPLACE VARA, VARA.UC4#BASIS@RELEASE_INFO, *, "@@@RELEASEVERSION@@@", “xxxxxxxx”
REPLACE VARA, VARA.UC4#BASIS@RELEASE_INFO, *, "@@@RELEASEDATE@@@", “xxxxxxxx”
REPLACE VARA, VARA.UC4#BASIS@RELEASE_INFO, *, "@@@RELEASETICKET@@@", “xxxxxxxx”

Results
Actual:  The job report output shows the following result -
12:17:03 20160422/121703.210 - U00021412 Input script:
12:17:03 20160422/121703.211 - U00021411 Line '001': 'REPLACE VARA, VARA.UC4#BASIS@RELEASE_INFO, *, "@@@RELEASEVERSION@@@", "xxxxxxxx"'
12:17:03 20160422/121703.211 - U00021411 Line '002': 'REPLACE VARA, VARA.UC4#BASIS@RELEASE_INFO, *, "@@@RELEASEDATE@@@", "xxxxxxxx"'
12:17:03 20160422/121703.211 - U00021411 Line '003': 'REPLACE VARA, VARA.UC4#BASIS@RELEASE_INFO, *, "@@@RELEASETICKET@@@", "xxxxxxxx"'
12:17:03 20160422/121703.211 - U00021413 Replacements:
12:17:14 20160422/121714.916 - U00021407 Program UCYBchng ended normally.

Expected:  The values get replaced as expected.


 
Cause:
Root Cause: N/A
Resolution:
Use the REPLACE_PART script element instead.
 
REPLACE_PART VARA, VARA.UC4#BASIS@RELEASE_INFO, *, "@@@RELEASEVERSION@@@", “xxxxxxxx”
REPLACE_PART VARA, VARA.UC4#BASIS@RELEASE_INFO, *, "@@@RELEASEDATE@@@", “xxxxxxxx”
REPLACE_PART VARA, VARA.UC4#BASIS@RELEASE_INFO, *, "@@@RELEASETICKET@@@", “xxxxxxxx”


Fix Status: No Fix

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