Difference in basic SELECT and cursor select

meenal_mainframes · New User Joined: 07 Jul 2006 Posts: 9 Location: USA

can someone tell me difference b/w basic select and cursor query.
other than cursor fetches multiple rows

ravi17s · New User Joined: 15 Aug 2003 Posts: 57

Cursors can be used onlyin an Embedded SQL
Cursor can be declared with HOLD ,FOR UPDATE etc..
Different Types of Cursor' are:
SENSITIVE STATIC SCROLL,INSENSITIVE
SCROLL

SELECT returs SQLCODE=-811 if multiple row exist.
The main reason for the oigin of cursor is to select Multiple record.

Thx,
Ravi