alisoviejo wrote:I had a smilar issue and had to use ltrim inthe Oracle stage (Source) !
Search found 21 matches
- Mon Feb 13, 2006 3:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to trim leading zeroes using trim()
- Replies: 26
- Views: 11385
- Fri Feb 10, 2006 12:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to trim leading zeroes using trim()
- Replies: 26
- Views: 11385
- Thu Feb 09, 2006 2:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to trim leading zeroes using trim()
- Replies: 26
- Views: 11385
- Thu Feb 09, 2006 2:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to trim leading zeroes using trim()
- Replies: 26
- Views: 11385
Re: Unable to trim leading zeroes using trim()
I don't want to eliminate every 0. Only leading 0's. Also, I think ereplace is server only. Right?
er
er
srikanthd1978 wrote:if u get an alphanumeric value u shld be able to use the 'ereplace' function and eliminate the "0" char in ur string...but i think the trim shld work...
- Thu Feb 09, 2006 2:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to trim leading zeroes using trim()
- Replies: 26
- Views: 11385
It's an alphanumeric (VARCHAR). 0009321A3 is a valid input, but I'd need the output to be 9321A3
ray.wurlod wrote:What is the data type of MYFIELD? Have you tried converting it to integer (say in a Transformer stage)? That should remove the zeroes - if it doesn't adding zero to the integer definitely will.
- Wed Feb 08, 2006 10:28 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to trim leading zeroes using trim()
- Replies: 26
- Views: 11385
I get the same result whether I use single, double, mixed and every combination of quotes that I could think of. This is quite frustrating.
kumar_s wrote:Hi,
Try with the paramteres passed for the Trim function in single quotes.
-KumarCode: Select all
Trim(link.field,'0','L')
- Wed Feb 08, 2006 10:15 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to trim leading zeroes using trim()
- Replies: 26
- Views: 11385
No, again, that is not working. I get 000987A87 when I copy and paste your code into my job. Are you using a parallel job? I am. Hi The trim function must work. I had used it so many jobs and never had this problem. I used the below to do a quick test to see what the result is. trim('000987A87',&quo...
- Wed Feb 08, 2006 1:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to trim leading zeroes using trim()
- Replies: 26
- Views: 11385
Unable to trim leading zeroes using trim()
Using the trim function to remove leading zeroes does not appear to be working. The input value was 00092102A92 and I wanted it to be 92102A92 on the output. The number of leading zeroes can very and as you can see, there are alphas in my varchar field. I tried to use trim(DSLink123.MY_FIELD,"0...
- Wed Jan 11, 2006 7:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataSet size very large with very little data inside
- Replies: 3
- Views: 2724
The problem is that the file never finishes being created because it fills up the disk too quickly. I guess I could try reducing the input to the point where the output would be able to get created and finish (75,000 rows would finish... the original input was 1.2 million). I'll try that and see wha...
- Wed Jan 11, 2006 4:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataSet size very large with very little data inside
- Replies: 3
- Views: 2724
DataSet size very large with very little data inside
I have 150 columns that are all VarChar(500)'s but the partitions in the scratch space are still very large when I set every one of those columns to null using the SetNull() function. ~75,000 rows produces a dataset with 2 partitions each of sizes around 6.0 GB for a total of around 12.0 GB. The onl...
- Thu Nov 17, 2005 5:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: KeyMgtGetNextValueConcurrent(), Server Container, PX Job
- Replies: 6
- Views: 2569
Any reason why you are not using the surrogate key stage, which generates key much more efficiently, or a parallel transformer counter field as described in the FAQ forum. Both methods can be passed a start value and will concurrently increment across partitions. I have considered the surrogate key...
- Thu Nov 17, 2005 2:18 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: KeyMgtGetNextValueConcurrent(), Server Container, PX Job
- Replies: 6
- Views: 2569
KeyMgtGetNextValueConcurrent(), Server Container, PX Job
Hi, I am primary keying records with the KeyMgtGetNextValueConcurrent() routine from within a Server Container that I am using inside of a Parallel job. It has worked in the past and I do not know what variable has caused it not work now. Recently I have been getting the following error message in t...
- Thu Aug 11, 2005 10:49 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Searching a hash File
- Replies: 11
- Views: 4496
Hi Aaron, Try LIST filename WITH columnname = 'value' :lol: Thanks, Chester That works but I'm not sure how well it will work with 102 million rows. I tried is on a smaller has file of 2 million and it take about 5 min to return. Thanks Chester's way seems like the only way, and will perform at O(n...
- Thu Aug 11, 2005 10:47 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Searching a hash File
- Replies: 11
- Views: 4496
Why not 'View Data' and then use the Find option there? Craig there are over 102 million rows in my hash file this option is not feasible. Thanks Yes, you'd have to skip every time your search failed, viewing 9999 rows at a time. Sounds like too much fun. If your record was at the very bottom, you ...
- Fri Jun 03, 2005 3:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Filter Stage Versus Switch Stage?
- Replies: 1
- Views: 2015
Filter Stage Versus Switch Stage?
What is the difference between the Filter stage and the Switch stage? Functionally, they seem to do the same thing, unless I am missing something. I know the Switch stage uses a C style case statement, so in terms of performance, is one better than the other? Are there any other considerations to ta...