Search found 3 matches
- Wed Sep 25, 2013 5:40 am
- Forum: IBM QualityStage
- Topic: Removing a word from the name
- Replies: 6
- Views: 5840
Re: Removing a word from the name
Use field function. Even sub-string will do the job.
- Fri Aug 30, 2013 5:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datetime Overflow Error
- Replies: 11
- Views: 6475
Re: Datetime Overflow Error
Can you please check the data type of your target column?
Also, timestamp of 38 should accept it .
Also, timestamp of 38 should accept it .
- Fri Aug 30, 2013 2:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datetime Overflow Error
- Replies: 11
- Views: 6475
Re: Datetime Overflow Error
StringToTimestamp(STG1,"%yyyy-%mm-%dd %hh:%nn:%ss.0") -->
StringToTimestamp(STG1,"%yyyy-%mm-%dd %hh:%nn:%ss") Remove the 0 and try .
StringToTimestamp(STG1,"%yyyy-%mm-%dd %hh:%nn:%ss") Remove the 0 and try .