i am reading a config file and getting the exclusion list with space separator like
conv custreq payment etc.
i am using the below code to loop through each exclusion list.
do i = 1 to num-entries(tt-process.reason, " "):
v-reasonexc = entry(i,tt-process.reason, " ").
for each subscriptiontran no-lock
where trandate = 03/03/14
and trantype = "start"
and not reasoncode = v-reasonexc,
each subscription no-lock where
subscriptiontran.subscriptionid = subscription.subscriptionid
and subscription.productid = tt-process.product:
put stream sout unformatted subscriptiontran.subscriptionid ","
subscriptiontran.trandate ","
subscription.productid "," skip.
end.
i am not able to get required records excluding these particular reasoncodes.
Please help me to fix thsi.
conv custreq payment etc.
i am using the below code to loop through each exclusion list.
do i = 1 to num-entries(tt-process.reason, " "):
v-reasonexc = entry(i,tt-process.reason, " ").
for each subscriptiontran no-lock
where trandate = 03/03/14
and trantype = "start"
and not reasoncode = v-reasonexc,
each subscription no-lock where
subscriptiontran.subscriptionid = subscription.subscriptionid
and subscription.productid = tt-process.product:
put stream sout unformatted subscriptiontran.subscriptionid ","
subscriptiontran.trandate ","
subscription.productid "," skip.
end.
i am not able to get required records excluding these particular reasoncodes.
Please help me to fix thsi.