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 cobol db2?

1004

---

Is db2 a mainframe?

1052

---

Define declaration generator (dclgen).

1123

---

What's The Error Code For Unique Index Voilation?

1244

---

What is db2 catalog database?

1050

---

What are foreign keys in db2?

1110

---

Explain how can you do the explain of a dynamic sql statement?

1130

---

What is runstats and reorg in db2?

1308

---

What are db2 objects?

1053

---

Differentiate between cs and rr isolation levels? Where do you specify them?

1074

---

How to run db2 command in windows?

1200

---

What is temporal table in db2?

1047

---

What db2 400?

1204

---

Which component is responsible for processing sql statements and selecting access paths?

1135

---

What are the various data types available in db2?

1100

---