Regarding MTK

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pankaj_wolfhunter@yahoo.co.in - 09 Dec 2005 05:18 GMT

Greetigs,
I just came to know that MTK does not migrate "RULES"
object from Sybase.
Is this true? if yes, whats the workaround?

Any help will be appreciated

TIA

Reply to this Message

Serge Rielau - 09 Dec 2005 06:53 GMT

> Greetigs,
> I just came to know that MTK does not migrate "RULES"
[quoted text clipped - 4 lines]
>
> TIA

What is a rule?

Signature

Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Reply to this Message

pankaj_wolfhunter@yahoo.co.in - 09 Dec 2005 06:58 GMT

Thank for the reply Serge.
A rule is an like CHECK CONSTRAINT. The difference is that rule can be
created as an object and hence can be associated with multiple tables.

Reply to this Message

Serge Rielau - 09 Dec 2005 09:01 GMT

> Thank for the reply Serge.
> A rule is an like CHECK CONSTRAINT. The difference is that rule can be
> created as an object and hence can be associated with multiple tables.

I see. How do you map column names?
From an MTK point of view, if it were supported (which I don't know)
I'd expect it to simply be mapped to regular check constraints...

Cheers
Serge

Signature

Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Reply to this Message

pankaj_wolfhunter@yahoo.co.in - 09 Dec 2005 11:42 GMT

Serge, i think we got manual workaround for this.
One thing, i really like to appreciate your activeness in this group.
Actually i want to thanks all the people involved giving ans to
people's queries.
Thanks again.

Reply to this Message

Knut Stolze - 09 Dec 2005 13:53 GMT

> A rule is an like CHECK CONSTRAINT. The difference is that rule can be
> created as an object and hence can be associated with multiple tables.

That sounds very much like "assertions" as the SQL standard specifies them.

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message