i get warnings after Datastage release PX 7.5A to PX 7.5.1A.
Conversion error calling conversion routine date_from_string data may have been lost
- input column char(10)
- output date
In the transformer-stage i used following statement.
Code: Select all
If
IsValid('Date', StringToDate(Trim(LN_Read_MB_P.NPGDTA),"%dd.%mm.%yyyy")) = 1
THEN
StringToDate(LN_Read_MB_P.NPGDTA,"%dd.%mm.%yyyy")
ELSE
SetNull()
Had you them same problem after this release and how you solved it?
regards Felix