ANR2956E Unable to access SQLbase table ’table’.
Explanation: An error occurred when attempting to read rows from one of the
SQL base tables.This message is typically preceded by another error describing the
condition.
SystemAction: The SQL query is terminated.
User Response: None.
ANR2957E An error occurred inserting a rowin an SQL temporary table. The server
database size may need to be increased
Explanation: An error occurred when attempting to insert a row into a temporary
table being used for an SQL query.This message is typically preceded by another
error describing the condition. In many cases this error can be resolved by
increasing the size of the server database. Free space in the database is used to store
temporary tables created during the execution of an SQL SELECTquery.
SystemAction: The SQL query is terminated.
User Response: None.
ANR2958E SQLtemporary table storage has been exhausted.
Explanation: The result of an SQL query could not be computed because
insufficient temporary table storage space was available. Free space in the server
database is used to store temporary tables created during the execution of an SQL
SELECT query.In many cases the web admin client uses SQL commands to
retrieve necessary data from the server.Complex SQL queries such as those
containing the following conditions can cause temporary table space to be required:
the ORDER BY clause, the GROUPBY clause, and, the DISTINCT operator. In
most cases this error can be resolved by increasing the size of the server database.
SystemAction: The SQL query is terminated.
User Response: None.
ANR2959E SQLtemporary table row is too wide.
Explanation: Arow could not be inserted into an SQL temporary table because
the row is too wide. This can occur if 1) there are too many columns in the row
being inserted, or 2) the sum of the lengths of the columns in the row is too wide.
Temporarytables are used when 1) the ORDER BY clause is specified; 2) the
GROUP BYclause is specified; or 3) the DISTINCT operator is specified.
SystemAction: The SQL query is terminated.
426
Version 3 Release 7