The query table stores the queries that are used for unloading data from an Informix database. Use the query-definition window to modify this table. For more information, see Creating a Query.
| Column | Type | Description |
|---|---|---|
| formid | SERIAL | Unique number that identifies this query (primary key) |
| projectid | INTEGER | Number of the project that includes this query (foreign key to the projects table) |
| name | CHAR(128) | Name of the query |
| database | CHAR(30) | Name of database being queried |
| arrayname | CHAR(128) | Not in use |
| lockflag | CHAR(1) | Flag for locking mechanism that ipload uses |
| sqlselect | TEXT | SQL statement of the query |