logo  
Google
 

DB2 SQL-Error: -148

SQLState: 42809

Short Description: THE SOURCE TABLE CANNOT BE RENAMED OR ALTERED

The RENAME or ALTER statement issued could not resolve for one of the following cases: 1 The RENAME statement cannot be used to rename a view, an active RLST table, or a table for which a synonym is defined. 2 The ALTER statement cannot be used to alter the length of the column because the column is referenced in a referential integrity relation, a user exit (field procedure, edit procedure, valid procedure, stored procedure or user defined function), a global temporary table, or a table defined with data capture changes. If the table name specified in the alter is a view or if there exists a row in SYSVIEWDEP that has source-name as a base table name, then this ALTER statement will fail.System action: The statement cannot be executed. Programmer response: To resolve this error, follow the directions for the corresponding case: 1 Drop all views, inactivate the RLST table, or drop the synonym. 2 Avoid referential integrity relations, user exits, or global temporary tables.

 <-  BACK TO INDEX