DSXchange

OK... if you "have to" do this in a script then, as noted, you would use dsjob with the -linkinfo option.

Sounds like a classpath issue to me.

What was patched - the O/S or DataStage? Any chance the patch can be rolled back, see if that sets things right?

Are you aware that there is a button in the Designer (looks like an Internet Explorer icon) that will document the currently open job for you?

I would think the first question should be - is there an Oracle client installed on the DataStage server?

Key columns in Ds should be checked when it is the part of primay Key.. This is incorrect. Key columns in DataStage have nothing to do with "keys" (primary or otherwise) or indexes in your database. For update or delete DML they simply indicate the columns to be included in the 'where' cl...

Take your actual error and search for it here, the cause and solution have been discussed here several times.

Just to nit pick, in UNIX *.* won't match any file like it would on Windows, it will match any file with a "dot" in the name. Stick with a single asterisk in your routine.

SBSA_DW2 wrote:or is it better to have multiple jobs that are copies of each other?

I can't think of any situation where that would be better.

Quickest way to get help is by searching. For example:

viewtopic.php?t=114279

There were half a dozen others.

Make sure you are doing an "Exact" match, I got 8 matches when I tried it.

Yes, can you please provide examples of what you get from the lookup (the unexpected result) and examples of what your "expected result" would be in that case. Also, "View Data" on your hashed file and ensure that it looks like you've built it properly - as expected. Click inside...

Search for "BCI" here and make sure you understand the licensing issues that it brings to the table when you go through those posts.

First suggestion - search the forums for "Fetch out of sequence" and see if any help solve your problem.

Yes, but I certainly wouldn't advise it. Far better to use a job for that and have the routine land the data in a flat file for it to load.