Required Fields

Field Description
Datasource The name that corresponds to the ODBC system Data Source Name (DSN) you created earlier by using the ODBC Administrator.
Template The name of the HTML extension file that formats the data returned from this query. By convention these files use the file-name extension .htx.
SQLStatement The SQL statement to execute. The SQL statement can contain parameter values, which must be enclosed with percent characters (%) from the client. The SQL statement can occupy multiple lines in the .idc file. Following the SQLStatement field, each subsequent line beginning with a plus sign (+) is considered part of the SQLStatement field. Multiple SQL statements can appear in the same file.