How to Fetch multiple rows in single fetch on RPGLE program

[naveen_hbtik]

Hi Team,

I need to fetch the complete physical file using a single fetch in SQLRPGLE and then need to populate the same in the array which need to be send to ASP application in the form of record set.

Is it possible in AS/400 since as far as I know we can fetch one row at a time in SQLRPGLE program.

Thanks,
Naveen

[FaStOnE]

Re: How to Fetch multiple rows in single fetch on RPGLE program

At the top of the screen in Code400.com/Forum, there is a menu option called SEARCH ... click on that and type "Fetch Multiple Rows" and click on GO.

Let's see what happens...

*bhot*

[B.Hauser]

Re: How to Fetch multiple rows in single fetch on RPGLE program

Kit! Your turn

[kitvb1]

Re: How to Fetch multiple rows in single fetch on RPGLE program

@Biggie.. Nah! I liked Rick's answer.
@Rick.. first prize to you - a new avatar

[pramendra]

Re: How to Fetch multiple rows in single fetch on RPGLE program

Hey you use Sql Cursor for fetching multilple rows for more info use search info of this forum ...or google please

here u can get some examples


http://www.code400.com/viewsamples.php?lang_id=3