SQL - SQLCODE's - Códigos negativos -526


Volta a página anterior

Volta ao Menu Principal


Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

SQLCode -526
   
 
  • Causa
    • THE REQUESTED OPERATION OR USAGE DOES NOT APPLY TO table type TEMPORARY TABLE> table name

      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.

  • Ação do sistema
    • The statement cannot be processed.
  • Resposta ao Desenvolvedor
    • 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:
      • Recreate the persistent base table table name with a different qualifier
      • 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
      • Remove the DECLARE GLOBAL TEMPORARY TABLE statement from the application process to use the persistent base table with the same table name

      SQLSTATE: 42995

© Copyright IBM Corp.