Re: SQL select using where in

Thanks for the reply, I'll break up the variable into separate fields.


On Tue, Feb 12, 2013 at 2:18 PM, Jack Callahan <jjcllhn@xxxxxxxxx> wrote:

SQL doesn't know how to handle the list as a variable, so you have two
choices:

1) use dynamic SQL, Build the SQL statement as a string, PREPARE the
statement, and then EXECUTE it.

2) "parameterize" the elements of your list. (WHERE pypmtt IN ( :CHKTYPE1,
:CHKTYPE2 )

On Tue, Feb 12, 2013 at 1:50 PM, Rettig, Roger <roger.rettig@xxxxxxxx

wrote:

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.

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