DB2 Query - 'Drop Table'



IBM's flagship relational database management system

DB2 Query - 'Drop Table'

Postby ajit mainframe » Wed Nov 24, 2010 2:41 pm

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 ?
ajit mainframe
 
Posts: 5
Joined: Mon Oct 25, 2010 9:55 am
Has thanked: 0 time
Been thanked: 0 time

Re: DB2 Query - 'Drop Table'

Postby GuyC » Wed Nov 24, 2010 9:03 pm

I'm sure the SQL Reference can help you
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times

Re: DB2 Query - 'Drop Table'

Postby ajit mainframe » Thu Nov 25, 2010 12:42 pm

what does it exactly mean by sql reference ?
ajit mainframe
 
Posts: 5
Joined: Mon Oct 25, 2010 9:55 am
Has thanked: 0 time
Been thanked: 0 time

Re: DB2 Query - 'Drop Table'

Postby dick scherrer » Thu Nov 25, 2010 12:52 pm

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post