Selecting/Deleting data from SAP CRM table

[hector_andres_garcia]

Hi guys,

I came across I limitation I did not know about. It seems you cannot issue SQL commands down to SAP from within a DS script:

What I need to do, is to extract data from a Oracle 11g DB table into a SAP CRM table, but first I have to delete data from this table, all of it based on BODS parameters.

Basically,

Delete from CRM.TabA where BODS parameter values

Select from Oracle.TabA --> Insert into CRM.TabA where CRM.TabB values

Is this a real limitation or I'm I doing something wrong? Any other ideas to achieve this?

Thanks

[hector_andres_garcia]

Isn't it even possible to assign multiples values to a global variable derived from a table, and use this variable to filter an query transform?

I'm surely doing something wrong, but a workaround I found to overcome my issue is:

CRM.TabA --> query transform --> Template table

My template table holds my filter values, and I can write an SQL in a script to get them, however it seems there is no way to get more than one value.

For example

EMPLOYEE NAME

Dave

Mark

How do you code the SQL statement to get both values in a Global variable within a script?