F0005 - User Define Codes

Why is when I want to RUNQRY QRYFILE(F0005) it always gives an error msg "Quey cannot be run. See lower level messages" I tried press F1 on the msg but nothing happens.

Thanks advance for help..

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

That's a very detail and informative response. I truely appreciate your response. It will help me greatly. Honestly your response answered some of my unanswered questions.

Thank you so much.

Marsh

To add to Steve's options - you can also do the following in your current JDE environment:

RUNQRY QRYFILE((F0005LA))

Shazad.

I figure out what to do. I RUNQRY on its Logical. That is
RUNQRY QRYFILE(F0005LA). It worked fine

In addition to the other solutions, you can also submit your query to batch and it will run (WRKQRY, then option 8 to submit to batch).