Re: Sqlcod question

[Michael Ryan <michaelrtr@xxxxxxxxx>]

SQLER3 also returns the row count I believe.


On Mon, Nov 19, 2012 at 11:59 AM, <Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx>wrote:

> Because the statement completed successfully with no errors.  Use GET
> DIAGNOSTICS to retrieve the row count.
>
>
> Thanks,
> Tommy Holden
>
>
>
> From:   Rpglist <rpglist@xxxxxxxxxxx>
> To:     rpg400-l@xxxxxxxxxxxx,
> Date:   11/19/2012 10:57 AM
> Subject:        Sqlcod question
> Sent by:        rpg400-l-bounces@xxxxxxxxxxxx
>
>
>
> I have the following embedded code:
>
> Exec SQL
>    Declare C1 cursor for
>       Select * from rates
>       Where opcode =:zcode;
> Exec SQL open C1;
>
> Now I know for a fact that there will not be a match right now meaning
> that the value of zcode is not in the file.....so why does Sqlcod return
> all zeros?
>
> Sent from my iPhone
> --
> 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.