Passing database/user/pwd as a parameters

[admin]

Is there any way in DataStage I can pass database/user/password along with a
other parameters using Oracle OCI?

thanks in advance
regards

Rahim Ladha
e-mail : rahimladha@hotmail.com


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

[admin]

Yes, very easily.

ALL our jobs have the same three parameters:
TargetDSN
TargetUser
TargetPassword

On the OCI stage, put these parameters into the source name, user id and password fields as follows: #TargetDSN# #TargetUser# #TargetPassword#

Done!

Note, we use the "Target" prefix above to distinguish the connection information for our target data warehouse from any connection information for a source system. Any of our jobs which read source data will also typically have SourceDSN, SourceUser and SourcePassword (and if it is MS SQL Server, the SourceDatabase and SourceOwner as well).


-----Original Message-----
From: Rahim Ladha [SMTP:rahimladha@hotmail.com]
Sent: Saturday, July 28, 2001 8:06 AM
To: datastage-users@oliver.com
Subject: Passing database/user/pwd as a parameters

Is there any way in DataStage I can pass database/user/password along with a

other parameters using Oracle OCI?

thanks in advance
regards

Rahim Ladha
e-mail : rahimladha@hotmail.com


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


*************************************************************************
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

*************************************************************************