-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