KFAA31270-E

The specification of aa....aa in the ADB_GENERATE_SERIES function is invalid. <SQLSTATE: 4275C>

aa....aa: Location of invalid specification

• start value: Start value

• end value: End value

• step value: Interval value

• argument: Argument

• function: Function

bb....bb: Cause of the error

• the data type is invalid

  The data type is incorrect.

• a dynamic parameter by itself cannot be specified

  The dynamic parameter cannot be specified by itself.

• the combination of arguments is invalid

  The combination of arguments is incorrect.

• the specification cannot be omitted

  The specification cannot be omitted.

• the interval value cannot be 0

  A value of 0 cannot be specified for the interval value.

• only a constant can be specified for a labeled duration

  Only literals can be specified for labeled durations.

• the specification of the labeled duration modifier is invalid

  There is an error in the specification of the labeled duration qualifier.

• the arguments are of data types that cannot be compared

  The data type of the argument is not a comparable data type.

• the specified column is not from a table that is comma joined with the system-defined function ADB_GENERATE_SERIES, or the column is from a joined table

  The column is not from a comma-joined table with the ADB_GENERATE_SERIES function, or it is from a joined table.

• columns from different tables are being specified

  Columns from different tables are specified.

• a subquery of the specified in the argument is correlated subquery

  An external reference column is specified.

• the system-defined function ADB_GENERATE_SERIES is specified more than once in the query specification

  Two or more ADB_GENERATE_SERIES functions are specified in the query specification.

S:

Ignores this SQL statement. Alternatively, the system invalidates this transaction.

Action:

Correct the SQL statement.