About SERIAL datatype in Informix

[stephenraj]

Hi Shriyan,

I have asked for auto increment column support in Informix database, u have given a solution of a datatype called serial, thanks for the same. In ur example u have created a temporary table.

Example Given by You.
--------------------

create temp table tab1 (f1 serial) with no log ;
insert into tab1 values (0) ;
-- show the generated sequence number.
select dbinfo('sqlca.sqlerrd1') from systables where tabid=1 ;


This again makes me to ask this question,

1. Is the serial column applicable only for the temporary tables?


2. Can we alter a serial column, if so can i just get the corresponding alter statement.

Thank u,

Regards,
Stephenraj

 

[vpshriyan]

Stephen:

Please refer the following thread:

thread179-446541

Regards,
Shriyan