We trying to migrate from SQL2000 to Informix. In SQL table names are created with spaces in the names (like "bank names" etc). Can we create a table name with space in Informix?

............

Hi,
Is not advisable in Informix, but define DELIMIDENT=1 and put the name among quotation marks.
Exam. export DELIMIDENTE=1, run dbaccess, then create table "my table" ...

Gustavo.

It is not working..Error 841 is thrown when I try to create a table with space in the name. My IDS version is 9.30.FC3X1.

Any pointers please..?

==============================
Sorry, it worked
It is DELIMIDENT not DELIMIDENTE

Hi,
I have tested it in 7.31 and in 9.4 and functions fine.
Please, define in environment "export DELIMIDENT=1", next run dbaccess .... create table "my table" ( .....);

Gustavo.