Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 6 Answers
- 22442 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to find schema of a table in db2?
How do you eliminate duplicate values in db2?
What is cursor with hold option in db2?
What are the bind parameters ibm db2?
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
Which component is responsible for db2 startup and shutdown?
How does a cursor work?
What is role in db2?
Explain about dbrm.
What is the difference between cursor stability and repeatable read isolation levels?
What is dbrm? What it contains? When it will be created?
Why cursor is used in db2?
On which levels locks can be applied?
Mention the definition of cobol in varchar field.
Is ibm db2 open source?
