Hitachi

Hitachi Advanced Database Messages


KFAA51230-W

An invalid range index name is specified in the adb_sql_rngidx_preread operand (number = aa....aa). (M)

The range index name specified in the adb_sql_rngidx_preread operand (the aa....aath specification) is invalid.

aa....aa:

Position where invalid range index name is specified (where the highest-level specification is first)

S:

Ignores the specified value.

Action:

The syntax of the aa....aath range index name specification is incorrect. Check the following:

  • That the range index name obeys the rules given in Index name specification format in Qualifying a name in the manual HADB SQL Reference.

  • Whether the range index name has been specified without a schema name. (The schema name cannot be omitted from range index names specified in the adb_rngidx_preread operand.)

  • That the range index name is correct. For details about how to check the range index names that have been defined, see Searching a dictionary table in the HADB Setup and Operation Guide.