Composite primary key
Moderators: chulett, rschirm, roy
Composite primary key
Hi,
Can a column in a composite primary key be a null? we have a primary key with combination of 2 key columns.In those 2 key columns , can anyone be null?
Database is DB29.Does it accept? Any ideas.
Thanks
Can a column in a composite primary key be a null? we have a primary key with combination of 2 key columns.In those 2 key columns , can anyone be null?
Database is DB29.Does it accept? Any ideas.
Thanks
Via
-------------------------------------
Learn all the way, as you Grow each Second
-------------------------------------
Learn all the way, as you Grow each Second
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No.
(having some transmission difficulties here - moderator, please remove)
(having some transmission difficulties here - moderator, please remove)
Last edited by ray.wurlod on Mon Apr 02, 2007 9:23 am, edited 1 time in total.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
All primary key columns in DB2 tables must be NOT NULL.
Re-design the target table. Or use a dedicated default value.
What does it really mean that you want to make part of a key unknown? Ponder on that for a while.
Re-design the target table. Or use a dedicated default value.
What does it really mean that you want to make part of a key unknown? Ponder on that for a while.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: