Re: AW: Strange issue in embedded sql

[Nisha Ramesh <n4nisha@xxxxxxxxx>]

Any way to clear the cursor?
On Jan 31, 2013 3:13 PM, "Nisha Ramesh" <n4nisha@xxxxxxxxx> wrote:

> Still the same issue....:(
> On Jan 31, 2013 2:42 PM, "Birgitta Hauser" <Hauser@xxxxxxxxxxxxxxx> wrote:
>
> > Try to close the cursor first, i.e. immediately before the PREPARE
> > Statement.
> >
> > Mit freundlichen Grüßen / Best regards
> >
> > Birgitta Hauser
> >
> > "Shoot for the moon, even if you miss, you'll land among the stars." (Les
> > Brown)
> > "If you think education is expensive, try ignorance." (Derek Bok)
> > "What is worse than training your staff and losing them? Not training them
> > and keeping them!"
> >
> > -----Ursprüngliche Nachricht-----
> > Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
> > Im
> > Auftrag von Nisha Ramesh
> > Gesendet: Thursday, 31.1 2013 10:08
> > An: rpg400-l@xxxxxxxxxxxx
> > Betreff: Strange issue in embedded sql
> >
> > I have a program which accepts the Sql statements user enters and these
> > statements are passed onto a sqlrpgle program which declare a scroll
> > cursor
> > and prepares the sql from the string which holds input parameter. It then
> > issues a fetch first statement into a field which will hold the query
> > reasult. I am checking sql code to determine whether the entered query is
> > valid or not. I close the cursors after this. If first time i entered a
> > valid sql i get the result..for second time if some irrelevant data is
> > entered still the fetch statement returns previous sql's output and sqlcod
> > also is zero as if i entered correct sql. Pls help me to figure out the
> > problem here....
> > --
> > This is the RPG programming on the IBM i (AS/400 and iSeries) (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 (AS/400 and iSeries) (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.