SQL List value as a variable

[Jeff Young <cooljeff913@xxxxxxxxx>]

I am attempting to pass a list value as a variable in an SQLRPGLE program.
The value of the variable (after removing the extra quote) is ('BK','BE',RE').
My variable name is Bulk_Type.
The SQL statement is :
Select Count(*)  into :Nbr from workfile where type not in :Bulk_Type

The only records in my file all have a type of BK.
The SQL statement returns a value equal to all of the records in the file.
The SQLCOD is 0, SQLSTT is 0.

What do I need to do to make this work?

TIA,
 
Jeff Young 
Sr. Programmer Analyst
Dynax Solutions, Inc.
A wholly owned subsidiary of enherent Corp.
IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions V5R2 
IBM  Certified Specialist- e(logo) server i5Series Technical Solutions Designer 
V5R3
IBM  Certified Specialist- e(logo)server i5Series Technical Solutions 
Implementer V5R3

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com