when a new column is added to table



IBM's flagship relational database management system

when a new column is added to table

Postby pradeepgowda » Wed Mar 31, 2010 11:33 am

suppose if a cobol-db2 program is referencing some table TABLEA.
what happens if a new column is added to an existing table TABLEA
and,

a) select * is coded in the cobol- db2 program
b)if the new column is not referenced in the cobol-db2 program
pradeepgowda
 
Posts: 40
Joined: Mon Jan 04, 2010 4:17 pm
Has thanked: 0 time
Been thanked: 0 time

Re: when a new column is added to table

Postby dick scherrer » Thu Apr 01, 2010 12:36 am

Hello,

a) Suggest select * not be used in a cobol program other than for homework assignments.

b) Nothing will happen (unless i misunderstand the question).
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post