You could also try writing a parallel routine to do this - nice opportunity to learn C++!ShaneMuir wrote: You could have also used something like
Right('00000':AspCodeCountSVar,5)
Search found 163 matches
- Tue Mar 24, 2009 9:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to concatenate zeros before the col value
- Replies: 4
- Views: 2447
- Mon Sep 22, 2008 9:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Left outer join - Nulls - Join Stage
- Replies: 4
- Views: 3301
- Mon Sep 22, 2008 8:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Converting from Varchar to Decimal
- Replies: 3
- Views: 2365
Just to be nosey, but... Is there a field related to your varchar that contains a value for the number of decimal places required? It's just that I've seen this kind of presumption before - 'always two decimal places, must divide by a hundred', when in fact there's a numeric column telling you how m...
- Thu Sep 18, 2008 7:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to get matched records between two columns
- Replies: 15
- Views: 6273
For completeness, the nullability of the 'dummy' field affects the value it is set to after the join. If NULL is allowed, then the unmatched 'dummy' field will be set to NULL. If NULL is not allowed then the unmatched field will be 0. Let's hope Ray didn't hurt himself when dismounting from his high...
- Tue Sep 16, 2008 6:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to auto-generate metadata?
- Replies: 8
- Views: 4349
- Thu Sep 11, 2008 9:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: searching a value in input dataset
- Replies: 5
- Views: 2522
Slight modification, after trying it... Seems the external filter stage doesn't want to increase the number of output columns, therefore you'll need to have one output col big enough to hold max data e.g. '1234567890 12' i.e. varchar(13). Then use a column import stage to split this single col into ...
- Thu Sep 11, 2008 8:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: searching a value in input dataset
- Replies: 5
- Views: 2522
Then in that case you may need to consider creating many records for each combination, presumably between 2 and 9 records per input record. Only keep the keys plus the new 'combination field', and join back to the rest of the data after you've joined to get your records to process. If I presume data...
- Thu Sep 11, 2008 8:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to find the files being used in which all jobs?
- Replies: 6
- Views: 2854
- Thu Sep 11, 2008 8:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: searching a value in input dataset
- Replies: 5
- Views: 2522
Is Oracle.Col1 always going to match against characters 2 and 3 of dataset.col1, as your example suggests?? If this is the case, then use a transformer to create a new column based on characters 2 and 3, and perform an inner join between this new column and Oracle.Col1. If the above is not the case,...
- Thu Sep 11, 2008 7:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to pass variable $APT_CONFIG_FILE from script
- Replies: 13
- Views: 17600
- Thu Sep 11, 2008 7:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Can we call UniX Scripts in Jobs(Not in Sequence)
- Replies: 4
- Views: 2324
- Wed Sep 10, 2008 9:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: warnings in the Lookup stage
- Replies: 14
- Views: 7557
- Wed Sep 10, 2008 7:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequential file Reading
- Replies: 2
- Views: 1685
- Wed Sep 10, 2008 7:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: warnings in the Lookup stage
- Replies: 14
- Views: 7557
- Thu Aug 28, 2008 3:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Compiling a job from director
- Replies: 5
- Views: 2408