Can a primary key have null values? If we try to insert a
null value in a primary key column, will it work or give an
error code?

Answer Posted / priya

Can you please clarify what kind of error code/sqlcode will
be returned if we try to insert a null value in a primary
key using a DB2 insert query?

Is This Answer Correct ?    2 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is dbrm?

857


What action db2 takes when a program aborts in the middle of a transaction?

877


How can deadlocks be resolved?

733


What is catalog database in db2?

863


What are the benefits of using the db2 database?

886


How can you do the explain of a dynamic sql statement?

825


What is isolation level in db2?

757


What is the use of runstats in db2?

799


What is the difference between db2 and oracle?

877


What is the use of value function?

842


What r the comman abends in db2, jcl and cobol???????

2021


Explain various types of locks in db2?

881


Explain db2.

812


What are packages in db2?

788


What is the meaning concurrency in the db2 database?

849