Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2004
    Posts
    24

    Unanswered: An error occured during implicit system action type 5

    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: -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.

    Thanks in advance
    Nandra

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    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

  3. #3
    Join Date
    Sep 2004
    Posts
    24
    Hi,

    Sorry its sql0727 error.........

    Thanks in advance
    Nandra

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Read you error message carefully. Error 727 is caused by error 117, which is what you need to fix.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •