DSXchange

I prefer not to hide the cause of the problem by using a message handler but to correct the issue. What type of stage is producing this error?

Why not put an execute command stage for "sleep 60" and "sleep 120" into the stream for each job that should be staggered?

The IsNotNull() just gets compiled to Not(Isnull())

Decimal or Integer, depending on whether or not you have integer values or not. Are the signs leading, trailing and are there spaces in the values?

Right-mouse click on the screen, then "View Source" - what is displayed?

Offhand I cannot think of an easy way, I would probably choose a default value for each column that cannot appear in the data, then in a transform stage replace that default value with the real default and, at the same time, use another column to hold the defaulting information or just output that i...

What is the SQL datatype for the column and are you using a DataStage "LongVarChar" definition? Have you tried just Varchar() ?

'2009-11-01' is a Date and cannot be converted to a timestamp they way you are writing it.
Try :

The syntax is wrong. Explain "not working", please and include the error message.

Rocket Software, Inc. purchased the IBM U2 Suite of software effective October 1st, 2009. The documentation for UniVerse is now located in this directory ; there you will find thousand of pages of documentation including the LIST and other PERFORM commands. These are 99% compatible with the undocume...

Have you tried a force-recompile of the job, it might be that the binary for the transform stage is not present.

Since sequential files tend not to be the blocking factor, I would start by looking into the Oracle conection. I would talk to the DBA and use Oracle tools to monitor the query and it's progress, as it is likely that Oracle is causing the issue here.

That is like the management questions of old "Describe, in 2 sentences or less, the conditions during the first 2 seconds of the 'Big Bang'. Support your assertions". In other words, the question is so broad and encompassing that it is difficult to know where to start. If you could specify...

Try "StringToTimeStamp(In.column:" 00:00:00","%YYYY%MM%DD %HH:%NN:%SS")

Well, we went through the DLST change on the 24th, and since this is the first time I've seen anything like this I wonder if there might a relationship.