Constrain
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 20
- Joined: Mon Dec 05, 2005 8:07 pm
- Contact:
Constrain
Hi All,
i have a constrain in the transformer which allows only the values like "ABC" from a column.(e.x user_defined_routine(dslink.col1) ="ABC") no reject link is present. this was working fine. when i moved the job to test server i changed the input link name from "dslink" to "cd_input_link" and forgot to change it in the constrain.now the problem is that it is not showing error.it is compiling good witout any errors and running fine.but my table is getting updated with current datetimestamp for all the rows.which it is not suppose to happen it has to update only the records that have value of "ABC" from input col.am not able to understand how it is still working even though the link is not defined anywhere in the job. can u guys please throw some light on this and help me understand where it is going wrong..
Thanks
kris
i have a constrain in the transformer which allows only the values like "ABC" from a column.(e.x user_defined_routine(dslink.col1) ="ABC") no reject link is present. this was working fine. when i moved the job to test server i changed the input link name from "dslink" to "cd_input_link" and forgot to change it in the constrain.now the problem is that it is not showing error.it is compiling good witout any errors and running fine.but my table is getting updated with current datetimestamp for all the rows.which it is not suppose to happen it has to update only the records that have value of "ABC" from input col.am not able to understand how it is still working even though the link is not defined anywhere in the job. can u guys please throw some light on this and help me understand where it is going wrong..
Thanks
kris
KRIS
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Did the link name in the constraint expression get updated automatically? This does occur for output column derivations; I can not check right now whether it happens in constraint expressions.
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: 20
- Joined: Mon Dec 05, 2005 8:07 pm
- Contact:
No the link name in the constrain remained the same it did not change.. but still the job is able to compile and run...it still shows that there is an error when i click on the constrain and if i tell it to accept it accepts it and able to compile and run.chulett wrote:It should have been changed automatically and if it hadn't it wouldn't compile, so more than likely something else is going on. ...
kris
KRIS
-
- Participant
- Posts: 20
- Joined: Mon Dec 05, 2005 8:07 pm
- Contact:
7.5.2 i sent the data to a seq file with wrong constrain(link deleted) and other file with the correct constrain (updating with new changed link name) this is behaving correctly the other one is not, it is updating every row that it is reading from the input. can i assume that even though the datastage is saying that the link is not present and i made it to accept it, it is ignoring it (constrain).chulett wrote:Mine sure won't behave in that manner. What exact 7.x version do you have?...
KRIS
-
- Participant
- Posts: 20
- Joined: Mon Dec 05, 2005 8:07 pm
- Contact:
-
- Participant
- Posts: 20
- Joined: Mon Dec 05, 2005 8:07 pm
- Contact: