Truncate Custom DBT Dynamically ?

Former Member — Sat, 25 Apr 2009 09:45:15 GMT

Dear All,

How to delete entries from a particular Custom DBT specified on the selection screen ?

Directly this is working.........



 exec sql.
  Truncate table "ZTEST_DEL"
 endexec.

But, dynamically what should be written ?

I tried to pass the table as a variable with Double quotes. But still it's not working.

Any clues ???

Regards,

Deepu.k

Re: Truncate Custom DBT Dynamically ?

Former Member — Sun, 26 Apr 2009 06:35:25 GMT

Did you try like:


 exec sql.
  Truncate table 'ZTEST_DEL'
 endexec.

Regards

Shital