DSXchange

Hmm, I wonder if this part of your output could mean something

...No space left on device ...

Zabeerulla,

did you look at the NLS Guide as suggested earlier? Look at page 2-4 to start with.

You can do almost everything for NLS with your administrator client. Please refer to the PDF online document NLS Guide for details on how to change your locales.

Alagusakthivelan,

The best place to get ASAP help is your support provider. Please contact them for a quick response.

The compiler doesn't think NLS is enabled. Does this happen with just one job or with all?

If you really need to keep the date format you will have to change your NLS locale so that the default date format matches the non-nls one. This is certainly not what I would recommend - using a "D" conversion, particularly on output, is an invitation for big trouble. Be as specific as you can. If y...

Craig - oops, I wasn't thinking when I replied to that one. I must have gotten some decaf instead of the normal full-octance stuff that keeps me going.

The cause of the error is that NChar is not supported in that stage/job when you don't have NLS enabled. Try using Char instead.

vsi wrote:...The phantom error I am getting was
DataStage Job 410 Phantom 5232...

This is not the error, it is reporting that the job finished with an error. There will be at least one real error message in your log file. Perhaps your disk filled while writing the output file.

Chin,

my observations have been quite different. Is your DB/2 a partitioned database? What sort of a config file do you have? Does the read speed correlate with the write speed?

What happens when you correctly specify "D4YMD" instead of "D"? I'm not at a DS client now, but by setting NLS the default date format can change.

A single transform, declare your input as a single column and then do a CONVERT('#',CHAR(10),In.Column) and write it to a sequential file. This will convert each '#' character to a \n on output.

There are large (and pricey) software applications that do this type of name matching and cleansing that are usually more accurate than home grown solutions. First you need to get your logic down, then you can write some DS Basic code or functions to do this for you. 1. Parse out all variations of M...

You can specify two output links and set the order in which they get executed. You will also need to ensure that your commit frequency is each row so that an immediate commit is done from one link before it's successor gets executed.

The database access required for PX is somewhat higher than that for server, as per the installation guide.

I am really sorry If I offened someone... No problem if it was inadvertant, which it seems to have been. Any DataStage consultant should be able to pinpoint the bottleneck(s) in a given job. By consultant I mean someone who is hired on as a DataStage "specialist". Good DataStage consultants will co...