Search found 53125 matches
- Wed Nov 19, 2014 3:22 pm
- Forum: General
- Topic: Where Do I find the 'dsexport' command?
- Replies: 14
- Views: 8344
- Tue Nov 18, 2014 10:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Trying to use an environment variable
- Replies: 7
- Views: 3329
- Tue Nov 18, 2014 10:44 pm
- Forum: IBM QualityStage
- Topic: Multiple variables not working
- Replies: 14
- Views: 8338
- Tue Nov 18, 2014 8:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Trying to use an environment variable
- Replies: 7
- Views: 3329
- Tue Nov 18, 2014 8:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Leading Zero in RCP Job
- Replies: 14
- Views: 11722
- Tue Nov 18, 2014 8:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Finding where a user defined Data Element is used
- Replies: 1
- Views: 1237
- Tue Nov 18, 2014 8:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Creation of sequential files using a dynamic parameter
- Replies: 3
- Views: 1698
- Tue Nov 18, 2014 8:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Is Orchestrate record schema structure the best to use
- Replies: 3
- Views: 2565
- Tue Nov 18, 2014 8:31 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: TIME CONVERSION
- Replies: 12
- Views: 6632
I'd use a Fmt() function. Something like
Code: Select all
Fmt(DIGITS(InLink.TheValue), "R##:##")- Tue Nov 18, 2014 8:27 pm
- Forum: IBM QualityStage
- Topic: Multiple variables not working
- Replies: 14
- Views: 8338
Try escaping the comma in the first pattern.
Code: Select all
+ | + [ {} != "OF" "ON" ] | \, | B | B | $ [ {multisuburb} = "Y" ] - Mon Nov 17, 2014 11:02 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Date Conversion (YYYY-MM-DD to MM-DD-YYYY)
- Replies: 6
- Views: 3348
See also Date Conversion Demystified
- Mon Nov 17, 2014 10:58 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Date Conversion (YYYY-MM-DD to MM-DD-YYYY)
- Replies: 6
- Views: 3348
If the source is in YMD order, then your Iconv() function must also specify YMD order. Yours specifies MDY order.
Try
Try
Code: Select all
Oconv(Iconv(InLink.TheDate, "DYMD"), "D/MDY[2,2,4]")- Mon Nov 17, 2014 3:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Is Orchestrate record schema structure the best to use
- Replies: 3
- Views: 2565
It's still relevant, but may be incomplete. I would prefer, wherever possible, to import table definitions, so that they are untouched by human hands and, therefore, devoid of transcription errors. I guess you could automate the generation of record schemas, but what would you use as the metadata so...
- Mon Nov 17, 2014 3:46 pm
- Forum: General
- Topic: DataStage 9.1 comes with one other component
- Replies: 3
- Views: 1525
- Mon Nov 17, 2014 3:45 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Substring function when find a dash
- Replies: 7
- Views: 3923
One solution
Code: Select all
Oconv(Field(InLink.Customer_cd, " ", 1, 1), "MCN")