If a primary key column cannot be updated, what is the error code given w

Is it possible to update a primary key value? If not, what
is the error code given? If yes, can more than 1 primary
key column be updated at a time?

Question Posted / priya

Answer Posted / priya

If a primary key column cannot be updated, what is the
error code given when an attempt is made to update it
through a SQL query in a COBOL program?

Is This Answer Correct ?

3 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What is syscat in db2?

958

What are concurrency issues?

1041

What is view db2?

1019

What is the use of reorg in db2?

1030

What is alias in db2?

999

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1049

What is the role of data manager in the db2 database?

1060

What is the use of with ur in db2?

1009

How many databases are there?

1010

Can we update view in db2?

954

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1019

How to restart a DB2 program?

1834

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11630

What are the full forms of spufi and dclgen and why are they used?

1029

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1147