I am trying to delete a column of a DB2 table and reorganise the table structure without deleting the table.I am trying to to it in Dev region in my test table using DB2 admin command ALC.But when I am submitting the batch job with the DDL it is showing Maxcc 0 but it is not getting reflected in the table.
I have also tried with AL and ALM command giving the correct details of the table.
Can you please suggest how to do this without dropping the table.
CREATE TABLE xx.yy
(c1 CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT 'OLD' ,
c2 CHAR(35) FOR SBCS DATA NOT NULL
WITH DEFAULT ,
C3 CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT )
IN DATABASE DSNxxxx
DATA CAPTURE NONE
NOT VOLATILE ;
No, this ddl is creating a table, hence CREATE table.
Any DDL that changes a table structure would commence with ALTER table.
Although "standard" SQL allows :
ALTER TABLE table_name DROP COLUMN column_name
The DB2 SQLreference doens't mention it. Only following three are mentioned :
ALTER TABLE table_name ADD COLUMN column_name
ALTER TABLE table_name ALTER COLUMN column_name
ALTER TABLE table_name RENAME COLUMN column_name
Which would indicate that drop column isn't implemented in V9.