I'm running a simple select query from my client. The connection appears to be successful, but there is no data being returned.

On running the event monitor, I could see SQLCODE 100. This i presume might be because of nothing being returned from the query.

Is this because SQL_CURSH200C4 cursor pointing to the end of the table.

If thats the reason, can anyone help me in resetting the cursor and also point out where this cursor resides.

Many Thanks in advance.