A constant or constant expression to be inserted into the new row for the columns specified in column_name. A constant expression is an expression containing only constants (for example, 3+5, or 19000/12).
If you are inserting into a UDT column, expression includes the appropriate NEW expression with the necessary constructor and mutator methods specified using dot notation. For more information, see Teradata Vantage™ SQL Operators and User-Defined Functions, B035-1210.
The system values CURRENT_DATE, DATE, CURRENT_TIME, TIME, and USER can be included in a constant expression. You can also use the DEFAULT function to insert the default value for a column.
You can insert a NULL by specifying the reserved word NULL as an expression value.
Values obtained from imported data, with a USING modifier, or as macro parameters, are accepted as constants.
When a column name list is not specified, then values are inserted in column definition order, from left to right. Use commas to indicate skipped columns. See Example: Insert Ordered Entries.
The derived period column position is skipped when mapping the values to the columns.
When a column name list and an expression list are used, values are assigned by matching column_name position with expression position. The two lists must have the same number of items.
When an element of the expression list is omitted, it is treated as a NULL. This is not valid in ANSI SQL.
You cannot specify a value for a derived period column.