Db2 SQL statements for SQL DI

Db2 updates the following SQL statements to support SQL DI. Make sure that you are aware of pertinent restrictions when you use these SQL statements.

CREATE FUNCTION (sourced): This CREATE FUNCTION statement registers a user-defined function that is based on an existing scalar or aggregate function with a database server. See CREATE FUNCTION (sourced) for details.
CREATE FUNCTION (inlined SQL scalar): The CREATE FUNCTION (inlined SQL scalar) statement defines an SQL scalar function at the current server and specifies an SQL procedural language RETURN statement for the body of the function. The function returns a single value each time it is invoked. See CREATE FUNCTION (inlined SQL scalar) for details.
CREATE FUNCTION (SQL table): The CREATE FUNCTION (SQL table) statement creates an SQL table function at the current server. The function returns a set of rows. See CREATE FUNCTION (SQL table) for details.
CREATE INDEX: The CREATE INDEX statement creates a partitioning index or a secondary index and an index space at the current server. The columns included in the key of the index are columns of a table at the current server. See CREATE INDEX for details.
CREATE MASK: The CREATE MASK statement creates a column mask at the current server. A column mask is used for column access control and specifies the value that should be returned for a specified column. See CREATE MASK for details.
CREATE PERMISSION: The CREATE PERMISSION statement creates a row permission for row access control at the current server. See CREATE PERMISSION for details.
CREATE TABLE: The CREATE TABLE statement defines a table. The definition must include its name and the names and attributes of its columns. The definition can include other attributes of the table, such as its primary key and its table space. See CREATE TABLE for details.
CREATE VIEW: The CREATE VIEW statement creates a view on tables or views at the current server. See CREATE VIEW for details.
DELETE: The DELETE statement deletes rows from a table or view. Deleting a row from a view deletes the row from the table on which the view is based if no INSTEAD OF DELETE trigger is defined for this view. If such a trigger is defined, the trigger is activated instead. See DELETE for details.
SET CURRENT TEMPORAL BUSINESS_TIME: The SET CURRENT TEMPORAL BUSINESS_TIME statement changes the value of the CURRENT TEMPORAL BUSINESS_TIME special register. See SET CURRENT TEMPORAL BUSINESS_TIME for details.
SET CURRENT TEMPORAL SYSTEM_TIME: The SET CURRENT TEMPORAL SYSTEM_TIME statement changes the value of the CURRENT TEMPORAL SYSTEM_TIME special register. See SET CURRENT TEMPORAL SYSTEM_TIME for details.
UPDATE: The UPDATE statement updates the values of specified columns in rows of a table or view. Updating a row of a view updates a row of its base table if no INSTEAD OF UPDATE trigger is defined for this view. If such a trigger is defined, the trigger is activated instead. See UPDATE for details.