×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Yes, for sure check after the Fetch,
but also do check after the Declare.
The specific answer to your question is SQL
returned all zeros because the Declare statement
completed without error.
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Rpglist
Sent: Monday, November 19, 2012 10:01 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: Sqlcod question
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.
midrange.com
