View previous topic :: View next topic
|
Author |
Message |
i413678 Currently Banned Active User
Joined: 19 Feb 2005 Posts: 112 Location: chennai
|
|
|
|
Hi,
Any way to handle the condition where embedded select returning more than one row other than using the cursor.
thnx in advance...............
pavan |
|
Back to top |
|
|
khamarutheen
Active Member
Joined: 23 Aug 2005 Posts: 677 Location: NJ
|
|
|
|
Hi pavan,
Cursors are the option used in Embedded SQL to retrive more than one rows i dont think there is any alternative option avail... |
|
Back to top |
|
|
mijanurit Currently Banned New User
Joined: 26 Aug 2005 Posts: 33 Location: bangalore
|
|
|
|
hi i413678,
if u use c or other high level language then there is other alternative ways to retrieve more than 1 row at a time through select statement.
but as COBO ,PL/I they don't have capability to retrieve more than one row at a time, cursor is introduced.
hence in COBOL, PL/I to retrieve more than one row cursor is the only way.
regards
mijanurit |
|
Back to top |
|
|
manjinder
New User
Joined: 04 Dec 2005 Posts: 45 Location: pune
|
|
|
|
i think only cursor in the way to handle this condition otherwise you can check this out giving two condition in the query.
regards...
manjinder
correct me if wrong |
|
Back to top |
|
|
|