Progress
Embedded SQL-92
Guide and Reference
Query Expressions
Identify a list of expressions whose results form columns in a result table. This list of expressions is called a select list.
NOTE: This information on query expressions is specific to ESQL-92. For additional information on query expressions, see the Progress SQL-92 Guide and Reference .SYNTAX
expression
A column name from a table in the FROM clause or any expression that returns a value. An expression can also be any supported mathematical expression, scalar function, or aggregate function that returns a value.
column_title
Optionally, specifies a new heading for a column in the result table.
EXAMPLEThis example is a code fragment from the
statsel
function in sample program 2StatSel.pc. This example illustrates a query expression and the static processing of a SELECT statement. The complete source for the sample program is listed in "ESQL-92 Sample Programs."
NOTES
- Typically, the expression is a column name from a table in the FROM clause. An expression can also be any supported mathematical expression, scalar function, or aggregate function that returns a value.
- When you specify the optional column_title you must enclose it in single quotes ( ’ ).
- When a column_title is specified in a query expression, a DESCRIBE SELECT LIST Statement for a cursor associated with that SELECT Statement for a Single Row returns the column_title for the column name.
RELATED STATEMENTS
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |