The PRIMARY KEY cannot be null. you can insert ZERO into that but should

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?

Question Posted / satya prasad n

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

Please Help Members By Posting Answers For Below Questions

How do I change the column size in db2?

1205

When the like statement is used?

1273

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

1230

Explain the function of data manager.

1093

Which isolation level provides maximum concurrency?

1203

What is catalog database in db2?

1212

What is difference between isnull and coalesce?

1100

What is coalesce in db2?

1178

How is the value function used?

1202

What are db2 tables?

1159

What is database alias db2?

1175

How to run db2 command in windows?

1236

How to test SQL -911 error while developing COB-DB2 program

7661

What is null indicator in db2?

1160

Where can you declare a cursor in a cobol-db2 program?

1136