-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.

3

In an UPDATE statement for the view object-name, the result table of the outer fullselect of the view definition, explicitly or implicitly, must include the start and end columns of the BUSINESS_TIME period.