Skip to Content
1
Former Member
Aug 16, 2013 at 02:17 PM

Passing a Variable in Data Manager Package

35 Views

Hi Experts,

We are writing a simple script for generate some records based on existing records such as

*WHEN ACCOUNT

*IS 100000

*REC( %VALUE%* 2, ACCOUNT=110000)

*REC(%VALUE%*2,ACCOUNT=120000)

*REC(%VALUE%*2,ACCOUNT=130000)

--------

---------

*ENDWHEN

We are generating hundereds of record. Istead of hard coding multoplication factor which, we want to pass it through the data manager package and use a variable here.

How it can we achieved ? We tried changing FX Restatement process chain as follows

PROMPT(SELECTINPUT,,,,"%TIME_DIM%")

TASK(/CPMB/FX_RESTATMENT_LOGIC,SUSER,%USER%)

TASK(/CPMB/FX_RESTATMENT_LOGIC,SAPPSET,%APPSET%)

TASK(/CPMB/FX_RESTATMENT_LOGIC,SAPP,%APP%)

TASK(/CPMB/FX_RESTATMENT_LOGIC,SELECTION,%SELECTION%)

TASK(/CPMB/FX_RESTATMENT_LOGIC,LOGICFILENAME,GENERATED_ENTRY.LGF)

INFO=(%EQU%,=)

INFO=(%TAB%,:)

TASK(/CPMB/FX_RESTATMENT_LOGIC,TAB,%TAB%)

TASK(/CPMB/FX_RESTATMENT_LOGIC,EQU,%EQU%)

PROMPT(TEXT,%VAR%,"INPUT")

TASK(/CPMB/FX_RESTATMENT_LOGIC,REPLACEPARAM,VAR%EQU%VAR%)

and then changed script as

*WHEN ACCOUNT

*IS 100000

*REC( %VALUE%* $VAR$, ACCOUNT=110000)

*REC(%VALUE%* $VAR$,ACCOUNT=120000)

*REC(%VALUE%* $VAR$,ACCOUNT=130000)

--------

---------

*ENDWHEN

We are not changing the process chain FX_RESTATEMENT and just using it to run the script.

An error occurs when we tries to validate the script- "$VAR$ is not defined"

Please suggest how to fix this problem. We will appreciate your help.

Thank you,

R