|
View previous topic :: View next topic
|
| Author |
Message |
ramsfm
New User
Joined: 05 May 2006
Posts: 12
Location: Pune
|
|
|
|
HI ,
I am going to add two more new fields in tables A & B.
Do we require to recompile all components which are using these tables?
Please clarify this ASAP.
We are using DB2 V7.1.0
Tx,
Ramesh. |
|
| Back to top |
|
 |
red_roses
New User
Joined: 31 Oct 2005
Posts: 27
|
|
|
|
| no, just compile the pgm that will use the new fields or the ones that have a 'select * ' query. |
|
| Back to top |
|
|
vijayakumar.yellala
New User
Joined: 19 Apr 2006
Posts: 63
Location: Chennai
|
|
|
|
Hello,
If in your program has SQL like " Select * from <table name> where condition,...."
this time u should have to recompile all the programs which are using that table...........
Correct me, If i am wrong...
.......Vijay |
|
| Back to top |
|
|
ofer71
Global Moderator
Joined: 27 Dec 2005
Posts: 2358
Location: Israel
|
|
|
|
Don't forget to rebind.
O. |
|
| Back to top |
|
|
ramsfm
New User
Joined: 05 May 2006
Posts: 12
Location: Pune
|
|
|
|
Hi All,
thanks for ur response.
Some components are using query on selected fields. in this case we no need to recompile right?
Please advice me on this. |
|
| Back to top |
|
|
kgumraj
Active User
Joined: 01 May 2006
Posts: 151
Location: Hyderabad
|
|
|
|
You are right
Since the query is not looking for the attributes, it is not neccesary |
|
| Back to top |
|
|
|
|
