MVSFORUMS.com

slade

Hi Folks,

If a DB2 table is changed to expand one of its columns, aside from those pgms accessing the column, do pgms accessing other fields in the table have to be recompiled and/or rebound? I did a search but didn't find anything helpful.

I'd appreciate any help you can offer.

Thanx, Jack.

Glenn · Beginner Joined: 23 Mar 2003 Posts: 56 Topics: 3

That's the beauty of DB2...no no changes have to be made for other columns, assuming there wasn't any funny business like redefines or anything. Always check programs closely, but no, there's no "record format" in DB2 since DB2 doesn't work in terms of records but fields.

SureshKumar · Intermediate Joined: 23 Jan 2003 Posts: 211 Topics: 21

Slade,
As Glenn stated there will be no impact on programs refrencing other columns in an application, however you need to do your DD on the application logic. If some application is just doing an Insert and the new column is not referenced it's possible to put default values(which may not be the right thing), else if the column is NOT NULL then the job can go down.

Regards
Suresh

slade · Posted: Fri Mar 05, 2004 9:22 am Post subject:

Hi guys,

Thanx for the quick responses.

Another related question, if you don

SureshKumar · Intermediate Joined: 23 Jan 2003 Posts: 211 Topics: 21

Slade,
if the Column is declared with NULL it will be null, if its NOT NULL WITH DEFAULT it will be the default value provided, If its NOT NULL it will fail. I have not tried View row Insert. Thanks

slade · Posted: Fri Mar 05, 2004 10:03 am Post subject:

Hi Suresh,

Now I've got it!

Thank you, and thank you, Glenn for your help.

Jack