To reference a column value in a data row currently being processed, you can:

You can use the select as construct in a .query statement to select a column by its correlation name, which is not recognized by Report-Writer, and then give it another name, which you can use in Report-Writer statements. You can also use this construct to select a column whose name is a delimited identifier, and give it another name that is easier to reference in other Report-Writer statements.

To reference a column from a database table by a name other than its actual database column name, use the following construct in a .query statement:

Thereafter, refer to the column by its result name, as in the following print statement:

After assigning a result name in the query, any references to columnname causes an error.

Use a delimited identifier (see Delimited Identifiers) to reference a column that contains spaces or other non-alphanumeric characters, or that is identical to a reserved word.

Columns are comprised of one of the following types of expressions:

This table shows the SQL data types that belong to each of these categories. See the QUEL User Notes for QUEL data types.

Report-Writer perceives and treats a user-defined (UDT) data type as a character string. It does not recognize columns of data types long varchar, byte, byte varying, and long byte. If you specify a column of this data type in the query, Report-Writer silently ignores and does not print values for that column.

The QUEL data types that belong to these categories are listed in the following table: