Search found 10 matches
- Fri Jul 17, 2015 8:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to join data with a BETWEEN function
- Replies: 8
- Views: 6118
Source 1 is connector stage and stream. Source 2 is Lookup_File and reference. The stream needs to do a range lookup to the Lookup_File, with the lookup stage. But I can't perform the range lookup with that combination. It does work with 2 connector stages, but I would like to use the Lookup_file be...
- Thu Jul 16, 2015 3:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to join data with a BETWEEN function
- Replies: 8
- Views: 6118
- Tue Jul 14, 2015 2:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to join data with a BETWEEN function
- Replies: 8
- Views: 6118
- Tue Jul 14, 2015 12:43 am
- Forum: Site/Forum
- Topic: webmaster email rejected
- Replies: 1
- Views: 16319
webmaster email rejected
I can't mail to the webmaster, I get the following notification. ----- The following addresses had permanent fatal errors ----- XXXXX@gmail.com (reason: 550-5.7.1 [66.34.129.46 12] Our system has detected that this message is) (expanded from: <webmaster@dsxchange.com>) XXXXX@gmail.com (reason: 550-5...
- Tue Jul 14, 2015 12:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to join data with a BETWEEN function
- Replies: 8
- Views: 6118
How to join data with a BETWEEN function
Hi all, I would like to left outer join data from a 12million+ rows table onto my stream data, with a DATE from the stream into START_DATE and END_DATE in the 12m+ table. select A.*, B.* from A, B left outer join B on A.key = B.key where A.DATE >= B.START_DATE and A.DATE < B.END_DATE In a Join and M...
- Tue Jul 07, 2015 3:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to get string from VarChar from first non-numeric value
- Replies: 7
- Views: 5640
- Mon Jul 06, 2015 1:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to get string from VarChar from first non-numeric value
- Replies: 7
- Views: 5640
- Fri Jul 03, 2015 7:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel job problem with NLS/BOM
- Replies: 3
- Views: 4436
- Fri Jul 03, 2015 1:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel job problem with NLS/BOM
- Replies: 3
- Views: 4436
- Thu Jul 02, 2015 6:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to get string from VarChar from first non-numeric value
- Replies: 7
- Views: 5640
How to get string from VarChar from first non-numeric value
Hi, my name is Dirk and I am new here. Hopefully we can help each other out. My problem: Input is house numbers like '10', '11b', '12 - c', '12/2' and I would like the output split in two output lines like this: '10' = '10' and NULL '11b' = '11' and 'b' '12 - c' = '12' and '- c' '12/2' = '12' and '/...