DSXchange

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

Sad to hear. I never met him, but always appreciated his help and replies.

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...

The Netezza Enterprise stage requires all fields to be provided on an insert.

John

What is the datatype (in DS) you are using for this field? I just did this without changing the encoding="UTF-8" designation by using the NVarChar datatype. No changes to the NLS settings either.

Check the Link Ordering tab and make sure the Before and After links are correct.

John

This won't be exactly what you want, but you can add a parameter to the job named Delete Files. In the Help Text field add the "Do you want to delete these files?" question. When the job is ran, the Job Run Options are displayed. If you highlight the Delete Files prompt, the Property Help ...

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...

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...

DB2 has somewhat of an odd default timestamp format (if you are more from an Oracle background). It is yyyy-mm-dd-hh24.mi.ss.nnnnnn

Notice the hyphen between the day and hour, and the decimal points between the minutes, second and milliseconds. Try using a timestamp in this format if you can.

John

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 ...

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...

Formatting the column after opening the .csv does not give me the leading zeros in Excel 2003 - maybe it does in other versions. The only way I've found to do it is by setting up a custom import of the file using Import External Data.

John

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 ...

You might want to look into the following article at Microsoft:

http://support.microsoft.com/kb/175168

John