Re: Sqlcod question

[Dave <dfx1@xxxxxxxxxxxxxx>]

I think SQLCOD should be 0100 if no row is found.

2012/11/19 <Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx>

> 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.