Page 1 of 1
create new system variable?
Posted: Wed Aug 11, 2004 9:48 am
by datastage
I know the provied system @variables are read-only, but I was curious if there is any way to create your own @variables that will show up in the ... menu for system variable...
Thanks
Posted: Wed Aug 11, 2004 4:14 pm
by kduke
The @USER1,2,3 ... are not read only. They are available only during one connection so if a job splits into mutiple connections then the values are not shared like you think.
Posted: Wed Aug 11, 2004 9:55 pm
by ray.wurlod
You have @USER0 thorough @USER4 and @USER.RETURN.CODE as writable system variables. They are all local to a process; that is, they do not have scope between processes.
To get them to show up in the Expression Editor's drop-down list, edit the DSParams file on the server (this is entirely legal to do) and add those variables to the System Variables section.
One mechanism for transferring information between processes is the job's "user status area". Research this in on-line help: DSSetUserStatus and DSGetJobInfo.