Search found 3 matches
- Thu Jul 30, 2009 12:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Passing string values into SQL query via parameter
- Replies: 14
- Views: 14517
Re: Passing string values into SQL query via parameter
Hello Arun, I checked passing multiple values for a single field as a parameter in version 8, it works fine. I do not have version 7.5, so i am not sure of that. But when u provide multiple values for an SQL statement, the values are internally treated as OR conditions. Instead of providing the valu...
- Mon Jan 15, 2007 1:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to get the fraction of seconds in the time hh:mm:ss-sss
- Replies: 12
- Views: 7108
Hi.. There is a job. When the job is run, the date+Time+Fraction of a sec need to be concatenated to the name of the file and then the file has to be created. This process should be done in the sequencer. This sequencer has 2 jobs and in both the jobs files have to be created as mentioned above. Fro...
- Mon Jan 15, 2007 1:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to get the fraction of seconds in the time hh:mm:ss-sss
- Replies: 12
- Views: 7108
Re: How to get the fraction of seconds in the time hh:mm:ss-
Please tell how to get the fraction of seconds part from the date format below: YYYY-MM-DD HH:MM:SS.SSS .SSS indicates fraction of seconds in the above formate. Please confirm whether there is any function or any other solution to get the fraction of seconds part (SSS) in datastage. Hi all. The val...