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

How do I delete a column in db2?

888


What is table space in db2?

804


What is page size in db2?

755


Mention data types used in db2 ?

898


How can tablespace be moved to another dasd volume that is allocated for that tablespace?

994


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

853


Explain db2.

833


How do I connect my db2 database to ibm?

815


Explain various types of locks in db2?

909


What is a cursor in programming?

843


What is nvl in db2?

843


Explain about open switch business continuity software?

855


What is the use of reorg in db2?

840


What is db2 stogroup?

911


What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

976