×
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 believe IBM's recommendation is to use dynamic SQL. You build your
SELECT statement and PREPARE it.
Alternatively, I have avoided dynamic SQL in the past by using a
"BETWEEN" construct rather than switches.
In the WHERE I would have something like 'cuszip beteen :ziplow and
:ziphigh'.
- If just one zip was needed both ziplow and ziphigh would contain
that zip.
- If there was no zip selection the values would be 00000 and 99999 to
include all zips.
- If a range was needed they would contain the zip range.
I suspect that this technique will not disqualify the use of indexes,
though it might cause the query to be re-optimized. But IBM is likely
to suggest against this as it may impact performance. I had no
performance issues, but as always, your mileage may vary.
Sam
On 3/7/2020 11:43 PM, Mónica Anastácio wrote:
Imagine u have 5 ou more fiels of selection
I want to have just 1 select with all the fields and if when a field dont
have information, ignore
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
