[U2] FCB being used in TRANS is not getting cleared.

2009-11-04 Thread George Gallen
I have a subroutine that dynamically creates a Q pointer in the VOC to a file in another account, then it uses TRANS to read an item from the newly created VOC entry. It seems that sometimes, the even though the VOC entry's contents change (aka a new filename) TRANS keep trying to read from the

Re: [U2] FCB being used in TRANS is not getting cleared.

2009-11-04 Thread Martin Phillips
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

Re: [U2] FCB being used in TRANS is not getting cleared.

2009-11-04 Thread George Gallen
-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

Re: [U2] FCB being used in TRANS is not getting cleared.

2009-11-04 Thread John Hester
-Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, November 04, 2009 2:04 PM To: U2 Users List Subject: Re: [U2] FCB being used in TRANS is not getting cleared. this is in a subroutine. So one pass