IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Column deletion in table
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
hibuddies
Warnings : 1
New User


Joined: 06 Feb 2007
Posts: 20
Location: Bangalore
PostPosted: Mon Nov 05, 2007 7:48 pm
 Reply with quote
Hi all,


Anyone please let me know
1. How to delete a particular column in DB2 from a table.
2. How to change the size of defined field in the table.


Thanks in advance.
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA
PostPosted: Mon Nov 05, 2007 7:57 pm
 Reply with quote
hibuddies wrote:
Hi all,


Anyone please let me know
1. How to delete a particular column in DB2 from a table.
2. How to change the size of defined field in the table.


Thanks in advance.


1. Drop the table and redefine it.

2. In most cases drop the table and redefine it. Look at the alter table command in the SQL Reference.
Back to top
View user's profile Send private message
hibuddies
Warnings : 1
New User


Joined: 06 Feb 2007
Posts: 20
Location: Bangalore
PostPosted: Mon Nov 05, 2007 8:28 pm
 Reply with quote
Hi..

Ya i tried ALTER command with MODIFY option but it doesnt support in DB2. Is there any other way to implement this task? If so please let me know.

Thanks.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 

Similar Topics
Topic Forum Replies
No new posts Replacing 'YYMMDD' with date, varying... SYNCSORT 3
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Pulling a fixed number of records fro... DB2 2
No new posts How to load to DB2 with column level ... DB2 6
No new posts RC query -Time column CA Products 3
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us