cancel
Showing results for 
Search instead for 
Did you mean: 

Question about modifying a package

Former Member
0 Kudos

Hi,

I am using the standard APPEND package to load fx rates into my rates model. The package has two prompts, one for the default logic and one for the work status, which I always answer in the same way. Would I be correct in assuming that I could disable these by making a few changes in the package?


(INFILES,,"Import file:",)

(TRANSFORMATION,%TRANSFORMATION%,"Transformation file:",,,Import.xls)

(RADIOBUTTON,%RUNLOGIC%,"Select whether to run default logic for stored values after importing",1,{"Yes","No"},{"1","0"})

(RADIOBUTTON,%CHECKLCK%,"Select whether to check work status settings when importing data.",1,{"Yes, check for work status settings before importing","No, do not check work status settings"},{"1","0"})

(KEYDATE,%KEYDATE%,"Key date",0)

(%TEMPNO1%,%INCREASENO%)

(%ACTNO%,%INCREASENO%)

(/CPMB/CONVERT,OUTPUTNO,%TEMPNO1%)

(/CPMB/CONVERT,ACT_FILE_NO,%ACTNO%)

(/CPMB/CONVERT,TRANSFORMATIONFILEPATH,%TRANSFORMATION%)

(/CPMB/CONVERT,SUSER,%USER%)

(/CPMB/CONVERT,SAPPSET,%APPSET%)

(/CPMB/CONVERT,SAPP,%APP%)

(/CPMB/CONVERT,FILE,%FILE%)

(/CPMB/CONVERT,KEYDATE,%KEYDATE%)

(/CPMB/APPEND_LOAD,INPUTNO,%TEMPNO1%)

(/CPMB/APPEND_LOAD,ACT_FILE_NO,%ACTNO%)

(/CPMB/APPEND_LOAD,RUNLOGIC,%RUNLOGIC%)

(/CPMB/APPEND_LOAD,CHECKLCK,%CHECKLCK%)

(/CPMB/APPEND_LOAD,PREPROCESSMODE,0)

(/CPMB/APPEND_LOAD,TARGETMODE,0)

(/CPMB/APPEND_LOAD,KEYDATE,%KEYDATE%)

If I were to disable (delete?) the two lines with the RADIOBUTTON and change these two lines


(/CPMB/APPEND_LOAD,RUNLOGIC,%RUNLOGIC%)

(/CPMB/APPEND_LOAD,CHECKLCK,%CHECKLCK%)

to read


(/CPMB/APPEND_LOAD,RUNLOGIC,1)

(/CPMB/APPEND_LOAD,CHECKLCK,1)

would that always run the default logic and check the work status without asking me for it?

On top, is there a way to not ask the user for the transformation file but instead hardcode this

\ROOT\WEBFOLDERS\ENVIRONMENT\Rate\DATAMANAGER\TRANSFORMATIONFILES\CLIENT\RATES_TRANSFORMATION.xls

file into the package?

Thanks,

Arnold

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor
0 Kudos

Hi Arnold,

Yes, you can hardcode values in DM advanced script the way you propose. Just test. You can also use INFO to set some %% variables and use variables later in the code.

B.R. Vadim

Answers (0)