What is informixdir?

What is informixdir?

What is INFORMIXDIR? The INFORMIXDIR environment variable is used by nearly every IBM Informix® product to locate important libraries, files, and executables. If INFORMIXDIR is not set correctly it will lead to various types of errors depending on the product being used.

How do I find the value of an Informix configuration?

Informix configuration settings are stored in $INFORMIXDIR/etc/$ONCONFIG. When checking to see an individual setting, an alternative to viewing the entire file is to run “onstat -c”. This shows the contents of the onconfig file. Using this onstat with grep allows you to easily and quickly see the value of a onconfig setting.

How to assign auto-incrementing IDs to a column in Informix?

In Informix you can use a SERIAL data type to assign auto-incrementing IDs to a column: When 0 value is inserted into a SERIAL column, Informix inserts the next ID (a 32-bit integer value): When you migrate an Informix database into another database such as Oracle, SQL Server i.e you have to start sequence/identity column with appropriate values.

How to start sequence/identity column with appropriate values in Informix database?

When you migrate an Informix database into another database such as Oracle, SQL Server i.e you have to start sequence/identity column with appropriate values. The easiest way is to use MAX aggregate function, but it requires a separate query (subquery) for each table having a SERIAL column: