Search found 42189 matches
- Tue Mar 03, 2009 3:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timestamp with Microseconds in Parallel
- Replies: 6
- Views: 2791
- Tue Mar 03, 2009 1:52 pm
- Forum: General
- Topic: Constraint on Sequencer job to attach doc to email only if..
- Replies: 1
- Views: 1129
No script needed. You can build yourself a generic routine that takes a Job, Stage and Link name as parameters and leverages DSGetLinkInfo to get the record count written down the link to your sequential file. The trigger to your Notification Activity could then check if the count was > 0. If the fi...
- Tue Mar 03, 2009 1:44 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timestamp with Microseconds in Parallel
- Replies: 6
- Views: 2791
You should be able to take that value directly into Oracle with the TO_TIMESTAMP() function provided your Oracle TIMESTAMP field was created with that fractional seconds precision. Luckily, 6 is the default so more than likely you should be ok there. I would think you should keep the target datatype...
- Tue Mar 03, 2009 1:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Create Project
- Replies: 3
- Views: 1048
- Tue Mar 03, 2009 1:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Create Project
- Replies: 3
- Views: 1048
- Tue Mar 03, 2009 12:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to call a routine in PX job
- Replies: 5
- Views: 1328
You don't need to do so, use the built-in Parallel functions you have instead. A combination of StringToDate() followed by a DateToString() would be what you need for a date field, there are also Timestamp equivalents. These functions are listed in the appendix of the Parallel Job Developer's Guide ...
- Tue Mar 03, 2009 11:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Install time for minimal 8.1 config
- Replies: 3
- Views: 1574
- Tue Mar 03, 2009 10:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: oracle sequence resued for processing.
- Replies: 15
- Views: 3239
- Tue Mar 03, 2009 10:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Heap Size Limit Environment variable
- Replies: 4
- Views: 3179
- Tue Mar 03, 2009 10:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Heap Size Limit Environment variable
- Replies: 4
- Views: 3179
- Tue Mar 03, 2009 10:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: oracle sequence resued for processing.
- Replies: 15
- Views: 3239
- Tue Mar 03, 2009 10:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML OUTPUT stage with same tag name
- Replies: 5
- Views: 1645
- Tue Mar 03, 2009 8:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Columns to rows
- Replies: 1
- Views: 832
As noted: viewtopic.php?t=88639
- Tue Mar 03, 2009 8:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML OUTPUT stage with same tag name
- Replies: 5
- Views: 1645
- Tue Mar 03, 2009 8:42 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Folder stage
- Replies: 1
- Views: 695