i have DB2 table to which i added a new column as CHAR(01) instead of CHAR(02) by mistake, in PROD environment.
Now i want to increase the size of this column using ALTER command:
ALTER TABLE PXNA.XNA_TMFS_MAIN
ALTER COLUMN XNA_MFS_ACTIMIZE_STATU SET DATA TYPE CHAR(02);
The DCLGEN definition of the column is correct since it was migrated from TEST where the column size is already CHAR(02)
XNA_MFS_ACTIMIZE_STATU CHAR(2) NOT NULL,
My question is this:
1) This new field is referred just in 2 online programs. Are they to be re-bind in order to change take effect?
2) Also there are some other programs which are not referring to this new column (XNA_MFS_ACTIMIZE_STATU). Are they also have to be re-bind?
I didn't bind them after i inserted this column, so i don't think it is required after resize, either.. Can you please confirm?
Thanks for your precious replies in advance.