DSXchange

QualityStage out of the box does not have postal certification database but, for extra cost, you can purchase CASS (for USA) or SERP (for Canada) postal certification modules.

QualityStage's fuzzy matching logic will allow you to correct (or reject) slightly inexact spellings and zip-code matches.

Welcome aboard.

Does the Oracle table have this as the default value for this date column?

So what's different about this project?

Did you try escaping the quote characters?

You do not hijack others' threads, particularly not when they were resolved two years ago! Start your own thread, and post the exact error message(s). Do not paraphrase them - use copy/paste to include the text in your post. And please post in the correct forum - if it's a parallel job, please post...

Exceedingly well, since they're both IBM products and the DB2 partitioning algorithm can therefore be made available within the DB2/UDB Enterprise stage. The only "glitch", in version 7.x, is that you can not use the Enterprise stage if DB2 is not on the same platform as DataStage. In this case you ...

What a strange design! What the constraint means is that, if the table name is allocated to partition #1, it will never make it to the output. I suspect that's not what you want. Forget DataStage for the moment. Write out a specification (in English) describing your source data, what the target need...

Sort stage is more flexible about using memory - you even have the ability to specify the per-node memory usage that the stage takes. Also, with an explicit Sort stage, it may be that your job no longer needs as much information in the inserted buffer operator (see the score) at any one time, so tha...

Is JCS a separate product, like Control-M, AutoSys, SeeBeyond, etc., or do you mean a job control routine in DataStage? If the former, please provide a URL where we can learn more about it. If the latter, do you advocate any particular way to run the same from UNIX?

ODBC Tracing is normally enabled/disabled in the .odbc.ini file.

$PROJDEF is a special token that you type in to the default value field of the job parameter.

It means "get this value from the Administrator client setting, unless manually overridden when the job run request is made".

Use a telnet connection. If that is also slow, check the network to find out whether it is being saturated with (other) traffic, such as everyone watching the World Cup live in their browsers. In the telnet session, execute the $DSHOME/dsenv script, then cd to the project directory and invoke $DSHOM...

It might not be in the first field - it may be in the second. Some commands output an empty line before their "real" output. Yours possibly falls into this category. If so, adjust your Field() function to extract the correct field from the activity variable. Otherwise, you are up for some detective ...

Etiquette Note We do not do "urgent" here, much less "very urgently". People who post here are all volunteers, who post as and when they can. If you require urgent support, sign up for premium service with your support provider, and learn the true cost of "urgent". What is the default value of the ...

Kindly give the full support and do the needful from your end . Surely you're paying maintenance on the licence, which entitles you to support from your registered support provider? DSXchange does not exist as a substitute for proper support. Your support provider is (or needs to be) aware of the p...