RE: newbie embedded SQL issue

The data is static....using a test-file in my library.

I change the compile-option "Close SQL cursor" to *ENDMOD. Seems to be
working properly!

Thanks for the input!!!

----- Original Message -----
From: Kurt Anderson <kurt.anderson@xxxxxxxxxxxxxx>
To: "'RPG programming on the IBM i / System i'" <rpg400-l@xxxxxxxxxxxx>
Date: Tue, 1 Sep 2009 13:17:14 -0500
Subject: RE: newbie embedded SQL issue

Ok, this may be a long shot, but....

Is your Select statement Declared in a cursor and the data retrieved is a

result of doing a Fetch? If that's true, and you're not closing your
cursor explicitly, is the program in actgrp *New? If not in *New, and
compile parameter CLOSQLCSR is *ENDACTGRP - then it's possible that that
is why you're seeing your expected results. In this case it will
continue to retrieve the next set of records.

-Kurt

-----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
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing

list

To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing

list

To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.