RE: newbie embedded SQL issue

It might help if you posted the SQL statement and what the differences are between executions.

SQL is not guaranteed to return a result set in the same order unless you specify an order by clause. Could that be it maybe?

Rick

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of rixone@xxxxxxxxxx
Sent: Tuesday, September 01, 2009 12:43 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: newbie embedded SQL issue

I have written an SQLRPGLE program. Appears to run fine, with this issue: Invoke the program...and the results are the same as when I do an SQL select. Run it a second time...and the results are different. Run it a third time....and the results are different than the second. What do I need to do so to get consistent results that match a standard SQL select?

Thanks!

Rick

Privileged and Confidential. This e-mail, and any attachments there to, is intended only for use by the addressee(s) named herein and may contain privileged or confidential information. If you have received this e-mail in error, please notify me immediately by a return e-mail and delete this e-mail. You are hereby notified that any dissemination, distribution or copying of this e-mail and/or any attachments thereto, is strictly prohibited.