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

What is copy pending status in db2?

1067

---

What r the comman abends in db2, jcl and cobol???????

2195

---

Explain about rct.

1024

---

How does cobol compile db2 program?

1003

---

What is ibm db2 used for?

1001

---

How many types of page locks can be held in db2?

991

---

What is the max length of sqlca?

1156

---

How do you concatenate the firstname and lastname from emp table to give a complete name?

1009

---

How to access db2 tables in mainframe?

990

---

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1040

---

Why do we need reorg in db2?

918

---

What types of tables are there in the db2 database?

1002

---

How and when does the db2 enforces the unique key?

1028

---

What are host variables in db2?

989

---

What is load utility in db2?

1125

---