I'd suggest adding a test for the 'E' such as:
Num(nodupes.BOUNDARY_AREA) AND Index(nodupes.BOUNDARY_AREA,'E',1)
Hope this helps,
John
Search found 219 matches
- Wed Jan 04, 2017 4:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Bug in NUM() Function ?
- Replies: 9
- Views: 4755
- Mon Jul 25, 2016 3:13 pm
- Forum: General
- Topic: Fallen Premium Poster: Kim Duke
- Replies: 32
- Views: 27917
- Mon Jun 13, 2016 4:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: converting numeric data to exponential form in unstructured
- Replies: 3
- Views: 5780
I can't help with the Unstructured Stage, but I assume you could do a scientific notation conversion into decimal fields in the Sequential File stage. Here is how I've converted scientific notation recently: IF NullToValue(nodupes.BOUNDARY_AREA, '') = '' THEN SetNull() ELSE IF Num(nodupes.BOUNDARY_A...
- Mon Jun 13, 2016 3:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Warning After Removing Columns (Netezza)
- Replies: 2
- Views: 3541
- Thu Nov 12, 2015 10:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Input - Dataset Output
- Replies: 8
- Views: 4408
- Wed May 06, 2015 3:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CDC not giving desired results
- Replies: 7
- Views: 3916
- Fri Feb 20, 2015 2:32 pm
- Forum: General
- Topic: Custom Pop Up
- Replies: 3
- Views: 2510
- Tue Sep 30, 2008 11:54 am
- Forum: General
- Topic: Environment Variables versus Hard Coded values
- Replies: 12
- Views: 7964
I've had the same issue using 7.5.2. I could get the jobs to run in development, but had a lot of problems when they were promoted to QA or Production. The workaround was to use job parameters in the jobs and not environment variables. The sequences then contained the environment variables and passe...
- Tue Sep 09, 2008 8:36 am
- Forum: General
- Topic: NULL Handling in Aggregator
- Replies: 5
- Views: 5680
You have a couple of options: 1. regardless of the message, you know a 'fatal runtime error' won't occur, right? So you could ignore the message. 2. if you really don't like the message, you could add it to the Message Handler in Manager. This is where you can tell DataStage to specifically ignore c...
- Mon Sep 08, 2008 3:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Timestamp Matching
- Replies: 2
- Views: 2360
- Thu Jun 19, 2008 10:49 am
- Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- Topic: Real-time processing
- Replies: 14
- Views: 11319
Ernie - thank you for the information, it is very helpful. This is my first attempt into the RTI/Web Services world. There doesn't seem to be very much documentation around. I didn't do the installation here so I don't know exactly what I have other than EE 7.5.2. I see the RTI Input and RTI Output ...
- Wed Apr 30, 2008 11:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stage variable
- Replies: 5
- Views: 2845
Just by looking, I would say the Right(sv1,2) >10 is comparing the text string '08'>10 which must evaluate to True. You might want to change it to Right(sv1,2) > '10' and see if that works. But then again, I wouldn't do this test because in 3 years when it is 2011 your result would be incorrect... J...
- Wed Apr 30, 2008 7:54 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Truncating zero's in .csv(excel file)
- Replies: 12
- Views: 11143
- Tue Apr 29, 2008 3:56 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Truncating zero's in .csv(excel file)
- Replies: 12
- Views: 11143
This is an Excel issue that has nothing to do with DataStage. What happens is when Excel opens a .csv file it tries to guess at how you want to see the data. This is an automatic data conversion that I have not discovered how to disable. The best way I've found to deal with it is to create a custom ...
- Tue Apr 29, 2008 11:28 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Excel File
- Replies: 16
- Views: 7655
You might want to look into the following article at Microsoft:
http://support.microsoft.com/kb/175168
John
http://support.microsoft.com/kb/175168
John