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
- 22643 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
Answer / sachin borase
May be it will throws the -803 error (803 means index
violation )
| Is This Answer Correct ? | 1 Yes | 4 No |
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 |
How does DB2 use multiple table indexes?
What is a view? Why use it?
Are views updateable?
What is cursor?
What is the advantage in De-normalizing tables in DB2?
if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)
In which column of which DB2 catalog would you find the length of the rows for all tables?
Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.
Which component is responsible for processing sql statements and selecting access paths?
When is the authorization check on DB2 objects done - at BIND time or run time?
What is a Foreign Key?
0 Answers Tavant Technologies, Zensar,
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
COBOL 
