logo  
Google
 

DB2 SQL-Error: -752

SQLState: 560A1

Short Description: THE CONNECT STATEMENT IS INVALID BECAUSE THE PROCESS IS NOT IN THE CONNECTABLE STATE C E SQL INVALID TABLE SPACE NAME

The application process attempted to execute a CONNECT statement while in the unconnectable state. See the description of the CONNECT statement in the DB2 SQL Reference for an explanation of connection states. System action: The statement cannot be executed. The connection state of the application process is unchanged. Programmer response: Modify the application program to execute a commit or rollback operation prior to executing the CONNECT statement. SQLSTATE: 0A001 Explanation: The named table space is invalid for one of the following reasons: v It is a LOB table space and therefore cannot reside in a work file database. v It is a LOB table space and therefore cannot contain a non-auxiliary table. v It is not a LOB table space and therefore cannot contain an auxiliary table.System action: The statement cannot be executed. Programmer response: Either v Create the LOB table space in a non-workfile database. v Create the table in a non-LOB table space. v Create the auxiliary table in a LOB table space.

 <-  BACK TO INDEX