Is new opensql available in bw routines ?

[Former Member]

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

[sander_vanwilligen]

Hi Christophe,

I suggest to move your coding under the comment line:

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

DATA: s_C_MYINFOOBJ TYPE RANGE of /BIC/OIC_MYINFOOBJ.

...

to another place:

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

The 2nd part of global is not part of the new ABAP Objects framework for 7.0 Transformations. It is meant as a migration area for obsolete 3.x Transfer Rules/Update Rules. You can refer to SAP Note 1052648 - Migrating transfer rules and update rules for BW7.x for more information.

Best regards,

Sander

[Former Member]

Thanks Sander for your reply,

I moved my DATA statement to the place you mentionned but it still gives the sames result : no errror when controlling the routine and an error while activating the transformation.

Regards

Christophe

[sander_vanwilligen]

Hi Christophe

Where did you find this coding example?

Although I am not familiar with your programming example, I expect that it should also work in the context of a BW Transformation.

However, let's check it. I suggest to make a small custom program using t/code SE38 and test the coding here. I use this approach regularly to be sure that my syntax is correct and it's very easy to debug it from here.

Please share your findings. Thanks in advance.

Best regards,

Sander