Can you please clarify what kind of error code/sqlcode will be returned i

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

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

Please Help Members By Posting Answers For Below Questions

Define predicate?

1199

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

7663

What are bind parameters in db2?

1093

What does db2 stand for?

1088

What db2 400?

1249

What is copy pending and check pending in db2?

1038

What does reorg do in db2?

1073

What is null value in db2?

1074

How can record locking be achieved in those DB2 versions which do not support it?

1122

What is buffer pool and list some of them?

1090

How to find the maximum value in a column in the db2 database?

1125

Which component is used to execute the sql statements?

1141

What is the role of union all and union

1185

Why select is not preferred in embedded sql programs?

1345

What is check constraint. Explain with example.

1156