Truncate Custom DBT Dynamically ?

[Former Member]

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

[Former Member]

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

[Former Member]

Did you try like:

 exec sql.
  Truncate table 'ZTEST_DEL'
 endexec.

Regards

Shital