Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Is new opensql available in bw routines ?

Hi,

I'm creating a transformation on a bw 7.4 SP8 and I was wondering if I could use new opensql in a start routine.

I did the following :

*$*$ begin of 2nd part global - insert your code only below this line  *

DATA: s_C_MYINFOOBJ TYPE RANGE of /BIC/OIC_MYINFOOBJ.

...

...

*$*$ begin of routine - insert your code only below this line        *-*

SELECT   C_MYINFOOBJ as low,

        'I' as sign,

        'EQ' as option

into corresponding fields of table @s_C_MYINFOOBJ

FROM ZDEL_MYINFOOBJ_LIST.

DELETE SOURCE_PACKAGE WHERE MYSOURCEFIELD IN s_C_MYINFOOBJ.

When I check if the syntax is correct, i have no error. But when I try to activate the transformation, it says that there's an error in the start routine.

Is there really something incorrect in my code or new opensql is not allowed in BW transfo?

Thanks for your help

Christophe

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question