https://www.sqlines.com/ 2026-04-09T21:58:05+00:00 https://www.sqlines.com/ https://www.sqlines.com/lib/images/favicon.ico text/html 2013-04-12T10:22:41+00:00 https://www.sqlines.com/informix/create_dbspace_onspaces?rev=1365762161&do=diff You often need to create a dbspace to store the data and indexes for your database. Informix on Windows and onspaces When you create an Informix instance on Windows, a command line environment script is created for the instance. For example, if you created the instance named ol_informix2, you can see a new item in the Start Menu to launch the command line environment configured to use this instance: text/html 2013-11-01T17:46:43+00:00 https://www.sqlines.com/informix/define_database_codepage?rev=1383328003&do=diff You can use the following query to define the codepage (locale) of a database in Informix: Informix: -- Define locale of SALES database SELECT * FROM sysmaster:sysdbslocale WHERE dbs_dbsname = 'sales' Result: dbs_dbsname dbs_collate sales en_US.819 Note that 819 codepage in Informix corresponds to Latin 1 - ISO 8859-1 codepage. text/html 2013-02-05T20:09:06+00:00 https://www.sqlines.com/informix/get_next_serial_value?rev=1360094946&do=diff In Informix you can use a SERIAL data type to assign auto-incrementing IDs to a column: Informix: CREATE TABLE teams ( id SERIAL, name VARCHAR(70) ); -- Let's insert a few rows INSERT INTO teams VALUES (0, 'Baltimore Ravens'); INSERT INTO teams VALUES (0, 'San Francisco 49ers');