DSNH20524I THE STATEMENT FAILED BECAUSE OF AN INVALID PERIOD SPECIFICATION OR PERIOD CLAUSE FOR PERIOD period-name. REASON CODE reason-code.

Explanation

A period specification or period clause is invalid.

period-name

The name of the period that is invalid. Possible values are BUSINESS_TIME or SYSTEM_TIME.

reason-code

A numeric value that indicates why the period is invalid. reason-code can have the following value:

3

period-name violated the following requirement: each expression must return a value of a built-in data type and can contain any of the following supported operands:

• A constant
• A special register
• A variable, which can be either a host variable, an SQL variable, an SQL parameter, a transition variable, or a global variable
• A parameter marker
• A CAST specification where the cast operand is a supported operand
• An expression that uses arithmetic operators and operands
• A scalar function whose arguments are supported operands

These rules have the following exceptions:

• A period specification or period clause for a view must not contain an untyped parameter marker.
• The source expression of SET CURRENT TEMPORAL BUSINESS_TIME and SET CURRENT TEMPORAL SYSTEM_TIME statements must not contain a parameter marker or a transition variable.