Constrainst in Transformer Stage Not Working

[nbdbzv4]

I have a transformer stage with five output links. The vqrious contstrainst coded do not give the expected results. I have tried deleloping them in notepad and copying and pasting them in the constrainst editor and also entering them directly into the constrainst editor. One of teh problem constrainst follows:

acctlvl = ' ' and srvtype <> 'S' and
caasrvnbr <>132 and
(srvstatus <> 'X' or 'W' or 'F') and
acctlvl_1 = ' ' and
(acctchg_1 <> 'A' or 'C')

Please help as I have tried for 3 days to get this to work..

Thanks

[senthilt1]

Hi Nbdbzv4.

Please try the below one, hope it will work,

acctlvl = ' ' and srvtype <> 'S' and
caasrvnbr <>132 and
(srvstatus <> 'X' or srvstatus<>'W' or srvstatus<>'F') and
acctlvl_1 = ' ' and
(acctchg_1 <> 'A' or acctchg_1<>'C')

Find the changes in Bold.

Thanks,

Senthil P

[keshav0307]

what is actually you are expecting in the output, give some example of input and expected output records

i think the logic you are trying is wrong
if srvstatus <> 'X' or 'W' or 'F' is wrong even (srvstatus <> 'X' or srvstatus<>'W' or srvstatus<>'F' ) is wrong

[chulett]

Right. You've got the corrected syntax now but as keshav0307 points out having multiple 'not equal' checks with 'or' makes no sense. They needs to be 'and', otherwise it will always return true.

[nbdbzv4]

Hi Everyone:

Thanks for taking the time to review my issue and offering suggestions and corrections. I did get it to work by using this format as was suggested:

acctlvl = ' ' and srvtype <> 'S' and
caasrvnbr <>132 and
(srvstatus <> 'X' and srvstatus<>'W' and srvstatus<>'F' ) and
acctlvl_1 = ' ' and
(acctchg_1 <> 'A' and acctchg_1<>'C' ) .

The other issue and confusion which I had was relying upon a verification script developed by the testing group.

Thanks

[nbdbzv4]

Hi Everyone:

Thanks for taking the time to review my issue and offering suggestions and corrections. I did get it to work by using this format as was suggested:

acctlvl = ' ' and srvtype <> 'S' and
caasrvnbr <>132 and
(srvstatus <> 'X' and srvstatus<>'W' and srvstatus<>'F' ) and
acctlvl_1 = ' ' and
(acctchg_1 <> 'A' and acctchg_1<>'C' ) .

The other issue and confusion which I had was relying upon a verification script developed by the testing group.

Thanks