logo  
Google
 

DB2 SQL-Error: -747

SQLState: 57054

Short Description: TABLE IS NOT AVAILABLE UNTIL THE AUXILIARY TABLES AND INDEXES FOR ITS EXTERNALLY STORED COLUMNS HAVE BEEN CREATED

An attempt was made to access or reference a table with one or more LOB columns, however either v an auxiliary table for storing one of the LOB columns has not been created, or v an index has not been created for an auxiliary table, or v there is not an auxiliary table for each partition of the table space.System action: The statement was not executed. Programmer response: 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.

 <-  BACK TO INDEX