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

How to get the ddl of a table in db2?

864

---

Explain db2.

813

---

What is check constraint. Explain with example.

850

---

What are concurrency issues?

810

---

How to create backup table in db2?

854

---

What are the uses of db2 optimizer?

1037

---

What is runstats db2?

774

---

Are view updateable?

819

---

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

810

---

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

7443

---

How can you quickly find out the # of rows updated after an update statement?

798

---

What are the prerogatives?

803

---

How do I add a column to an existing table in db2?

783

---

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2090

---

What is clone table?

792

---