hi,
Iam Giridhar here is my doubt plz answer to this question and thanksa in Advance.
Q.Can we change the Data size in Db2.if we can how ew can change.Is it possible using ALTER Command?
Ex: in Table empName char(20) but ii is necessary to make is char(30),how?
Yes, We can change the Data Type / Size of the column after DB2 8.0. before that it's possible to change the size of the column if it's declared as VARCHAR.
Quote:
if we can how ew can change
Using ALTER TABLE... ALTER COLUMN statement
Quote:
Table empName char(20) but ii is necessary to make is char(30),how?
ALTER TABLE EMP ATLER COLUMN EMPNAME SET DATA TYPE CHAR(30)
