topic OPEN SQL WHERE CLAUSE in Application Development and Automation Discussions

OPEN SQL WHERE CLAUSE

Former Member — Tue, 24 Feb 2009 01:46:34 GMT

Hello everybody,

I have to do a select to the EDIDC table as follows:

CONCATENATE '%' wa_idocs-idocfuente '%' INTO idockey.

SELECT SINGLE docnum status

INTO (wa_idocs-idocdestino,wa_idocs-statusdest)

FROM edidc

WHERE arckey LIKE idockey.

now this is very poor performance query, now the problem is that the arckey field is a string field, now does anyone nows a more efficient way to do this, we are evaluating an Index but that would mean more space, thanks for any suggestions.

Regards,

Julio

Re: OPEN SQL WHERE CLAUSE

former_member156446 — Tue, 24 Feb 2009 02:08:21 GMT

use selopt std. structure and build a range table and use that....

selopt-sign = 'E'.
selopt-option = 'CP'.
concatenate '*' wa_itab-value '*' into selopt-low.

append selopt.

select......where value in selopt.

Re: OPEN SQL WHERE CLAUSE

Former Member — Thu, 30 Jul 2009 16:17:21 GMT

thanks for you answer