Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2006
    Posts
    7

    Unanswered: Getting error while adding new column as "type char(1)" in informix 9.4

    Hi, I am using informix 9.4, I am able to create a new table with column name as "type", I want add a new column as "type char(1)" in the existing table. I tried this using alter table query, but it is not allowing me to alter it. But in informix 7.3 I am able to add new column as "type" using alter table query. if anyone knows the reason please share with me.

    Thanks
    Sarwan

  2. #2
    Join Date
    Jul 2009
    Posts
    37
    It'd be nice if you posted your full sql, but I'm guessing you don't need the 'type' keyword.

    eg.

    alter table dropme add ( hello char(1) );

    should work.

  3. #3
    Join Date
    Dec 2003
    Location
    North America
    Posts
    146
    You can't use "type" as a column name because "type" is a reserved word.

Posting Permissions

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