+354   A ROWSET FETCH STATEMENT MAY HAVE RETURNED ONE OR MORE ROWS OF DATA. HOWEVER, ONE OR MORE WARNING CONDITIONS WERE ALSO ENCOUNTERED. USE THE GET DIAGNOSTICS STATEMENT FOR MORE INFORMATION REGARDING THE CONDITIONS THAT WERE ENCOUNTERED

Explanation

A rowset FETCH statement encountered one or more warning conditions. Use the GET DIAGNOSTICS statement to obtain information about the conditions that occurred, and to determine if data was returned. It is possible that one or more rows of data were returned. If the row information that was returned for the row that encountered the condition is incomplete, do not use the data for the row that encountered the condition, such as displaying or printing the data.

System action

DB2® processed the statement successfully, but with a warning that the fetching of some rows might have encountered warnings.

Programmer response

Analyze the conditions to determine whether follow-up actions are needed. The GET DIAGNOSTICS statement can be used to determine which additional actions might be necessary.

Attention: It is also possible that an end of data condition was detected. SQLERRD3 and GET DIAGNOSTICS can be used to determine if all of the requested rows were fetched or if a partial rowset was returned.

SQLSTATE

01668