The key values are NOT sorted. A hash table index is built.
If there is more than one value associated with any one row in that hash table, then there are duplicates for that value.
Search found 53125 matches
- Fri Mar 08, 2013 7:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: look up stage interiors
- Replies: 4
- Views: 1407
- Fri Mar 08, 2013 7:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to truncate Chinese Char ?
- Replies: 9
- Views: 4802
The inbuilt functions that you are likely to use, like [1,50] or Substring(), or Left(), all operate on characters (not on bytes). So, provided you have specified the correct character map (the one used to encode the data, for example BIG5 or GB2312) then all should be well. The error message does n...
- Fri Mar 08, 2013 7:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: reject link creates a file
- Replies: 6
- Views: 1735
- Fri Mar 08, 2013 7:25 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ASCII Delimiter for a sequential file
- Replies: 3
- Views: 1459
- Fri Mar 08, 2013 7:21 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: String Tokenizer
- Replies: 5
- Views: 1599
- Fri Mar 08, 2013 12:12 am
- Forum: General
- Topic: How can I check if MKS Toolkit is installed?
- Replies: 3
- Views: 1188
- Fri Mar 08, 2013 12:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Trim the first characters
- Replies: 3
- Views: 1480
Code: Select all
Right(InLink.TheColumn, Len(InLink.TheColumn) - 4)- Fri Mar 08, 2013 12:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Pivot rows
- Replies: 12
- Views: 4255
- Fri Mar 08, 2013 12:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ASCII Delimiter for a sequential file
- Replies: 3
- Views: 1459
- Fri Mar 08, 2013 12:03 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: String Tokenizer
- Replies: 5
- Views: 1599
There's no function out of the box, but it would be very easy to create one. Assuming that the string is already space-separated there is no real need to tokenise - if you think there is, please provide a more exact specification. FUNCTION ReplaceNonAlphaNumerics(aString,aReplaceChar) AlphaNumerics ...
- Thu Mar 07, 2013 11:56 pm
- Forum: IBM QualityStage
- Topic: Reference Match Input Considerations
- Replies: 12
- Views: 5346
- Thu Mar 07, 2013 1:44 pm
- Forum: General
- Topic: dsjob command failed
- Replies: 7
- Views: 4343
- Thu Mar 07, 2013 1:41 pm
- Forum: General
- Topic: Help on Error Code 39202
- Replies: 4
- Views: 2044
- Thu Mar 07, 2013 1:39 pm
- Forum: General
- Topic: How to identify all job names using local handlers
- Replies: 3
- Views: 1525
- Thu Mar 07, 2013 1:36 pm
- Forum: General
- Topic: IS 9.1 on Linux RHEL 6.4 Installing error
- Replies: 5
- Views: 2435