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.
>
>
UNIX Environment Variables and DataStage
Hi Ray,
Im impressed. Mercantile Mutual. Another Australian DataStage customer!
The list of Australian DataStage users seems to be growing.
This is good news for me.
I was wondering though ... does Informix have enough DataStage consultants to keep up with the demand? I wouldnt mind getting my name in front of some of these DataStage users if they are needing some consulting. Any thoughts?
Does Informix ever become aware of customers in need of consulting or do they tend to look elsewhere (body shops etc).
I have a full time contract at the moment, but Anglo are flexible about me doing other work as well.
In the meantime, I figure the best thing I can do is actively participate to help others on the list where I can. Who knows, maybe one day, somewhere in the future, someone might remember my name (hopefully in a positive way).
Thanks,
David
-----Original Message-----
From: Ray Wurlod [SMTP:ray.wurlod@informix.com]
Sent: Wednesday, November 08, 2000 5:07 PM
To: Jessica.Nguyen@mercantilemutual.com.au
Cc: informix-datastage@oliver.com
Subject: UNIX Environment Variables and DataStage
Hi Jessica,
*************************************************************************
This e-mail and any files transmitted with it may be confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in
error, please notify the sender by return e-mail, and delete this e-mail from your in-box. Do not copy it to anybody else
*************************************************************************
Im impressed. Mercantile Mutual. Another Australian DataStage customer!
The list of Australian DataStage users seems to be growing.
This is good news for me.
I was wondering though ... does Informix have enough DataStage consultants to keep up with the demand? I wouldnt mind getting my name in front of some of these DataStage users if they are needing some consulting. Any thoughts?
Does Informix ever become aware of customers in need of consulting or do they tend to look elsewhere (body shops etc).
I have a full time contract at the moment, but Anglo are flexible about me doing other work as well.
In the meantime, I figure the best thing I can do is actively participate to help others on the list where I can. Who knows, maybe one day, somewhere in the future, someone might remember my name (hopefully in a positive way).
Thanks,
David
-----Original Message-----
From: Ray Wurlod [SMTP:ray.wurlod@informix.com]
Sent: Wednesday, November 08, 2000 5:07 PM
To: Jessica.Nguyen@mercantilemutual.com.au
Cc: informix-datastage@oliver.com
Subject: UNIX Environment Variables and DataStage
Hi Jessica,
*************************************************************************
This e-mail and any files transmitted with it may be confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in
error, please notify the sender by return e-mail, and delete this e-mail from your in-box. Do not copy it to anybody else
*************************************************************************