Is it a QFILE? (AREV Specific)
At 22 JAN 2002 08:23:12PM S Shavdia wrote:
When I do LIST FILENAME for one of the window's source file it does not list any records. LISTDICT FILENAME for the same file comes up with all the field names and when the window is PERFORMED it does display all the data. How can I find out if the source file in window is actually a QFILE? It's not listed under QFILES neither do I see it in VOC. (using AREV 2.12)
Thanks.
At 22 JAN 2002 09:38PM Victor Engel wrote:
You can tell by the file handle. Since the handle varies by driver, I'll leave it at that, but you should be able to decrypt the handle in your situation pretty easily.
At 22 JAN 2002 09:48PM Victor Engel wrote:
If X is the name of the file, then the name of the actual file name, let's call this Y is xlate('FILES',X,2,'X'). If Y is not equal to X, then you are dealing with a qfile.
At 22 JAN 2002 10:49PM Warren wrote:
Just do a LIST FILES WITH F2 NE @ID F2
If your file is listed then it is a QFILE. The F2 column will show the name of the actual file.
At 23 JAN 2002 05:09AM Victor Engel wrote:
If your file is listed, it is a qfile. It is not necessarily true, though, that if it is a qfile it will be listed. It will not be listed if the name of the qfile matches the real name of the file.
At 23 JAN 2002 06:47PM Warren wrote:
Well if you want to be picky then:
LIST FILES with F2 NE @ID OR (WITH F3 NE 'GLOBAL' AND WITH F3 NE 'accountname') @CRT F2
Where accountname=the account logged in to (Determine from the WHO command) e.g. SYSPROG.