Hi all
I use sapdb 7.4.30 with the current ODBC driver. I transferred a MSSQL database to SQLDB using the MS Transfer manger. I
found that all table names are created in lowercase.
Following ODBC queries seek for the uppercase tables, so a table not found
exception is
thrown.
Can i adjust the ODBC driver to ignore case ? or can enforce the table
creation in upper letters
SAP DB converts identifier to uppercase unless they are enclosed in double quotes. I guess the tool MS Transfer mangler (just joking) got lowercase names from the MSSQL catalog and then quoted them properly.
The ODBC driver mainly passes the SQL to the kernel, it doesn't change the case of identifiers.
Perhaps the easiest would be to write a small program that iterates over all the tables and issues ALTER TABLE RANAME statements. Iteration can be done using either the ODBC catalog functions or thrrough the table TABLES.
Daniel Dittmar
-- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
