Skip to Content
0
Former Member
Apr 09, 2008 at 12:16 PM

How to specify a particular index for DB2 database when using SQL in ABAP

18 Views

Is this format for Oracle?

-


select *

into -


from vbrk CLIENT SPECIFIED

where erdat in erdat

and mandt EQ sy-MANDT

%_HINTS ORACLE 'INDEX("VBRK" "VBRK~ZER")'

.

-


For the index 'VBRK~ZER' was defined before,it only includes one field 'VBRK-ERDAT'.

How can i tell Sap to use this index while processing SQL in DB2?

Thanks advance.