Nonrecursive Form
The WITH statement modifier is similar to a derived table. It defines a named query list from which the SELECT statement can select data.
Syntax Element … |
Specifies … |
query_name |
the name of the nonrecursive query. |
column_name |
the name of a column in the named query definition. |
select_expression |
a nonrecursive SELECT statement that retrieves the row data to store in the named query. You can specify an expression that returns a UDT in a column list only if its transform group has a fromsql routine. The system automatically converts the expression from its UDT value to the external type via the fromsql routine before returning it to a client application. See “Specifying UDTs in an SQL Request” on page 19 for details. You can specify a row-level security constraint column in the select list of a SELECT request. However, the column cannot be specified as part of an arithmetic expression in the select list. The value returned for the column is the coded value for the row-level security constraint from the row. |