DSXchange

Hi, When I run the export command - dsexport.exe from a batch file, for some reason, the process dsexport.exe still remains in memory. Does anyone know why this would happen. The following is contained in the batch file that I am running. c:\Progra~1\Ascential\DataStage7.5.1\dsexport.exe /H=V01 /O=1...

It's not so much DS-legal as ODBC-legal. ODBC is very strict about adherence to standards. One of these is that column names containing "illegal" characters (including space) must be quoted. The standard specifies double-quote, but the Access driver ignores this and uses backquotes instea...

Make sure that the column names are correctly quoted. Click the GetSQLInfo button. At worst, insert the backquotes into the Derivation column on the Columns tab, or use user-defined SQL into which you've pasted the backquotes. Don't forget the Selection tab; any SQL you've placed there must also ha...

Hi, I have an Access Database input source. Most column names have spaces between them. When I import the table definition using Manager using an ODBC connection, all the columns import fine. In my server job, I have an ODBC stage that connects to the Access Database through an ODBC DSN. I then load...

Thank you very much for your advice.

However, we resolved the problem by:

1. Exporting our projects;
2. Uninstalling DataStage 7.5;
3. Re-installing DataStage 7.5, ensuring that NLS was enabled;
4. Upgrading DataStage 7.5.1.A; and
5. Finally, importing our projects.

Thanks

Vinal Kalyan.

Hi, When we were performing the Server Upgrade to DataStage 7.5.1.A from DataStage 7.1 we received an error message stating the following: "Verb "DS.CONFIGNLS" is not in your VOC" This occurred when Starting the NLS installation of the template. Any help on how to resolve this wo...