database hints in select statement

Former Member — Mon, 31 Jan 2011 20:34:31 GMT

Hi all,

i need to apply the databaser hints for my select statement where i am using for all entries clause .But the issue is that i am getting the dump when i am tring with the same .

If i use the hint without all entries clause ,it runs fine.

The query where i need to apply the hint is :

SELECT * FROM bsim "n443935

INTO CORRESPONDING FIELDS OF TABLE g_t_bsim_lean "n443935

FOR ALL ENTRIES IN t_bwkey WHERE bwkey = t_bwkey-bwkey

AND matnr IN matnr

AND bwtar IN bwtar

AND budat >= datum-low.

and the DB hint is:

Addition of database hints for DB6 as per OSS message 649621

%_HINTS
DB6 'USE_OPTLEVEL 7' " Insert CR-1000000473 Tr-D11K934315
DB6 '&SUBSTITUTE VALUES&'.

Let me know whats the issue for the dump in for all entries in clause.

Re: database hints in select statement

former_member182670 — Mon, 31 Jan 2011 22:45:18 GMT

Did you check if [https://service.sap.com/sap/support/notes/1520152|https://service.sap.com/sap/support/notes/1520152] applies?

topic database hints in select statement in Application Development and Automation Discussions

database hints in select statement

Re: database hints in select statement