variable in GET statement

21 Views

Hi,

I've been creating a script that needs to multiply a value with a factor stored on a separate account, so I've been using a GET statement.

*REC(EXPRESSION=%VALUE%*GET(ACCOUNT="LS1012",DATASRC="NOTES"),ACCOUNT=%GUVLS%,ACCTDETAIL=%CLOSING%,DATASRC=DATASRC.DIMLIST_LS)

This is working fine but I was wondering whether I could replace the "LS1012" and the "NOTES" with variables. I did try to declare a variable for the LS1012 at the ttop of the script

*SELECT(%ACCPCT%,[ID],"ACCOUNT","[DIMLIST_EAA]='EAA_DTP' ")

and the use this in the *REC

*REC(EXPRESSION=%VALUE%*GET(ACCOUNT=%ACCPCT%,DATASRC="NOTES"),ACCOUNT=%GUVLS%,ACCTDETAIL=%CLOSING%,DATASRC=DATASRC.DIMLIST_LS)

However, I cannot get it to work. Is there a rule that says I can only use IDs in a GET statement?

Thanks,
Arnold