00E7009A

Explanation

A DECLARE GLOBAL TEMPORARY TABLE statement or OPEN CURSOR (of a scrollable cursor) was issued, but the operation cannot be performed due to one of the following reasons:

  • A work file database has not been created yet.
  • A table space has not been created in the work file database yet.
  • No table space in the work file database has a page size that is large enough for the declared global temporary table.
  • A table space in the work file database is not available at this time.

System action

The operation is not allowed.

Operator response

Notify the system programmer.

System programmer response

To perform the operation, you must create the required work file database or create a table space with a large enough page size.

Problem determination

The requested operation is not performed. An SQLCODE -904 is issued.