×
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.
I don't think you can use a host variable in that manner.
You could do:
Where pypmtt in (:CheckType1, :CheckType2);
Or, you can use dynamic SQL to build the entire statement into a variable, then execute that SQL statement using a prepared cursor.
http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.sqlt.doc/sqltmst204.htm
-Kurt
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Rettig, Roger
Sent: Tuesday, February 12, 2013 12:51 PM
To: RPG400-L@xxxxxxxxxxxx
Subject: SQL select using where in
I have a SQL clause embedded in a RPG program. The statement inserts records directly into a file. In the where clause, I have an 'in'
statement using a variable:
Where pypmtt in :CheckType
using debug the value of checktype = ('CK', 'BT'). This inserts 0 records.
If I hardcode and replace checktype with ('CK', 'BT'), the program inserts the the correct records. There are other variables in the select statement that are not causing issues.
What am I doing wrong?
--
Roger Rettig
Business Analyst
Cincinnati Incorporated
roger.rettig@xxxxxxxx
--
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.
midrange.com
