logo  
Google
 

DB2 SQL-Error: -526

SQLState: 42995

Short Description: THE REQUESTED OPERATION OR USAGE DOES NOT APPLY TO TEMPORARY TABLE

DB2 assumes that the SQL statement being executed refers to a created or declared temporary table named table-name, and the requested operation or usage in the statement is not allowed on the temporary table. table-type CREATED or DECLARED CREATED is for a temporary table defined by the CREATE GLOBAL TEMPORARY TABLE statement. DECLARED is for a temporary table defined by the DECLARE GLOBAL TEMPORARY TABLE statement. table-name Qualified name of the temporary table.System action: The statement cannot be processed. Programmer response: Modify the SQL statement to ensure that the object references are not to the indicated type of temporary table, or if table-type is DECLARED and you intended table-name to refer to an existing persistent base table, you must perform one of the following actions: v Recreate the persistent base table table-name with a different qualifier v In the same application process, issue a DROP TABLE for table name followed by a COMMIT to drop the declared temporary table and afterwards be able to reference the persistent base table with the same table-name in the same application process v Remove the DECLARE GLOBAL TEMPORARY TABLE statement from the application process to use the persistent base table with the same table-name

 <-  BACK TO INDEX