Drop Table

nima511 · Post by **nima511** » Mon May 10, 2010 11:22 am

Can we drop a table using a DataStage Job?
Database where the table resides is a SQL Server.

swarnkar · Post by **swarnkar** » Mon May 10, 2010 12:53 pm

nima511 wrote:Can we drop a table using a DataStage Job?
Database where the table resides is a SQL Server.

Yes but the User (With which you are connecting to database) should have sufficient privilege to drop table.

You can do that in ODBC stage as Before or after command

Thanks,
Nitin Swarnkar

ray.wurlod · Post by **ray.wurlod** » Mon May 10, 2010 4:15 pm

... or automatically if you are also choosing to re-create the table.

DSXchange

Drop Table

Drop Table

Re: Drop Table