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

Is it possible using max on a char column?

609


What is a Foreign Key?

656


How do I delete a table in database?

599


What is db2 purescale?

551


What is db2 optimizer?

771






What is dbrm? What it contains?

682


When reorg is used?

676


What is null indicator in db2?

604


What is db2 stogroup?

675


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

1806


What is the physical storage length of timestamp data type?

646


What is release/acquire in bind?

656


What is with ur in db2?

760


What is declare cursor?

613


How to check table size in db2 sap?

581