Re: Can table names be case sensitive?

thorsten.wegner wrote: > I've got a strange problem with data, coming from an Informix 7.13 > database (unloaded with dbexport). I did not manage to load this data > into an Informix 7.30 NT database because in the original database there > are tables, with names that consist of upper- and lower-case characters. > Informix 7.30 always tells me a "syntax error" while trying to create > the new tables. In that old Informix 7.13 database all that work fine > and upper- and lower-case tablenames are completely supported, but it > seems as if the newer version of Informix does not support this feature > anyway. > Is there a special configuration option or certain switch in the > database server, that helps me importing my data? Or is there a way to > manipulate the SQL-file containing the load-instructions? Check out the DELIMIDENT environment variable. It's the only way I know of getting case-sensitive table names (user names are another matter). -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>