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?

Answers were Sorted based on User's Feedback



Can a primary key have null values? If we try to insert a null value in a primary key column, will..

Answer / sangeetha

There cannot be null values in a Primary Key column.
It will result in error code.

Is This Answer Correct ?    26 Yes 3 No

Can a primary key have null values? If we try to insert a null value in a primary key column, will..

Answer / ratheesh nellikal

In DB2 you can not create a primary key on a column which
is not 'not null'.
If you are trying to create a primary key on a column which
is not 'not null' then dbb2 will return an error like this

SQL0542N "feild_name" cannot be a column of a primary key
or unique key because it can contain null values.
SQLSTATE=42831

But once u alter the table and set the column to 'NOT NULL'
then you can make it as primary key.

Now if u r trying to insert an null value to ur primary key
column then db2 will trows an error like

SQL0407N Assignment of a NULL value to a NOT NULL
column "TBSPACEID=5, TABLEID=404, COLNO=0" is not allowed.
SQLSTATE=23502.

In short you can not make a column which can hold 'NULL'
value as your primary key and you can not insert a 'NULL'
value into your primary key feild.

Cheers,
Ratheesh Nellikal

Is This Answer Correct ?    7 Yes 1 No

Can a primary key have null values? If we try to insert a null value in a primary key column, will..

Answer / satya prasad n

The PRIMARY KEY cannot be null. you can insert ZERO into
that but should not be null. It will throw an error if you
try to inserts a NULL.

Is This Answer Correct ?    8 Yes 4 No

Can a primary key have null values? If we try to insert a null value in a primary key column, will..

Answer / guest

A primary key can have a NULL value. The error will be
shown only when NOT NULL is defined in the table creation.

Is This Answer Correct ?    10 Yes 10 No

Can a primary key have null values? If we try to insert a null value in a primary key column, will..

Answer / sachin borase

May be it will throws the -803 error (803 means index
violation )

Is This Answer Correct ?    1 Yes 4 No

Can a primary key have null values? If we try to insert a null value in a primary key column, will..

Answer / 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

More DB2 Interview Questions

How to handle null values in db2

4 Answers  


what is different three logs in DB2?

1 Answers   Syntel,


4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.

3 Answers   Wipro,


Can a Db2 table data be retrived through JCL?

4 Answers  


How do I add a column in db2?

0 Answers  






Write a query to retrive partial string.

2 Answers  


If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

0 Answers  


What is cursor with hold option in db2?

0 Answers  


How to define the data items to receive the fetch items for the SQL?

2 Answers  


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

0 Answers  


When DB2 connection fails, will online program work or give errors.

1 Answers   Virtusa,


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

0 Answers  


Categories