constraint confusing

[scottr]

Hi,
my previous developer uses the following constraits in the xfm which is confusing me ..pl help me to understand this .
the the following two links.none of them are rejected..

link constraint
fromfilter ('I'=toFilter.UPDT_TXN_TYPE_CD) or ('D'=toFilter.UPDT_TXN_TYPE_CD)

todelete ('D'=toFilter.UPDT_TXN_TYPE_CD)

thanks

[ray.wurlod]

No rows will be rejected if toFilter.UPDT_TXN_TYPE_CD is "D" for every row.

[Sainath.Srinivasan]

The 'fromfilter' is a superset of 'todelete'. Hence any row going to 'todelete' will be true in 'fromfilter'.

Can you tell us where the reject comes in picture?

[scottr]

the values of toFilter.UPDT_TXN_TYPE_CD are either I or D
as you said if the value of toFilter.UPDT_TXN_TYPE_CD = D then the rows has to go to the link todelete, but couple of rows with D are showed up at the next xfm(fromfilter link) and here his is deleting records from the table if the value is D

[ketfos]

Hi,

this is expected.
because fromfilter has filter condtion

'I'=toFilter.UPDT_TXN_TYPE_CD) or ('D'=toFilter.UPDT_TXN_TYPE_CD)


i.e value with D or I.

Ketfos

[scottr]

that's right but the second link "todelete" has 'D'=toFilter.UPDT_TXN_TYPE_CD. so does it means all rows with D should go to this link?

[chulett]

Yes. "I" or "D" goes down the first link, only "D" goes down the second. In other words, an "I" goes down the first link and a "D" goes down both.

Interesting they were written what would generally be considered to be 'backwards'... but either direction gets you the same results.

[Sainath.Srinivasan]

Did you check whether you have some column metadata has 'No' to 'Null Allowed' as this will make those records disappear from the link for failing this constraint.