DROP with JDBC ADAPTER

[Former Member]

Hi experts,

anyone know how i can execute a "drop table" with JDBC adapter in xi.

thank you very much

[Former Member]

Hi Antonio,

anyone know how i can execute a "drop table" with JDBC adapter in xi. 

Yes, someone knows how this can be done

Use Stored Procedure. Dropping a table is really not advisable. Rest depends on your Business requirements.

regards,

Neetesh

[prateek]

Is it really a business requirement to Drop a table using interface? There are no direct "action" available in receiver jdbc format to drop a table. You may write a stored procedure which can be executed from PI but dropping a table in each call of interface doesn't look very logical.

Regards,

Prateek