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