|
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.