Skip to Content
0
Former Member
Apr 28, 2009 at 11:10 AM

Problems with Hints in abap code to use an index in a Select statement

861 Views

Hi,

I want to use an especific index in a select statement but I can´t get it. I use de next statement:

SELECT ltaklgnum ltaktanum ltakvbeln ltaptapos ltapnltyp ltappvqui

FROM ltak AS ltak INNER JOIN ltap AS ltap

ON ltaktanum = ltaptanum

AND ltaklgnum = ltaplgnum

INTO TABLE l_t_tanum_silo

WHERE ltap~lgnum EQ ip_lgnum

AND ltap~pquit EQ ' '

AND ltak~lgnum EQ ip_lgnum

AND ltak~kquit EQ ' '

AND ltak~queue EQ ip_queue

%_HINTS DB2 ''.

We have DB2 for Linux Unix and Windows 9.5 as DB system.

How can I fix this?

Thanks a lot.

Regards