- view_name
- Specifies the name of the recursive view.
- database_name
- Specifies the name of the database or user to contain view_name if something other than the current database or user.
- user_name
- column_name
- Specifies the name of a view column. If more than one column is specified, list their names in the order in which each column is to be displayed for the view.
- CURRENT VALIDTIME
- Specifies that seed_statement is a current query in the valid-time dimension. The result set is a nontemporal table.
- VALIDTIME AS OF date_timestamp_expression
- Specifies that seed_statement retrieves rows where the period of validity overlaps the specified AS OF expression. The result set is a nontemporal table.
date_timestamp_expression can be a constant, scalar UDF, scalar subquery, or business calendar function that evaluates to a date or timestamp value.
- NONSEQUENCED VALIDTIME
- Specifies that seed_statement is a nonsequenced query in the valid-time dimension. If period_expression is specified, the nonsequenced query produces a table with valid time; otherwise, the result set is a nontemporal table.
- period_expression
- Specifies the period of applicability for the nonsequenced query.
- CURRENT TRANSACTIONTIME
- Specifies that seed_statement or recursive_statement is a current query in the transaction-time dimension. The result set is a nontemporal table.
- TRANSACTIONTIME AS OF date_timestamp_expression
- Specifies that seed_statement or recursive_statement retrieves rows whose transaction-time period in the row overlaps the specified AS OF expression. The result set is a nontemporal table.
date_timestamp_expression can be a constant, scalar UDF, scalar subquery, or business calendar function that evaluates to a date or timestamp value.
- NONSEQUENCED TRANSACTIONTIME
- Specifies that seed_statement or recursive_statement is a nonsequenced query in the transaction-time dimension. A nonsequenced query produces a nontemporal table as a result set.
- AS OF date_timestamp_expression
- Specifies that seed_statement or recursive_statement retrieves rows whose valid-time and transaction-time periods overlap the specified AS OF expression.
date_timestamp_expression can be a constant, scalar UDF, scalar subquery, or business calendar function that evaluates to a date or timestamp value.
- seed_statement
- Specifies existing seed SELECT statement syntax for CREATE RECURSIVE VIEW or REPLACE RECURSIVE VIEW.
- recursive_statement
- Specifies existing recursive SELECT statement syntax for CREATE RECURSIVE VIEW or REPLACE RECURSIVE VIEW.