DateValidation gets warnings after DS-release 7.5.1A

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Felix Duen
Participant
Posts: 1
Joined: Tue May 02, 2006 5:26 am

DateValidation gets warnings after DS-release 7.5.1A

Post by Felix Duen »

Hi,

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
Post Reply