Re: [U2] FCB being used in TRANS is not getting cleared.
I've had the same problem in the past when modifying a VOC entry, but it wasn't in conjunction with using TRANS. I have a utility that allows restoration of archived spooler files from various directories, and I had it create a VOC "F" entry in order to list the contents of the selected directory with the UV LIST command. When I initially wrote the utility, I found that only the first directory selected could ever be listed even after rewriting the path in attr. 2 of the VOC entry. The only way to select another was to drop to TCL and execute the utility again. My solution was to set attr. 2 of the VOC entry to point to a symbolic link whos path and name never change. I execute "rm" and "ln -s" at the OS level to repoint the link to the correct directory from within the UV program. That eliminated the need to drop back to TCL each time a new directory was selected. -John -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 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] FCB being used in TRANS is not getting cleared.
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
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] FCB being used in TRANS is not getting cleared.
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 previous filename that it read from. If I replace the TRANS with an OPEN / READ from the same VOC entry, the correct file gets read from each time a new VOC entry is changed. Anyone experienced this? UV 10.0.2 on linux George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users