Search found 53125 matches
- Wed Mar 02, 2011 2:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: i have prob with effectve date and end date
- Replies: 3
- Views: 1463
- Tue Mar 01, 2011 11:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DCLGEN has 2 fields but only 1 VARCHAR column to load in DB2
- Replies: 7
- Views: 4331
- Tue Mar 01, 2011 7:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: parallel jobs
- Replies: 6
- Views: 2066
- Tue Mar 01, 2011 5:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to Achive bellow logic in datastage
- Replies: 6
- Views: 4318
- Tue Mar 01, 2011 5:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to search for a specific string within an input string
- Replies: 6
- Views: 2500
- Tue Mar 01, 2011 3:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fast Track Query
- Replies: 4
- Views: 1577
- Tue Mar 01, 2011 3:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: parallel jobs
- Replies: 6
- Views: 2066
- Tue Mar 01, 2011 3:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fatal Error: broadcastStepIR
- Replies: 2
- Views: 1947
- Tue Mar 01, 2011 3:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Usage of sed in external filter stage
- Replies: 6
- Views: 6565
- Tue Mar 01, 2011 3:30 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to search for a specific string within an input string
- Replies: 6
- Views: 2500
An even more cunning plan - one that cannot fail - is to search for the delimited string.
Code: Select all
If Index(" " : OPT_STRING : " ", " " : OptionCode : " ", 1) Then "X" Else " "- Tue Mar 01, 2011 3:26 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Extracting multiple occurences in XML file
- Replies: 3
- Views: 2371
- Tue Mar 01, 2011 3:25 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Load >2,000 byte string into Oracle using DataStage
- Replies: 3
- Views: 3262
- Tue Mar 01, 2011 3:24 pm
- Forum: General
- Topic: Job Sequence
- Replies: 5
- Views: 2264
- Tue Mar 01, 2011 3:23 pm
- Forum: General
- Topic: Error calling DSSetParam
- Replies: 13
- Views: 16773
- Tue Mar 01, 2011 3:21 pm
- Forum: General
- Topic: Getting data out of DS_AUDIT
- Replies: 5
- Views: 4100
Code: Select all
SELECT INSTANCE, MODIFIER, MAX(DTM) AS MOST_RECENT_MOD
FROM UNNEST DS_AUDIT ON MODS
GROUP BY INSTANCE, MODIFIER;