How to modify a column attribute like Length,PIC in DB2?

softwareengineer · New User Joined: 24 Aug 2005 Posts: 24 Location: Hyderabad

How to modify a column attribute like Length,PIC in DB2?

My question is quite big. If I want to change a field/column name say NAME of length '3' to '5'. How can I modify my table with out effecting existing info?

once after making field lenght changes in my DB2 table, what else needs to be done in my COBOL-DB2 program to accomodate tht field modification and what abt the Precompile , Bind process??

Thanks in advance.

muthuvel · Posted: Thu Jul 12, 2007 3:14 pm

I think a developer will not be given permission for changing the column alteration in DB2.You have to get in touch with your DBA team who will be doing the changes as per the requirement.

In case of COBOL+DB2 program,you must find the programs in which the modified table is used and in specific,the affected column is used.All the programs which use the modified column in any of the SQL type(select,insert,update or delete) needs a recompilation.The program logic also needs a double check since the field size is increased.

Hope this helps.

softwareengineer · New User Joined: 24 Aug 2005 Posts: 24 Location: Hyderabad

Yes. As a developer, we are not given access to do so. This question was asked in a interview. I just want to how we can do it in test region. please provide the answer from DBA point of view.