Page 1 of 1

DB2 Query - 'Drop Table'

PostPosted: Wed Nov 24, 2010 2:41 pm
by ajit mainframe
Hi,
I am developing a tool for which i need to write an embedded DB2 query in my cics-cobol program for 'drop table'. can any one help me with the exact query ?

Re: DB2 Query - 'Drop Table'

PostPosted: Wed Nov 24, 2010 9:03 pm
by GuyC
I'm sure the SQL Reference can help you

Re: DB2 Query - 'Drop Table'

PostPosted: Thu Nov 25, 2010 12:42 pm
by ajit mainframe
what does it exactly mean by sql reference ?

Re: DB2 Query - 'Drop Table'

PostPosted: Thu Nov 25, 2010 12:52 pm
by dick scherrer
Hello,

GuyC is suggesting you read the SQL Reference manual for your release of DB2.

DROP TABLE syntax is described in the documentation. If you find something in the manual that is not clear, post what you found and hyour doubt. Someone will be able to clarify.

Suggest also that you speak with your dba or project manager and see if it is permissable to drop tables in your code. Many organizations do not permit developers to drop tables.