The query table in the onpload database
The query table stores the queries that are used for unloading data from an HCL Informix® database. Use the Query-Definition window to modify this table.
| 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 |