DSXchange

My main consideration is whether any other person/application is likely to generate keys for these tables. In that case, I would definitely leave creation of the surrogate keys to the database (sequence or identity column). That way, DataStage is not generating key values that someone else may alrea...

Snap!

I was wrong, too. It's the DB2 Enterprise stage, and only available when the Write Method property is "Write".

It's also available on the server side.

Nah, it's easier than any of that because Iconv() is really clever. All you need is

Just put the table name and alias in the "Table name" field. Use the alias in your where clause.

Welcome aboard! :D There are a few ways that this can be accomplished. One of the difficulties with daylight saving (summer) time is that it can be different in different locations - for example in the southern hemisphere summer is at the other end of the year compared to the northern hemisphere. Ch...

There is a server-side export command called dscmdexport as well.

In theory 19 million TB, but probably limited to 1TB on Windows platforms.

Welcome aboard! :D

It is most likely that you haven't configured the ODBC data sources. On UNIX you have to edit $DSHOME/.odbc.ini and the uvodbc.config file in your project.

So how come you're not using the Oracle Enterprise stage?

QualityStage is the right tool for the job that it does; standardizing and cleaning data.
It can be called from DataStage jobs using the QualityStage plug-in stage; however, the QualityStage jobs must have been designed and tested first.

Something strange has been written, or failed to be written, to the RT_STATUSnn file record for that stage in the job. Clearing the status file for the job should remedy the problem.

You can stay with hashed files by resizing them to 64-bit addressing.
(This syntax assumes a VOC entry - it can also be done from the command line.)

If you installed DataStage without NLS you will need to re-install.
If you installed DataStage with NLS but did not activate it, you will not need to reinstall.

To activate NLS, you need to change the NLSMODE setting in uvconfig to 1 and re-start DataStage.

But don't do it unless you need to.