Skip to Content

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

Delete records using Script, variables and multiple values


I have a source file in one DB and target file in another DB.

I want to delete records in the target file where targetfile.month=sourcefile.month

How can I achieve this?

I tried to use scripts with variables

Example :

$variable1 = sql('DB1', 'select month from sourcefile');

sql('DB2', ' delete from target file where month = {$variable1} ')

But apparently since $variable1 can hold only one value I am not getting the results I want. I have multiple values for the first statement above and its not fixed. How do I store multiple values in a variable or create an array? please eplain with the format for any function if we have one.


Using DS Designer

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