Is new opensql available in bw routines ?
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
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