469,658 Members | 1,862 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,658 developers. It's quick & easy.

No Keys on Federated tables

RdR
Hi,

I have a table in SQL Server with no keys, I point this as a federated table
in DB2 but in DB2 I have defined keys against this federated table in SQL.
Where will the key constraints be followed in DB2 or in SQL? How should a
select statement in DB2 for this federated table behave if there are
duplicates in SQL? The result I am getting is it is showing an actual
duplicate in DB2 for this federated table. Is there any setting in DB2 or
DB2 II to take into consideration federated key constraints?

Thanks,

JWK
Nov 12 '05 #1
1 1846
RdR wrote:
Hi,

I have a table in SQL Server with no keys, I point this as a federated table
in DB2 but in DB2 I have defined keys against this federated table in SQL.
Where will the key constraints be followed in DB2 or in SQL? How should a
select statement in DB2 for this federated table behave if there are
duplicates in SQL? The result I am getting is it is showing an actual
duplicate in DB2 for this federated table. Is there any setting in DB2 or
DB2 II to take into consideration federated key constraints?

Thanks,

JWK

Constraints on nicknames are informational constraints. They are just
there to tell the optimizer that certain things are supposed to be true.
These constraints are "never" enforced by DB2. An exception may be
with a check constraint when an insert or update is attempted.

--
Rob Wilson
ro********@ameritech.net.invalid (remove .invalid)
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Joerg Ammann | last post: by
3 posts views Thread by Terry | last post: by
reply views Thread by stevenkblack | last post: by
1 post views Thread by Terry | last post: by
4 posts views Thread by uthuras | last post: by
4 posts views Thread by esmith2112 | last post: by
2 posts views Thread by Damir | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.