F0005, F9200, and F9220 are pre-opened in the J98INITV program with:
OVRDBF FILE(FXXXX) SHARE(*YES)
OPNDBF FILE(FXXXX) OPTION(*ALL)
(where XXXX represents the respective file numbers).
Because of the SHARE(*YES) override, you cannot perform a RUNQRY against any
of these files. This is a RUNQRY limitation. This is also true of any
files that you have defined to be pre-opened using the "Pre-Open Files
Setup" (option 14 on menu G944).
One way to be able to use RUNQRY against these files is to signon to the
AS/400 to a command line OUTSIDE the JDE environment. In this way, the
files are not overriden and pre-opened, and you can freely run the RUNQRY
command against the pre-opened files, as long as you know the name of
library containing the file.
In a JDE multi-environment setup, where each environment each has its own
copy of F0005, you can always perform RUNQRY against F0005 in any
environment EXCEPT the one that you have currently selected.
Other alternatives:
1) STRSQL does NOT have the same limitation as RUNQRY. If you have
interactive SQL, you can start the SQL interpreter using STRSQL, then type
the SQL statement:
Select * from F0005 where DRSY = 'XXXX' and DRRT = 'YY'
(where 'XXXX' is the System Code and 'YY' is the Record Type) to view the
data in F0005 file.
2) Query Management queries can also be run against the pre-open files, if
you know how to create them (read about CRTQMQRY and STRQMQRY).
3) DSPPFM can also be used, although it is not as useful as any of the query
options.
Hope this helps,
Steve Landess
Austin, Texas
(512) 423-0935
Steve Landess
V4R4 A7.3 cume9
EDI
(512) 423-0935