Design of a table

[rAinDeEr]

Hi,

I want to design a Table with the following condition:

The table is used to store Department Information.
There are 3 types of Department- Dept A, Dept B and Dept C

The table structure is:

Dept Number
Dept Type
Dept Name

The problem is Dept A and Dept B has its own Dept Number but for Dept C
we have to generate a sequence.

So how do I store the dept number from Dept C as a sequence still
allowing Dept number from Dept A and Dept B which can vary.

I can always add another field but is there a way out...Just wanted to
know...

Thanks in Advance,
rAinDeEr

[Mark A]

"rAinDeEr" <ta**********@gmail.com> wrote in message
news:11**********************@j73g2000cwa.googlegr oups.com...

Hi,

I want to design a Table with the following condition:

The table is used to store Department Information.
There are 3 types of Department- Dept A, Dept B and Dept C

The table structure is:

Dept Number
Dept Type
Dept Name

The problem is Dept A and Dept B has its own Dept Number but for Dept C
we have to generate a sequence.

So how do I store the dept number from Dept C as a sequence still
allowing Dept number from Dept A and Dept B which can vary.

I can always add another field but is there a way out...Just wanted to
know...

Thanks in Advance,
rAinDeEr

You can use an identity column that is generated by default. If you don't
supply a value, then DB2 will generate one for you. However, you will need
to reserve a range of numbers to be automatically generated that will not
conflict with the ones you supply.

[rAinDeEr]

Thanks Mark for your prompt reply
rAinDeEr

[Brian Tkatch]

>So how do I store the dept number from Dept C as a sequence still

allowing Dept number from Dept A and Dept B which can vary.

Besides Mark's solution, you can also use two separate TABLEs, and pull
them together in a view.

B.