DSXchange

I meant that the correct spelling of the second person personal pronoun is "you", not "u".

Check again. Get your SA to show you your entry in cron.allow or at.allow.

Check in the Stage Types branch of your Repository for Teradata MultiLoad stage. You should have it.

What if someone other than u wants to perform a sparse lookup?

Too late - import is what the Sequential File stage does. You must have some (correct) combination of Nullable and Null Field Value properties to ensure that the file is read correctly. It can be an empty field ("" for Null Field Value) if the file is delimited format, but must contain the correct n...

1) LINKS (virtual Data Sets) are referred to as Data Sets. Persistent Data Sets are referred to as Data Sets. Files are not referred to as Data Sets. 2) ds0, ds1, ds2, op0, op1, op2 and op3 are logical names used internally: how they map onto design objects is specified in the score. p0, p1, and so ...

You can buy add-on components that allow you to publish a DataStage job as a web service. Formerly called RTI (real time interface), these components are now called the SOA (service oriented architecture) edition.

Check with your vendor for pricing.

I always understood okidoki to be a martial art practised at the Oi Dong monastery.

The convention is that you, as original poster, mark the thread as Resolved.

It's in the first event in the job log. You can capture this with the DataStage API or with the dsjob command, and direct the information to wherever you will.

Not correct. The sqlcode column appears by virtue of the fact that it's on a reject link from a database stage type.

Is this a String parameter type, or some other type? You should not get this message for String parameters. You seem to be missing the leading and trailing single quote characters, but what's between the double quotes is still a valid string - this would cause problems in your IN clause later. Can y...

Not 2x0, but rather 0x20 if you're going to use the hex representation.

No problem. Use two ODBC Enterprise stages, one on each link.

And what format, precisely, does a DATETIME require?

It's bound to be in there somewhere. How good are your UniVerse hacking skills? Right now I'm extremely busy and do not have the time to research where these SQL statements are stored.