Name of a non-recursive inner query expression.
For information about naming database objects, see SQL Fundamentals, B035-1141.
You can specify multiple non-recursive inner query expressions for a view.
- Name of a column in the named query definition.
- A non-recursive SELECT request 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. Teradata Database automatically converts the expression from its UDT value to the external type via the fromsql routine before returning it to a client application.