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


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 -655

   
 
  • Causa
    • THE CREATE OR ALTER STOGROUP IS INVALID BECAUSE THE STORAGE GROUP WOULD HAVE BOTH SPECIFIC AND NON-SPECIFIC VOLUME IDS.

      One of the following error conditions occurred:
      • Both a specific and a non-specific ('*') volume ID are specified in the VOLUMES clause of a CREATE STOGROUP statement.
      • Both a specific and a non-specific ('*') volume ID are specified in an ADD VOLUMES clause of an ALTER STOGROUP statement.
      • A specific volume ID is specified in an ADD VOLUMES clause of an ALTER of a storage group that has non-specific volume IDs or mixed volume IDs.
      • A non-specific volume ID ('*') is specified in an ADD VOLUMES clause of an ALTER of a storage group that has specific volume IDs or mixed volume IDs./li>
  • Ação do sistema
    • The statement is not executed.
  • Resposta ao Desenvolvedor
    • Specify either specific or non-specific volume IDs in the VOLUMES clause of CREATE STOGROUP statement and the ADD VOLUMES clause of the ALTER STOGROUP statement.
      To add specific volume IDs to a storage group with non-specific volume IDs, use the REMOVE VOLUMES clause to remove the non-specific volume IDs.
      To add non-specific volume IDs to a storage group with specific volume IDs, use the REMOVE VOLUMES clause to remove the specific volume IDs.

      SQLSTATE: 56036

© Copyright IBM Corp.