DSXchange

So the date IS being converted to internal format. In this case that is not what you want. Can you specify TO_CHAR rather than TO_DATE in the SQL statement?

10000000 (binary)
128 (decimal)
0x80 (hexadecimal)

However you want to represent it. This is described fully in the Parallel Job Developer's Guide - research "out of band null".

No we can't. The job may have aborted for a completely unrelated reason. Please post the exact error message(s) from the aborted job's log.

You can have multiple scratch disks per node specified in the configuration file. It only makes sense to do that if they're on different file systems.

Try calling it a Timestamp(6) within DataStage. Unlike every other database known to modern man, a DATE in Oracle is actually a timestamp - that is, it has a time component. Oracle is..... different. You might also experiment with Data Elements, though these in my experience are most useful with ODB...

Oconv() with MTS will only work on the time component. Yours is converting the entire number as if it were an interval then reporting it as a time of day. But what you're wanting to do is formatting rather than converting, so you should prefer the Fmt() function with a mask. Otherwise you have to br...

Read all about it here.

Fault type 11 is a SIGSEGV which usually indicates a memory problem. Has the log for this job become very, very large?

That's over a hexadeciCoors !

PaulVL wrote:A) Please contact your local DataStage Administration team as they are highly skilled individuals and exceedingly good looking too.

You mean the red headed kid?

I'm a bit surprised not to see mention of the ORCHESTRATE object in the VALUES clause.

Maybe they have a server-only licensing regime.

(Not everyone has your budget. )

Paul seems to have managed the sleep deprivation better than I did. Maybe my schedule was more hectic than his. Right now I'm stranded in LA because of the issues with Qantas. Should get home Thursday all being well. So "working from home" this week is just slightly more remote than usual!

You need to wrap it in the appropriate command line interface for whichever database you are using (for example db2, sqlplus, bteq) providing relevant credentials.

That is why I would prefer a server job and its user status area.

No. You may be able to do it in an Execute Command activity (use its triggers rather than Nested Condition activity) but you would need to wrap the CALL correctly; you can not call from the operating system command line. Possibly a better alternative is a server job that executes the SELECT statemen...