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

Copyright© 2018 HCL Technologies Limited