Importing ODBC Table Definitions

ewartpm · Post by **ewartpm** » Mon Mar 29, 2004 3:32 am

I have been trying to import table definitions from a Sql Server 2000 database using the DataStage Manager. The user id I connect to the database has dbowner rights and therefore has nothing restricted. The import goes thru without any problems, but when I look at the metadata definition it only imports the first column in the table. It does this on all the tables I import.

Any help would be greatly appreciated.

ray.wurlod · Post by **ray.wurlod** » Mon Mar 29, 2004 4:08 pm

When you connect during the Import process, select just one table then click on the Details button. This should return a list of the column names in a message box. Also click on View Data.
These will determine whether the problem is in what SQL Server is returning, or what DataStage is writing to the repository.
You might also enable ODBC tracing, so that you can observe the effect of, particularly, the SQLConnect, SQLTables, SQLColumns (and, possibly, SQLColAttributes and SQLSpecialColumns) functions.

roy · Post by **roy** » Tue Mar 30, 2004 8:29 am

Hi,
I had this once it's something to do with your ODBC configuration.
there is an option you must uncheck in the ODBC definition process.
Unfortunatly I can't recall which one it is

.
I think it was something to do with the Use regional settings or the Perform translation for characterdata option (not sure which one it is).

Do post which one was it

.

IHTH,