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 ?
DB2 Query - 'Drop Table'
Previous topic • Next topic • 4 posts
• Page 1 of 1
DB2 Query - 'Drop Table'
by ajit mainframe » Wed Nov 24, 2010 2:41 pm
- 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'
by 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'
by 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.
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.
d.sch.
-
dick scherrer - Global moderator
- Posts: 6268
- Joined: Sat Jun 09, 2007 8:58 am
- Has thanked: 3 times
- Been thanked: 93 times
Previous topic • Next topic • 4 posts
• Page 1 of 1
-
- Related topics
- Replies
- Views
- Last post
-
- How to drop 2 columns from DB2 table?
by shankar_dh » Thu Oct 30, 2014 12:31 pm - 7 Replies
- 3806 Views
- Last post by heshmahesh
Thu Nov 20, 2014 7:29 pm
- How to drop 2 columns from DB2 table?
-
- Table Updation using Query
by gopi palanisamy » Mon Jun 21, 2010 4:01 pm - 4 Replies
- 2337 Views
- Last post by GuyC
Wed Jun 30, 2010 1:47 pm
- Table Updation using Query
-
- How to create a table similar to the output of a query?
by nitinsharma_1212 » Tue Apr 08, 2008 6:50 am - 1 Replies
- 2294 Views
- Last post by dick scherrer
Tue Apr 08, 2008 8:38 am
- How to create a table similar to the output of a query?
-
- need a query to delete duplicate records from a table
by var111 » Wed Nov 05, 2008 12:00 pm - 4 Replies
- 2760 Views
- Last post by var111
Fri Nov 07, 2008 4:13 pm
- need a query to delete duplicate records from a table
-
- Query to get table record count inDB2 schema
by ritikasingh » Thu Jul 14, 2011 8:06 pm - 3 Replies
- 7753 Views
- Last post by GuyC
Fri Jul 15, 2011 5:06 pm
- Query to get table record count inDB2 schema