DSXchange

Seems to me you are making this more complicated than it needs to be. What exactly do you think you need to see/do there?

ps. You don't need a userid or password for 'localuv'. Nor do you need ODBC.

What "universe database" are you trying to access? Why not explain what you are trying to accomplish - for example, do you have an external Universe source you need to connect to? DataStage hasn't had Universe under the covers for umpty.

sandeepgs wrote:

mdbatra wrote:If not mistaken, this has been already replied.

Yes you are right....

but the issue is not yet resolved..

Good Lord. Don't start over again for something like that, just reply to the original thread and keep on going there.

Probably a victim of not understanding the destructive overwrite nature of the beast. Also known as "When Keys Collide".

And the resolution is? [drum-roll]

So that's the official answer, eh? Yuck.

Still seems like a bug to me. [shrug]

This doesn't, but point taken.

Left to right, beginning to end, front to back, wind to water, ying to yang - however you want to phrase it.

There is no "pre-configuration setup" needed, assuming you can "sendmail" from the server. UNIX doesn't use the "SMTP Server" attribute so you can stop worrying about that, however it does require a "Senders" and "Recipients" email address. So... Are you sure both have values in them? Are you using ...

Now I goto datastage administrator and set the values as ORACLE_HOME="/oracle/product/10.2.0" LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib32 will the value of LD_LIBRARY_PATH become $LD_LIBRARY_PATH:/oracle/product/9.2.0/lib32:oracle/product/10.2.0/lib32 Will the 9i as well as 10G lib path be ...

No, the only time that happens AFAIK is when the job is run on more than 1 node.

Hmmm... don't recall seeing mention of this here before. Was this a Windows problem or a DataStage problem?

If the path to the script can change from environment to environment, then yes it needs to be another Job Parameter that you then leverage in the stage:

Command: ksh
Parameter: #SCRIPT_PATH#/script.sh #SCRIPT_PARAM1# #SCRIPT_PARAM2#

It will point to whatever you tell it to point to. Make sure the one you want to use is listed first if you can't arrange for only one or the other to appear.

ps. Never seen a need for ORAHOME, ORACLE_SID or ORASID being set. YMMV, of course.

That's because the UV stage requires an Account based, not a Pathed file. So you'll need to create a VOC record for it so the stage can find the hashed file you've named. Search for SETFILE to see examples of the syntax.

Simply put your shell of choice in the command prompt, say "ksh", and then the complete command with whatever parameters you need in the parameter prompt.