Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Need help to change primary key !!!

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
RamyaG

New User


Joined: 29 Sep 2004
Posts: 1

PostPosted: Wed Sep 29, 2004 12:16 pm    Post subject: Need help to change primary key !!!
Reply with quote

Hai ,


I need to change the primary key for an already existing DB2 table .
My doubt is if I change the primary key using the Alter table command , do the index for this new key will be generated or not ? . Now after the alteration how will the Select statements on this table work .. ?will it be using the new Key while selection.Please clarify on this .. Thanks in advance

Regards,
Ramya
Back to top
View user's profile Send private message

jz1b0c

Active User


Joined: 25 Jan 2004
Posts: 160
Location: Toronto, Canada

PostPosted: Sat Nov 13, 2004 2:21 am    Post subject:
Reply with quote

first step is to identify the list of programs where the impacted DB2 table
is used.

Second is to analyse what kind of DDL statements used in each of the
program and create a report of it.

If the new filed, is not going to be a part of Index, then Delete/Update
statements will not be affected.
Insert/Select will be impacted based on the usage of the filed

Take an image copy of the table.
Drop the table
Create a new table defination
Load the table from the previous image copy /* here the format differs
so you may use one time program to load this, otherwise you can chagne the syspunch and load*/

now you need to modify the impacted program.
Compile, link-edit and bind all the programs where the table is used.

let me know if you require any additional information.
_________________
Masade,

A Well defined problem is half solved.
Back to top
View user's profile Send private message
jz1b0c

Active User


Joined: 25 Jan 2004
Posts: 160
Location: Toronto, Canada

PostPosted: Sat Nov 13, 2004 2:21 am    Post subject:
Reply with quote

Yes you have to use the new key while making selection after the alter
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Cannot change DATACLAS on DFSMSdss re... Alan Playford JCL & VSAM 10 Tue May 01, 2018 6:43 pm
No new posts Repeat Sequence Number Until change i... rahulabvp DFSORT/ICETOOL 6 Thu Mar 29, 2018 12:51 pm
No new posts How to change the logon screen info o... sakthikumarT TSO/ISPF 4 Fri Dec 29, 2017 6:44 pm
No new posts Change NULL indicator in UNLOAD utility Khadhar Basha DB2 2 Fri Dec 15, 2017 3:01 pm
No new posts Extract record for change in combinat... Trinadh DFSORT/ICETOOL 6 Thu Nov 23, 2017 3:32 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us