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

TABLE table-name IS NOT AVAILABLE UNTIL THE AUXILIARY TABLES AND INDEXES FOR ITS EXTERNALLY STORED COLUMNS HAVE BEEN CREATED

Conclusão: An attempt was made to access or reference a table with one or more LOB columns, however either

  • an auxiliary table for storing one of the LOB columns has not been created, or
  • an index has not been created for an auxiliary table, or
  • there is not an auxiliary table for each partition of the table space.

Ação do sistema: The statement was not executed.

Resposta ao Desenvolvedor:

  1. Use CREATE TABLESPACE to create a LOB table space.
  2. Use CREATE TABLE to create the auxiliary table for storing the column.
  3. Use CREATE INDEX to create an index on the auxiliary table.
  4. Resubmit the statement that failed.

SQLSTATE: 57054


© Copyright IBM Corp.