DB2 PRIMARY Key Update in COBOL code

raj_mainframe08 · New User Joined: 11 Sep 2007 Posts: 65 Location: Gurgaon

Is it possible to update DB2 Primary Key field in DB2 Cobol code with a unique value?

dick scherrer · Posted: Mon Aug 20, 2012 11:41 pm

Hello,

If i understand your question, NO - the primary key cannot be updated. This has nothing to do with COBOL.

Searching in the db2 part of the forum might have lead you to this previous topic:
ibmmainframes.com/viewtopic.php?t=11822&highlight=change+primary+key

Please ignore this post - it is NOT correct
d

raj_mainframe08 · New User Joined: 11 Sep 2007 Posts: 65 Location: Gurgaon

Thanks Dick. I also have the same feeling untill i read below page. So thought of confirming.

www.allinterview.com/showanswers/83989.html

Craq Giegerich · Posted: Tue Aug 21, 2012 1:03 am

Primary keys can be changed, the new value must unique and be careful of foreign key constrains.

dick scherrer · Posted: Tue Aug 21, 2012 1:04 am

Ooops - looks like my bad . . .

d

Jaggu.r · New User Joined: 07 Aug 2012 Posts: 2 Location: India

Yes. We can do that.

We can DROP and ALTER primary key of a DB2 Table.

Try to create a cobol program with static sql with ALTER table query to do this but there is a constraint in using this. You need excess authorization for this.

dick scherrer · Posted: Tue Aug 21, 2012 7:54 pm

Hello and welcome to the forum,

Please re-read the topic. Your reply does not address the question asked.

It is best to ensure the question is understood before posting a reply.