Search found 3 matches

by f.hq
Thu Jan 28, 2010 3:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date conversion warning
Replies: 8
Views: 4169

Hi,

thanks all.

My Isvalid function are:

Isvalid("date","20":link.field[1,2]:"-":link.field[3,2]:"-":link.field[5,2])


[]'s
by f.hq
Tue Jan 26, 2010 6:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date conversion warning
Replies: 8
Views: 4169

Actually, it should be StringToDate(GLTxnread.NW_WRK_DT_SRC_ORIG,"20%yy%mm%dd") for dates in 2000 and the conversion without the century values uses the default system ... hi, anybody khows how to avoid or treat the warning when the field has some invalid value using StringToDate? The fun...
by f.hq
Mon Jan 25, 2010 8:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date conversion warning
Replies: 8
Views: 4169

Re: Date conversion warning

hi,
using StringToDate(GLTxnread.NW_WRK_DT_SRC_ORIG,"2000%yy%mm%dd") works. But, the warning appears if the field has some invalid value. Example: "AA1253".