Conversion error - TimeStamp_From_String

[cherry]

Hi All,

I have a date field from the input and it's value is 1997-10-20 16:36:51 and type is Varchar(19).

Iam trying to load it to a db2 table and the SQL type is TimeStamp(19).

I have done the following conversion:

StringToTimestamp(<Field_Nmae>,"%yyyy-%mm-%dd %hh:%nn:%ss")

Iam getting the following error message.

APT_CombinedOperatorController,6: Conversion error calling conversion routine timestamp_from_string data may have been lost

Please advise.

Regards
Cherry

[ArndW]

Just to see what might be happening, add another transform stage where you convert your timestamp back to a string and see what the value might be. Also, disable operator combination and see which stage is giving you the warning message.

[srinivas.g]

Just use below one :

StringToTimestamp(<Field_Nmae>,"%yyyy-%mm-%dd %hh:%mi:%ss")

[ArndW]

srinivas - the %mi" works in Oracle, but is the wrong format picture for DataStage.

[abhijain]

Use

StringToTimestamp((<Field_Nmae>,"%yyyy-%mm-%dd %hh:%nn:%ss")

%nn is the correct one for month.

[ArndW]

abhi - what is different between your suggestion and the original post? I can't see a difference.

[priyadarshikunal]

There is a difference Arnd. You just haven't noticed it. There is an extra "(" in the later post which makes it incorrect.

It can happen in a lot of cases where
format picture is inconsistant
column length
unwanted characters (extra spaces, but if you are sure its varchar(19) through out check for different formats you are getting)
Unicode to ascii conversion(generally has other warning message too)?

Do as Arnd suggested and let us know the results.