DSXchange

In your 2nd job are the input Seq and the output Seq files different?

What is your StringToDate function format? If you have the format string written incorrectly you will get your error message.

Why didn't you just add the function I posted as the derivation, that will work.

Very simple, you are doing some sort of a date/timestamp operation with an invalid value.

I'm sorry if my question was misleading. What are you doing in the ODBC connector stage (which database, which options, etc.)

The DataStage engine is a copy of UniVerse that was cloned several years ago. The two versions have drifted apart as many elements of UniVerse that are not required for DataStage have been removed and other aspects modified. But the base products are still very similar. IBM has bought the product an...

You cannot assign a value of 0 to a timestamp. Try StringToTimeStamp('1900-01-01 00:00:00','%yyyy-%mm%-dd %hh:%nn:%ss').

Look at the uvconfig file in your $DSHOME directory, your EXACTNUMERIC value is probably set to 14. Search the forum for the correct procedure to change this setting if you wish, or use strings as suggested above.

This can happen for a number of reasons. First of all, I've found the monitor to be unreliable (well, I sometimes use the term "Flakey") for PX jobs. If the stage you are looking at has been optimized out of the run then it will also show a 0 value. What stages are you using? Do the source stage and...

It looks like a placeholder instead of a value is being printed. What options are you specifying in the FTP statement and are you sure you have entered all the login information and formats required?

gsym, I think Satya99 might have the right approach - that your ICONV() isn't converting the date as expected; in which case it will return the original string and which, in turn, is causing your condition to return an unexpected result. Ensure that the ICONV() of your value is successful. I would t...

Is there a POWER/PWR function that you can use?

What kind of a stage is this ODBC_Connector_108?

x**(1/2) for square root, x**(1/y) for y-root