Re: Sqlcod question

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