-270   FUNCTION NOT SUPPORTED

The statement cannot be processed because it violates one or more of the following restrictions:

ALTER INDEX or CREATE INDEX statements

• A CREATE INDEX or ALTER INDEX statement must not specify PADDED for an XML index or an index on a VARBINARY column.
• A CREATE INDEX statement must not specify ASC, DESC, or RANDOM for an XML index.
• A CREATE INDEX statement must not specify DESC or RANDOM if the index is an expression-based index.
• A CREATE INDEX statement must not specify a BINARY or VARBINARY column in a partitioning key.
• A CREATE or ALTER INDEX statement must not specify ASC, DESC, or RANDOM for an index that contains a column that is defined as TIMESTAMP WITH TIME ZONE.
• A CREATE INDEX statement must specify DEFER YES for a spatial index.
• A CREATE INDEX statement must not specify the name of a declared global temporary table.
• A column can have one spatial index only.
• When a spatial index is created on a column of BLOB or distinct type on BLOB, the LOB table space that stores the BLOB column must exist.
• A spatial index cannot be altered.
• The internal limit of 30,000 bytes for the versioned object descriptor (OBD) was exceeded. This condition can happen when an ALTER INDEX statement resulted in a new index version.

Related information:

• CREATE INDEX
• ALTER INDEX

ALTER TABLE or CREATE TABLE statements

• An ALTER TABLE statement must not attempt to alter a VARBINARY column to BINARY if that column is part of a unique index.
• An ALTER TABLE statement must not specify a materialized query table in an ADD CLONE clause. Alter the materialized query table into a base table before altering the table.
• An ALTER TABLE or CREATE TABLE statement must not specify a BINARY or VARBINARY column in a partitioning key.
• An ALTER TABLE statement with the ALTER COLUMN SET DATA TYPE clause must not specify VARBINARY or BINARY for the new data type when both of the following conditions are true:
  • The column is a partitioning key column.
  • The existing data type is CHAR or VARCHAR FOR BIT DATA.
• A materialized query table cannot be cloned for ALTER TABLE.
• The result table of the fullselect in the as-result-table clause of a CREATE TABLE statement includes data that is encoded with different CCSID sets. The result table must not use multiple CCSID sets.
• The internal limit of 30000 bytes for the versioned object descriptor (OBD) was exceeded. This condition can happen when an ALTER table statement results in a new table version or index version, or is executed on a versioned table.
• INLINE LENGTH is not allowed for the LOB column because the table space is not a universal table space.
• An ALTER TABLE statement was specified with an ADD PERIOD clause and a column mask or row permission is defined for the table. A period cannot be added to a table for which a column mask or row permission is defined.
• A CREATE TABLE statement must not contain a LIKE clause and an IN ACCELERATOR clause.
• A CREATE TABLE statement must not contain a LIKE clause that references an accelerator-only table.
• A CREATE TABLE statement must not contain an AS fullselect clause and an IN ACCELERATOR clause.
• A CREATE TABLE statement must not contain an AS fullselect clause where the fullselect references an accelerator-only table.
• A CREATE TABLE statement must not contain a materialized query definition and an IN ACCELERATOR clause.
• A CREATE or ALTER TABLE statement must not define a Unicode column in an EBCDIC table if the table is an accelerator-only table.

Related information:

• CREATE TABLE
• ALTER TABLE

DECLARE GLOBAL TEMPORARY TABLE statements

• The result table of the fullselect in the as-result-table clause of a DECLARE GLOBAL TEMPORARY TABLE statement includes data that is encoded with different CCSID sets. The result table must not use multiple CCSID sets, other than EBCDIC and Unicode.
• The IMPLICITLY HIDDEN clause must not be specified for a column that is defined as a ROWID, or a distinct type that is based on a ROWID.
• A BINARY or VARBINARY column cannot be specified in a partitioning key.
• The LIKE clause of a DECLARE GLOBAL TEMPORARY TABLE must not reference an accelerator-only table.

Related information:

• DECLARE GLOBAL TEMPORARY TABLE

CREATE FUNCTION statements

A CREATE FUNCTION statement must not attempt to define an SQL table function with either of the following items:

• A function body that references a column that is defined with a field procedure
• A RETURNS clause that references a column that is defined with a field procedure.

Related information:

• CREATE FUNCTION

CREATE MASK statements

A CREATE MASK statement must not define a mask for an accelerator-only table.

Related information:

• CREATE MASK

CREATE PERMISSION statements

A CREATE PERMISSION statement must not define a column permission for an accelerator-only table.

Related information:

• CREATE PERMISSION

CREATE VIEW or ALTER VIEW REGENERATE statements

All of the views and SQL functions that are referenced in a view definition must have the same rounding mode as the view that is being defined. SQL functions that have undefined rounding mode information are ignored during rounding mode checking.

Related information:

• CREATE VIEW
• ALTER VIEW

FETCH statements

A FETCH statement cannot include WITH CONTINUE or CURRENT CONTINUE within an SQL routine.

Related information:

• FETCH

GET DIAGNOSTICS statements

The STACKED keyword cannot be specified for a GET DIAGNOSTICS statement in an external SQL routine. The STACKED keyword is supported only within a native SQL routine.

Related information:

• GET DIAGNOSTICS

MERGE statements

• A column of the source table is referenced multiple times in a modification operation of the MERGE statement. When extended indicators are in effect, a column of the source table must not be referenced more than one time in a modification operation. A modification operation is an update operation or an insert operation. Extended indicators are in effect when EXTENDEDINDICATOR(YES) is used, or when the WITH EXTENDED INDICATORS prepare attribute is specified for the MERGE statement.

Related information:

• MERGE

TRIGGER statements

• A CREATE TRIGGER statement must not specify a view that has any of the following types of columns:
  • ROWID columns
  • LOB columns
  • XML columns
  • Defined (directly or indirectly) as identity columns
  • Security label columns
  • Row change timestamp columns
  • Row-begin columns
  • Row-end columns
  • Transaction-start-ID columns
  • Expressions
  • Columns of result tables that involve set operators
• A CREATE [or ALTER] TRIGGER statement must not reference an accelerator-only table in the body of the trigger.
• A CREATE TRIGGER statement with INSTEAD OF clause specified must not reference a view that references an accelerator-only table in the body of the trigger.
• The transition variable that is specified does not support XML.

Related information:

• CREATE TRIGGER

UPDATE statements:

Some UPDATE statements that modify data in a column for which a BEFORE UPDATE trigger is defined might result in this code in certain circumstances.

• If a BEFORE UPDATE TRIGGER statement contains a SET clause for one or more columns that participate in the access path index, execution of the BEFORE UPDATE TRIGGER statement might cause the row to qualify again. This situation occurs when all of the following conditions are met:
  • DB2 is using an index access path to locate rows that qualify for update.
  • A BEFORE TRIGGER exists on the table to which the rows belong.
  • The BEFORE TRIGGER updates the values of one or more columns that participate in the access path index.

  This situation can happen with both searched updates and positioned updates (updates that use the statement UPDATE WHERE CURRENT OF CURSOR). This code is issued for statements that are susceptible to this problem, even if the data involved in the update would not cause requalification. See "Programmer response" for information about handling requalification errors.

Other restrictions for SQL statements:

• Views and SQL functions that are referenced in an SQL statement must have the same rounding mode as the SQL statement. Views and SQL functions that have undefined rounding mode information are ignored during rounding mode checking.
• In a subselect, the select list cannot contain an XML column if OLD TABLE is specified.
• The RID built-in function and ROW CHANGE TOKEN expression must not be specified in a subselect when that subselect directly includes one of the following operators:
  • LEFT OUTER JOIN
  • RIGHT OUTER JOIN
  • FULL OUTER JOIN
• The ROW CHANGE TIMESTAMP expression can be specified only in a subselect when the following conditions are true:
  • That subselect directly includes a LEFT OUTER JOIN, RIGHT OUTER JOIN, or FULL OUTER JOIN operator.
  • The table designator identifies a base table that contains a row change timestamp column.
• An SQL table function must not be invoked with an expression that is derived from a column that is defined with a field procedure.
• An input argument for an SQL table function must not contain a scalar fullselect, a function, or a column reference, either directly or as part of an expression.