DSXchange

Assuming a DATE target, use IConv/OConv to convert to an ISO timestamp and add an explicit zero time:

YYYY-MM-DD HH24:MI:SS

This will work regardless of the NLS_DATE_FORMAT of the target database providing you let DataStage generate the SQL.

As noted - an exact search for "ParamValue/Limitvalue is not appropriate" will reveal all.

You could also be running afoul of the fact that XP is not a supported Server platform, especially not the 64bit version. Plus 8.0 was Bug City.

Yes, please let us know if that does indeed solve your problem.

"the Queue"? Can you be more specific, please?

Ray Wurlod.

Explain what you mean by 'manual bulk loader'. Typically that means you're not doing any actual inserting but rather only creating the .ctl and .dat files so sqlldr can be 'manually' invoked afterwards. That as opposed to 'Automatic' mode. And assuming we're talking about Oracle here, which you have...

And the details of exactly how you built this Sequence job.

This really should be in its own post. Can you confirm for us if this is a Server or PX question and what version of the product it is that you have - 7.x, 8.x, UNIX, Windows, etc? ps. I deleted your duplicate post you added to yet another topic, something frowned upon here. There's only so many pos...

/bis_data/msg/mfr/offshore/hash//inv_mg_co_symbols I don't know how the second '/' came. Doesn't really matter as it doesn't hurt. Typically it comes because it is in both the parameter value and hardcoded in the path as well. I have also one more question, why we are using '/' to point HashFile lo...

Still... UserVariable.

It's got nothing to do with Primary Keys or any kind of indexing, but rather fields marked as Key Fields. They are the ones that will be bound into the 'where' clause of your lookup sql.

I've seen the same thing over the years and you could probably find my post on the same subject if you looked hard enough. Support was never able to explain it and it 'fixed itself' on its own, which is both a good and bad thing.

Sounds like a question for your DBA.