×
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.
Hi,
I'm trying to use a variable to list some values that I want to use on an
IN statement on my WHERE clause but don't seem to able to get it quite
right.
Interactive SQL returns a result but the program doesn't
It returns SQLSTATE='02000' SQLCODE=100
EXEC SQL
SELECT LOC INTO :wLOC
FROM LOCATION
WHERE LTYP NOT IN ('F','H','I','O','B') AND
SUBA IN (:wSUBA) AND
PALT = :wPALT
The string :wSUBA is formatted as 'AA ','AB ','AC ','AD ','AE'
I tried moving the brackets into the string but that didn't work
I also tried removing the quotes and just comma separating but that didn't
work
Is what I'm doing even possible or do I need to split them out and check
one by one?
I'm probably doing something really stupid.
Any help much appreciated.
Regards.
Liam.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 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.
midrange.com
