var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Table Name with space
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?
Last edited by blackguard; 11-30-05 at 07:32.
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" ...
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
Last edited by riyac; 11-29-05 at 12:37.
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" ( .....);