Is it possible to connect to Orale 9i database from one DataStage project and Oracle 10g database from another DataStage project on the same DataStage server?
As per my understanding dsenv is for the server and not for individual projects. So what will be the ORACLE_HOME value in such case? Can it take multiple values sepatrated by a colon ( : ) like any other PATH variable?
That resolves the issue and so I'll be marking it "Resolved".
But out of curosity, does that mean the ORACLE_HOME variable cannot take more than one value? What if tomorrow another interface, Orcale 8i, is required to be added?
Not for the repository but I would think you could still connect to one as a data source or target - you'd just need to leverage an 8i client. And you can add Environment Variables to a Project so that you can override the $ORACLE_HOME and $SHLIB_PATH (or equivalent) in an individual job if you really needed to.
Rishi - that should also answer your ORACLE_HOME question. You can have multiple 'homes' but you can only point to one at a time.
-craig
"You can never have too many knives" -- Logan Nine Fingers