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
- 22632 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 do you find the maximum value in a column in db2?
What type of database is db2?
What is universal database?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is load utility in db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
Define db2 and its databases?
What's The Error Code For Unique Index Voilation?
Explain various types of locks in db2?
Is it possible using max on a char column?
What is db2 and what is the use of db2 optimizer?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
Explain how can you do the explain of a dynamic sql statement?
What are the 2 sqlcodes that are returned?
What is database reorganization?
