Skip to Content
0
Former Member
Feb 18, 2011 at 06:25 PM

%_HINTS DB2 'index

382 Views

Hi,

I have the following select statement:

SELECT mandt zpod zzanno zzmese

INTO TABLE i_zpod

FROM zkr_val_en_forn

CLIENT SPECIFIED

WHERE mandt EQ sy-mandt

AND zzanno EQ p_anno

AND zzmese EQ p_mese

AND bukrs IN s_societ

%_HINTS DB2 'index("zkr_val_en_forn","ZKR_VAL_EN_FORN~00")'

I want to force DB2 to utilize the index '00' of 'ZKR_VAL_EN_FORN' table, but does not work.

Which is correct syntax on DB2?

Kind regards,

Danilo