IDB

Driver short name

IDB

This driver implements support for access to spatial tables in IBM Informix extended with the DataBlade spatial module.

When opening a database, its name should be specified in the form

"IDB:dbname={dbname} server={host} user={login} pass={pass} table={layertable}".

The IDB: prefix is used to mark the name as a IDB connection string.

If the geometry_columns table exists, then all listed tables and named views will be treated as OGR layers. Otherwise all regular user tables will be treated as layers.

Regular (non-spatial) tables can be accessed, and will return features with attributes, but not geometry. If the table has a “st_*” field, it will be treated as a spatial table. The type of the field is inspected to determine how to read it.

Driver supports automatic FID detection.

Driver capabilities

Supports Create()

This driver supports the GDALDriver::Create() operation

Supports Georeferencing

This driver supports georeferencing

Supports VirtualIO

This driver supports virtual I/O operations (/vsimem/, etc.)

Environment variables

  • INFORMIXDIR: It should be set to Informix client SDK install dir

  • INFORMIXSERVER: Default Informix server name

  • DB_LOCALE: Locale of Informix database

  • CLIENT_LOCALE: Client locale

  • IDB_OGR_FID: Set name of primary key instead of ‘ogc_fid’.

For more information about Informix variables read documentation of Informix Client SDK

Example

This example shows using ogrinfo to list Informix DataBlade layers on a different host.

ogrinfo -ro IDB:"server=demo_on user=informix dbname=frames"