An error occured during implicit system action type 5

nandra · #1 (**permalink**) 12-08-04, 12:42

Hi,
Iam using DB2 8.1 fixpack 4 and solaris.when iam trying to update table iam getting this error,
"A SQL error occured sqlcode: -727

QL0727N An error occurred during implicit system action type "5".
Information returned for the error includes SQLCODE "-117", SQLSTATE "42802"
and message tokens "". SQLSTATE=56098"

May i please know the reason why iam getting this error...response will be appreciated.

Thanks in advance
Nandra

n_i · #2 (**permalink**) 12-08-04, 14:18

Code:

SQL0117N The number of values assigned is not the same as the
          number of specified or implied columns.

Explanation:



o   The number of insert values in the value list of the INSERT
    statement is not the same as the number of columns specified
    or implied.  If no column list is specified, a column list
    that includes all columns of the table or view is implied.

o   The number of values on the right hand side of an assignment
    in a SET transition-variable statement or SET clause of an
    UPDATE statement does not match the number of columns on the
    left hand side.



 The statement cannot be processed.

User Response:

Correct the statement to specify one value for each of the
specified or implied columns.

 sqlcode :  -117

 sqlstate :  42802