Start of change

-4736   A PERIOD SPECIFICATION OR PERIOD CLAUSE IS NOT SUPPORTED AS SPECIFIED FOR OBJECT object-name. REASON CODE = reason-code.

Explanation

A period specification or period clause is not valid as specified.

object-name
The name of the object.
reason-code
A numeric value that indicates why the period specification or period clause is invalid:
1
In a CREATE FUNCTION statement for object-name, the definition of the function contains a period specification that is not supported. The routine body of an SQL scalar function must not contain a period specification or period clause. A RETURN statement in a table function must not contain a period specification.
2
In a CREATE VIEW statement for object-name, a fullselect must not contain a period specification.

System action

The statement cannot be processed.

User response

Either remove the period specification or period clause, or change the statement to reference a different object.

SQLSTATE

560CY

End of change