Search found 6797 matches
- Thu Nov 21, 2013 4:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Supressing Non Printable characters in a String
- Replies: 2
- Views: 3335
- Tue Feb 28, 2012 8:22 am
- Forum: Site/Forum
- Topic: I search, but all I find is other searchers
- Replies: 9
- Views: 11214
- Fri Feb 24, 2012 11:21 am
- Forum: General
- Topic: DB2 sequences and transactions
- Replies: 9
- Views: 6860
I do the same at my current site. I use something like this select NEXT VALUE FOR sequenceowner.sequenceobjectname, 'X' from sysibm.sysdummy1 The 'X' becomes my dummy key to do a lookup on and get the key. This keeps the sequence object in sync as well. Now since this is a sparse lookup it will beco...
- Fri Feb 24, 2012 9:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generating a range of surrogate keys
- Replies: 3
- Views: 2983
- Wed Feb 22, 2012 11:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need logic to read sequentially
- Replies: 3
- Views: 2735
- Wed Feb 22, 2012 10:38 am
- Forum: General
- Topic: DSWaitForJob waits even after the required job is completed!
- Replies: 4
- Views: 3578
- Wed Feb 22, 2012 8:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Jobs aborting when invoked by sequence and run on 1 node
- Replies: 9
- Views: 5897
- Wed Feb 22, 2012 8:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: please tell me the logic for this....
- Replies: 6
- Views: 4875
- Tue Feb 21, 2012 2:28 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DecimalToString
- Replies: 3
- Views: 3696
- Tue Feb 21, 2012 11:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need something like running sum
- Replies: 1
- Views: 2002
Search is your friend
viewtopic.php?t=142985&highlight=group+number
viewtopic.php?t=142985&highlight=group+number
- Tue Feb 21, 2012 11:10 am
- Forum: General
- Topic: When you need to take a break
- Replies: 6
- Views: 4331
- Tue Feb 21, 2012 11:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Jobs aborting when invoked by sequence and run on 1 node
- Replies: 9
- Views: 5897
- Tue Feb 21, 2012 11:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: tansformer logic in transformer for Data stage 7.5
- Replies: 3
- Views: 4081
- Tue Feb 21, 2012 11:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: please tell me the logic for this....
- Replies: 6
- Views: 4875
- Tue Feb 21, 2012 8:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Setting Null to a nullable decimal column
- Replies: 5
- Views: 3784