×
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.
On 25-Nov-2013 05:32 -0800, ALopez@xxxxxxxxxx wrote:
<<SNIP issue with Select/Omit LF msgCPI432D RC11 "11 - The access
path contains static select/omit selection criteria which is not
compatible with the selection in the query."; IBM pursuing fix>>
I would investigate the result of the Retrieve\Generate SQL DDL
feature [Generate Data Definition Language (QSQGNDDL) API or via GUI] to
ensure that the equivalent INDEX DDL is created properly from the LF
[shown in the OP with the given DDS using assorted compare (CMP or COMP)
tests]:
create index PRODCTL/F0005L1
on table PRODCTL/F0005
( DRSY , DRRT , DRKY )
where ( DRSY = '00'
and DRRT in ('01','02','03','04','06')
)
or ( DRSY = '09'
and DRRT in ('22', '23', '24', '25', 'LT', '11')
)
Or even perhaps, eventually, replace the DDS S\O LF with effectively
that [sparse index] SQL INDEX.
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
