DB2 SQL-Error: -20186
SQLState: 07501
Short Description: A CLAUSE SPECIFIED FOR THE DYNAMIC SQL STATEMENT BEING PROCESSED IS NOT VALID
A clause was not valid for one of the following reasons: v On a PREPARE statement, a FOR SINGLE ROW or FOR MULTIPLE ROWS clause was specified. However, the statement that was being prepared was not an INSERT statement. v On a PREPARE statement, an ATOMIC or NOT ATOMIC clause was specified. However, the statement that was being prepared was not an INSERT statement. v On a PREPARE statement, a rowset-positioning clause was specified. However, the statement that was being prepared was not an INSERT statement. v On a PREPARE statement, a SENSITIVE DYNAMIC clause and SCROLL clause were specified. However, the content of the query requires the use of a temporary table for processing. v On an EXECUTE statement, a multiple-row-insert clause was specified. However, the statement that was being executed was not an INSERT statement. v On an EXECUTE statement, a multiple-row-insert clause was specified. However, the statement that was being executed was not an INSERT statement that was prepared with FOR MULTIPLE ROWS specified as part of the ATTRIBUTES clause on the PREPARE statement. v On an EXECUTE statement, a multiple-row-insert clause was not specified. However, the statement that was being executed was an INSERT statement, and FOR MULTIPLE ROWS was specified as part of the ATTRIBUTES clause on the PREPARE statement. v On an EXECUTE statement, a FOR n ROWS clause was specified. However, the INSERT statement that was being executed also contained a FOR n ROWS clause. v On an EXECUTE statement, host variable arrays were provided. However, the FOR n ROWS clause was not specified (on either the EXECUTE or INSERT statement).System action: The statement cannot be processed. Programmer response: Remove the clause that was not valid in the context in which it was used.