Return statement 100 in SQL and Fetch statement

ramesh_21 · New User Joined: 17 May 2006 Posts: 3

Hai,

I have executed an SQL stmt and the return code is 100

I have executed FETCH stmt and the return code is 100.

pl. explain the difference between the two cases.

with thanks
sai

Prasanthhere · Active User Joined: 03 Aug 2005 Posts: 306

Explanation: One of the following conditions occurred:

o No row met the search conditions specified in an UPDATE or DELETE
statement.

o The result of a SELECT INTO statement was an empty table.

o A FETCH statement was executed when the cursor was positioned after
the last row of the result table.

o The result of the subselect of an INSERT statement is empty.

When a SELECT statement is executed using SPUFI, this SQLCODE indicates
normal completion.