Skip to Content
0
Former Member
Aug 02, 2012 at 02:46 PM

Static SQL variable binding in SEM-BCS / BW applications

20 Views

Hello,

this is not neccesarily critical but strikes me as rather odd for SAP applications using the Oracle RDBMS.

"BW" seems to issue SQL-Statements without dynamic variable binding, that is I can see SQL-Statement with literals:

SELECT "S27"."/BIC/ZBCS_VER1" AS "ZBCS_VER1" , ...

AND ( ( "D1"."SID_ZBCS_VER1" = 2 ) ) AND ( ( "D1"."SID_ZBCS_VER2" = 6 ) ) AND (

( "D1"."SID_ZBCS_VER3" = 3 ) ) ) )

Usually Statements shouldn't use literals, so that the query looks like this:

"D1"."SID_ZBCS_VER1" = :1

The negative effects of this are among others higher memory consumtion and higher parse rates.

These statements stem from program UCUWB000 in our SEM-BCS system.

I've not come accross this before when analysing SQL-Statements issued by SAP applications, so this seems to be something specific to BW or SEM-BCS.

Can anyone share his / her knowlede on this?

Thanks a lot,

Thorsten