this is in a subroutine. So one pass into the subroutine, file1 gets setup as a Q pointer in the VOC, and read from, then the subroutine exits.
Then on the next pass into the subroutine (external subroutine), file2 gets setup a a Q pointer in the VOC, and read from, but trans tries to read from the previous file1. Even if I delete the VOC entry first, then re-write it with a new VOC entry. So...how do you clear the TRANS cache? I would think it would have been cleared when the subroutine ended. George > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Martin Phillips > Sent: Wednesday, November 04, 2009 4:45 PM > To: U2 Users List > Subject: Re: [U2] FCB being used in TRANS is not getting cleared. > > Hi George, > > This is almost certainly as a result of the "TRANS cache" inside the > query > processor. There is, I believe, an assumption that the data isn't > changing > during the query. > > > Martin Phillips > Ladybridge Systems Ltd > 17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB > +44-(0)1604-709200 > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users