How to get multiple rows without using cursor.

sanjib234 · New User Joined: 19 Jun 2007 Posts: 12 Location: delhi

Can anyone help me how to select multiple rows without using cursor.

TG Murphy · Posted: Wed Jul 04, 2007 8:10 pm

There is no sensible way to select multiple rows without using a cursor.

Use the cursor.

By the way, why do you want to avoid the cursor?

stodolas · Posted: Wed Jul 04, 2007 8:13 pm

In COBOL? You can't. There is not a way to pull a series of rows back into any kind of working storage all at once. You could create a cursor and do repeated fetches filling a working storage table. But, thats about the best you will get.

dick scherrer · Posted: Wed Jul 04, 2007 9:03 pm

Hello,

As was asked before, why do you not want use a cursor?

You will find that somewhere between many and most coding situations work with multiple rows and therefore use a cursor.

sanjib234 · New User Joined: 19 Jun 2007 Posts: 12 Location: delhi

Thnx alot .....this question was from CTS

sanjib234 · New User Joined: 19 Jun 2007 Posts: 12 Location: delhi

[quote="sanjib234"]Thnx alot .....this question was from CTS

dick scherrer · Posted: Wed Jul 04, 2007 10:16 pm

You're welcome

FMI (for my info) - what is CTS?

sanjib234 · New User Joined: 19 Jun 2007 Posts: 12 Location: delhi

CTS stands for Cognizant

dick scherrer · Posted: Wed Jul 04, 2007 11:21 pm

Thanks