UNIX Environment Variables and DataStage
Posted: Wed Nov 08, 2000 7:07 am
Hi Jessica,
This is best done in a job control routine.
Use DSExecute subroutine to execute the UniVerse command ENV (or the UNIX command echo) to capture the environment variable, and DSSetParam to load it into DataStage. Use DSGetParamInfo function to obtain the value of a job parameter and use DSExecute to load it, again invoking the UniVerse command ENV (or the UNIX command env or set).
To find out more about the UniVerse ENV command, open a telnet session, invoke UniVerse, SET.TERM.TYPE VT100, then execute HELP ENVIRONMENT. To find out more about the UNIX env command, open a telnet session and execute man env.
Regards,
Ray
> ----------
> From:
> Jessica.Nguyen@mercantilemutual.com.au[SMTP:Jessica.Nguyen@mercantilem
> utua
> l.com.au]
> Sent: Wednesday, 8 November 2000 11:58
> To: ray.wurlod@informix.com
> Subject: DATASTAGE QUESTION
>
>
>
> Ray,
>
> Id like to set Job Parameters to Unix variable enviroment
> 1. How can I get UNIX variable into Datastage.
> 2. How can I set Job Parameters to UNIX variable.
>
> Could you please advise
>
> Thanks
> Jessica
>
> NOTICE
> The information contained in this electronic mail message is
> privileged and confidential, and is intended only for use of the
> addressee. If you are not the
> intended recipient, you are hereby notified that any disclosure,
> reproduction,
> distribution or other use of this communication is strictly prohibited.
> If you
> have received this communication in error, please notify the sender by
> reply
> transmission and delete the message without copying or disclosing it.
>
>
This is best done in a job control routine.
Use DSExecute subroutine to execute the UniVerse command ENV (or the UNIX command echo) to capture the environment variable, and DSSetParam to load it into DataStage. Use DSGetParamInfo function to obtain the value of a job parameter and use DSExecute to load it, again invoking the UniVerse command ENV (or the UNIX command env or set).
To find out more about the UniVerse ENV command, open a telnet session, invoke UniVerse, SET.TERM.TYPE VT100, then execute HELP ENVIRONMENT. To find out more about the UNIX env command, open a telnet session and execute man env.
Regards,
Ray
> ----------
> From:
> Jessica.Nguyen@mercantilemutual.com.au[SMTP:Jessica.Nguyen@mercantilem
> utua
> l.com.au]
> Sent: Wednesday, 8 November 2000 11:58
> To: ray.wurlod@informix.com
> Subject: DATASTAGE QUESTION
>
>
>
> Ray,
>
> Id like to set Job Parameters to Unix variable enviroment
> 1. How can I get UNIX variable into Datastage.
> 2. How can I set Job Parameters to UNIX variable.
>
> Could you please advise
>
> Thanks
> Jessica
>
> NOTICE
> The information contained in this electronic mail message is
> privileged and confidential, and is intended only for use of the
> addressee. If you are not the
> intended recipient, you are hereby notified that any disclosure,
> reproduction,
> distribution or other use of this communication is strictly prohibited.
> If you
> have received this communication in error, please notify the sender by
> reply
> transmission and delete the message without copying or disclosing it.
>
>