| IBM MAINFRAME HELP & SUPPORT FORUMS
Technical Forums for IBM Mainframe Applications like COBOL, JCL, CICS, DB2, FileAid, DFSORT, Endevor, Xpediter, CoolGen, CA-7&11, AbendAid, IMS, IDMS, PL/I, MqSeries, SyncSort, Assembler, ChangeMan, Easytrieve, InterTest, REXX, CLIST etc...
|
| View previous topic :: View next topic |
| Author |
Message |
satyender
Joined: 05 Jan 2008
Posts: 40
Location: hyderabad
|
| Posted: Thu Aug 21, 2008 3:22 am Post subject: Will alter index adding a column effect the application |
|
|
Hi all,
If I alter index adding a column,would it effect the application programs.
Do they need to be recompiled again.
Please suggest me.
** If my question is not appropriate pls excuse me ** |
|
| Back to top |
|
dick scherrer
Joined: 23 Nov 2006
Posts: 8733
Location: 221 B Baker St
|
| Posted: Thu Aug 21, 2008 3:30 am Post subject: |
|
|
Hello,
It will help if you post what you "had" and how it was changed - both the data column(s) and the index definition(s). |
|
| Back to top |
|
dbzTHEdinosauer
Joined: 20 Oct 2006
Posts: 1639
Location: germany
|
| Posted: Thu Aug 21, 2008 9:49 am Post subject: |
|
|
If you are only adding a column to the index, I would suggest rebinding inorder to take advantage of the 'new' index.
The DBRM will not have changed - unless you change the SQL, so no need to reprecompile and recompile. |
|
| Back to top |
|
| |
THIS IS AN ARCIVE FORUM IN READ ONLY MODE. IF YOU WANT TO ASK YOUR DOUBTS USE THE ACTUAL FORUM
|
