DSXchange

Ur was a city in ancient Babylon. The second person possessive pronoun in English is spelled "your", not "ur". Please strive for a professional standard of written English on DSXchange, because even good English is difficult enough for those whose first language is not English. F...

Corvus' "NLS details" are for the locale.
Phil Hibbs is referring to NLS character maps.

First suggestion is Search - this question has been asked and answered a number of times, including quite recently. Second is to get the terminology correct - it's "hashed" file, not "hash" file. Part key lookups against hashed files can be achieved with UniVerse stage, once the ...

That is what I want you to do. You can use a UNIX find command.

The files with ampersands in their names have to be hard quoted or have the ampersands escaped in the cp command, for example D_\&COMO\& or 'D_&COMO&' (in single quotes). The is because ampersand is a shell metacharacter that instructs the shell to start a background process. D_SDKSe...

Is dsstpsyb.so on your server, in a directory that is included in your shared library search path (for example LD_LIBRARY_PATH, LIBPATH or SHLIB_PATH)?

It's reasonably clear in the manual. Change Capture captures the changes. The "changes" file it produces can be re-applied to the "before" data set in a Change Apply stage to reproduce the "after" data set.

These D_* entries are all just files, and can safely be copied (without overwriting any existing ones) with operating system cp command (UNIX) or COPY command (Windows).

Not sure why RT_CONFIG3613 is read-only - start by checking operating system permissions.

If you really want to get Craig (H) going, as about all those posters who want to create one generic job that can do everything. No, wait, who want US to create that job for them. (I get somewhat worked up about that also. I believe - know - that DataStage was designed to be driven by the metadata, ...

Try the generated SQL query from the Administrator command interface, substituting a known value for each parameter marker and adding the word EXPLAIN ahead of the semi-colon. This will tell you whether or not the query will use any index.

Looping within the Transformer stage is "in the plan" for a future release, maybe even 8.2.

Take a look at the Webinar on job sequence techniques with file processing. (www.dsxchange.net)

If the links are lost (possibly from running fixtool twice in succession) the file may be - probably is - irreperable.

You were given a solution for the 12-month case. Simply generalize that.

And please delete your duplicate post before anyone responds to it.

Why?

It's not a valid ASCII character. It's achievable using Unicode, but there is no scope for Unicode if you do not have NLS enabled.