Skip to Content
0
Former Member
Jan 10, 2006 at 01:52 PM

DELETE with SELECT-OPTIONS

812 Views

Hi.

I want to know if we can use a SELECT-OPTION in a query to delete a TABLE ?

For example :

 
SELECT-OPTIONS:
    so_tname FOR DD02L-TABNAME.

I know in a select I can do something like that :

SELECT TABNAME
  FROM DD02L
  INTO TABLE INT_TAB
  WHERE TABNAME IN so_tname 

Can we use something similar in a DELETE query ? Because for the moment i'm only able to do that with a parameter on 1 table.

DELETE
  FROM (p_tab) 
  WHERE ....

Thanks