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

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

7479


If I have a view which is a join of two or more tables, can this view be updateable?

688


What is an instance in db2?

561


What is the syntax for seeing the columns and data types of a table in the db2 database?

574


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

2683






What does reorg do in db2?

572


What is a trigger in the db2 database?

590


How do I copy a table in db2?

571


How to check last update on table in db2?

624


What is role in db2?

612


What is the difference between using bind () and rebind () methods of naming class?

782


What is a db2 table?

593


Why db2 is called db2?

587


How many types of page locks can be held in db2?

585


What is the difference between drop table and delete table?

543