DSXchange

Can you make a copy of the job and table and make the column non-nullable, then put a reject link to the upsert and see if you get some more information explaining this behaviour?

In number cannot contain blanks. As you are writing a number as a number it fills in the zeroes. When you write it as a VarChar() DataStage performs an implicit type conversion and, by default, removes leading zeroes.

If you are referring to an ODBC connection DSN then you will need to install a 3rd party ODBC package on UNIX in order to do this. If not, could you explain what you are attempting to do?

If you add a new column declared as VarChar(10) and map the numeric into it, does it look any different?

Disaster recovery is always driven the system requirements. I need to take a different approach in designing a data warehouse to be recoverable within an hour of failure than on a system which can be down for several days at a time. The definition is also a loose one. For some it means "My data cent...

What is the column declared as in your sequential stage?

Sure, you can do that. Change the command to "cut" and add the arguments "-d ','-f 2"

The syntax is well-document in the DataStage Parallel Job Developer Guide and is StringToTimeStamp({column},{format}). In your case the format would be '%yyyy-%mm-%dd%hh:%nn:%ss'

I am not sure what is happening in your case, I just wrote a simple test (row generator -> external command -> peek) and put in your cut command and it worked like a charm.

There are no freely available electronic versions of those courses available. All that comes for free is the tutorial

Have you looked with a binary editor? Or try setting $APT_STRING_PADCHAR to a space.

What is the rule behind the result - use just values values where column A is not empty?

There is no simple, builtin facility in PX jobs to generate a message in the log file. Do you really need to do this? I might output this message to a PEEK() stage in the reject link and use that log message to diagnose the error in this case.

I can't wait to find out what I can get with those coveted frequent-poster-points I suppose the 1st class trip around the world still needs a few more points, but what about the set of Tupperware containers with a free mincer-slicer-dicer attachment?

A fixable invalid date returns a status() of 2 but a valid date, which is why I skipped it in my case statement.