Ansicht
Dokumentation

SQL0117 - Statement contains wrong number of values. ( OS/400 )

Fill RESBD Structure from EBP Component Structure   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by IBM.


Message : SQL0117
Statement contains wrong number of values.

Message Long Text :

Cause . . . . . : One of the following conditions may exist:
-- For an INSERT or UPDATE statement, the number of values is not the same as the number of columns.
-- For an UPDATE statement, the number of entries in the select list of a row fullselect does not match the number of columns listed in the SET clause.
-- For an INSERT with subselect, the number of entries in the select list is not the same as the number of columns for the INSERT.
-- For an INSERT statement, one or more of the columns omitted from the column list was created as NOT NULL.
-- For an INSERT statement, one or more of the columns specified for the INSERT was created as NOT NULL, and the statement specified DEFAULT as the value to be inserted.
-- For SET or VALUES INTO, the number of values is not the same as the number of target host variables.
Recovery . . . : Correct the statement to specify one value for each column. Ensure that the character designated as the decimal point is used correctly in any numeric literals. If any columns not specified in the INSERT column list were created as NOT NULL, specify values for those columns. If a data change INSERT statement contains an INCLUDE clause, ensure values are specified for all INCLUDE columns. Try the request again.

Message File : QSQLMSG
Library Message File : QSYS2924


General Data in Customer Master   BAL_S_LOG - Application Log: Log header data  
This documentation is copyright by IBM.

Length: 3236 Date: 20240420 Time: 024359     sap01-206 ( 4 ms )