IBM Mainframe Forum

Hi,

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.
Kind regards.

Kerem

the rule of thumb is that if you make a structural change to a database, you need to rebind the programs that are going to use the change.

I hope this helps