FOREACH cursor sequence

Posted in 2008

falconsoon@gmail.com — Sun, 27 Apr 2008 20:21:33 -0700 (PDT) — source: Usenet: comp.databases.informix

I have a table with row 1, row 2, row 3, and etc. If I use foreach cursor to loop through the rows, will the rows been retrieved in sequence, i.e. follow row 1, row 2, row 3, and etc sequence? Or it will been retrieved without follow the original sequence, i.e. may be row 2, row 1, row 3, and etc? Thanks for anyone who can help to clarify it. Thanks.

↪ replying to falconsoon@gmail.com

Jarrod Teale — Mon, 28 Apr 2008 15:27:58 +1200 — source: Usenet: comp.databases.informix

If you want to control to order, add an ORDER BY clause to the query that the cursor is running. Otherwise you have no control of the order - the rows will be returned as the database finds them. Jarrod Teale -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of falconsoon@gmail.com Sent: Monday, 28 April 2008 3:22 p.m. To: informix-list@iiug.org Subject: FOREACH cursor sequence I have a table with row 1, row 2, row 3, and etc. If I use foreach cursor to loop through the rows, will the rows been retrieved in sequence, i.e. follow row 1, row 2, row 3, and etc sequence? Or it will been retrieved without follow the original sequence, i.e. may be row 2, row 1, row 3, and etc? Thanks for anyone who can help to clarify it. Thanks. _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list