Re: AW: Strange issue in embedded sql

[Nisha Ramesh <n4nisha@xxxxxxxxx>]

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.