Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2005
    Location
    Hottest place on the earth
    Posts
    13

    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?

  2. #2
    Join Date
    Sep 2002
    Posts
    102
    ............
    Last edited by blackguard; 11-30-05 at 07:32.

  3. #3
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    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.

  4. #4
    Join Date
    Jun 2005
    Location
    Hottest place on the earth
    Posts
    13
    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.

  5. #5
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •