DSXchange

Separate Transfomer stages.

This is an all volunteer site; folks post as and when they can. If you want urgent answers, sign up for premium service with your support provider, and learn the true cost of "urgent". Posting in multiple forums ( for example here ) is also more likely to discourage responses than to achieve them.

The difference is because of "with NLS enabled and without NLS". Without NLS the expected format of a date (since you only have "D" as the second argument of Iconv) is specified in a file called msg.text; with NLS enabled the default date format is specified in the TIME locale category. The first is...

Please post the entire (exact) detailed error message so we can determine whether the error message source is the sort command itself or DataStage.

Please post the full error message so we can determine its origin (that is, DataStage or your database server).

Have you read The Tao of Pooh or its sequel The Te of Piglet - both very useful books in learning how to find The Path.

It's a Windows setting fundamentally. If you have NLS enabled for DataStage, you set it for the project using Administrator, but can override the map at job design level (even down to individual column level) using Designer.

Check the Character Set reported in the header of the DSX file.

2 to 4 as a value? That shouldn't be a problem, irrespective of the data type of the key column, unless there's a CHECK constraint on the table. 2 to 4 digits/characters? Then, yes, your metadata have changed out there in the database. Your DataStage jobs' metadata will need to be changed to corresp...

it is writing into a sequential file How do you know that? The fact that rows are pushed along the link does not necessarily get them written.] after the job is done the output file is getting cleared By what? Is there something in your code to truncate a file? its giving a phantom error Please pos...

Do you know anyone who's actually done this will parallel jobs? A couple of folks that I know gave up on that and implemented the partition parallelism via multi-instance server jobs. Then again, they hadn't attended the Server to Parallel Transition Lab available from the folks who host this site!

That's all good, but step back a little. Some environment variables (such as LC_LANG) have a default value set in your initial environment (login shell). If the environment variable exists in DSParams (having been put there by the Administrator client) its default value will be overridden. This new ...

No, because I don't have it. Ask your support provider.

With a consistent format it's an easy task, mainly using the Field() - and possibly Count() - functions. In real life names come in lots of different formats. The best tool to use is QualityStage name standardization, which "buckets" the various name components (for example title, main name, first n...

Run-time parameter values are in the RT_CONFIGxxx hashed files. They are also reported in the job log "job starting" event. Every parameter has two default values; the design-time default, created when the job is designed, and the run-time default, which is set using the Set Defaults utility in the ...

Read this part of the error message very carefully again.

Decimal "text" format is variable length and no external length is specified. Possibly you should specify an appropriate "width" property?

What property do you think you need to set?