Unanswered: An error occured during implicit system action type 5
Iam using DB2 8.1 fixpack 4 and solaris.when iam trying to update table iam getting this error,
"A SQL error occured sqlcode: -727QL0727N 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.
SQL0117N The number of values assigned is not the same as the
number of specified or implied columns.
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.
Correct the statement to specify one value for each of the
specified or implied columns.
sqlcode : -117
sqlstate : 42802