Menu principal                 [Fechar]


SQL - SQLCODE's - Códigos negativos


Volta a página anterior

Volta ao Menu Principal


Desenvolvido por Carlos Alberto Dornelles - Analista de Sistemas - Brasília DF.


SQLCode -240

THE PART CLAUSE OF A LOCK TABLE STATEMENT IS INVALID

Conclusão: The LOCK TABLE statement is invalid for one of the following reasons:

  • The table space in which the table resides is not partitioned or does not have the LOCKPART YES attribute, and the PART clause is specified.
  • An integer specified in the PART clause does not identify a partition of the table space.

Ação do sistema: The LOCK TABLE statement cannot be executed.

Respoat do Desenvolvedor: Determine whether the specified table resides in a partitioned table space defined with LOCKPART YES.

  • If it is partitioned and defined with LOCKPART YES, specify a PART clause that identifies the partition you want to lock.
  • If it is partitioned but does not have the LOCKPART YES attribute and you want to lock a single partition, use ALTER TABLESPACE to change the LOCKPART attribute to YES.
  • If it is not partitioned, do not specify the PART clause.

SQLSTATE: 428B4


© Copyright IBM Corp. 1982, 2001