R:Query/400

zuccoa

Active Member
Ryan,

how do your users run the queries ? Do they have a command line and use
the WRKQRY command ?

We also use queries very much but I didn't want to give users the command
line : because of this reason, I have to write every time a little CL that
runs the query, and to add a menu entry in one of the specific queries
menus that we've created.

It may sound a bit heavy (it is not), but this gives you much more security
and allows you to address many more aspects : inside the little CL you
could temporarily redefine the JOBQ ...

TUBILUX PHARMA SPA
IS Manager
A.Zucconi

------
 

scott_parker

Reputable Poster
We set up a Dream Writer type Program that is VERY handy for IBM Query
The Processing Options for "PRUNQRY" look like the following:

1. Enter the first query to be run. . . . . . . .INVENTORYTB
and the record select option . . . . . . . . .*YES

2. Enter the second query to be run. . . . . . . YRSONHNDTB
and the record select option . . . . . . . . .*YES

3. Enter the third query to be run. . . . . . . .YRSONHNDT2
and the record select option . . . . . . . . .*YES


This allows for multiple querys to be run at the same time.(up to 8)

The CL (JRUNQRY) of the program first does the Printer Overrides then.
This code.

IF COND(&PSOPT1 *NE ' ') THEN(DO)
RUNQRY QRY(&PSOPT1) RCDSLT(&PSOPT2)
ENDDO

All I.S. has to do is set up the "PRUNQRY" version and then call that from a menu.


If anyone is interested I can see about Posting the Code for the CL.


Scott Parker
Grote Industries, LLC.
WorldSoftware Version 8.1.2 AS/400 V4R5
 

ian_newman

Member
Yes please

Regards
Ian Newman
-
Project Manager
Omni Leisue Operations Limited




scott parker
<scott.parker@grot To: jdeworldml@jdelist.com
e.com> cc:
Sent by: Subject: Re: R:Query/400
owner-jdeworldml@j
delist.com


27/03/2001 03:57
AM
Please respond to
jdeworld






We set up a Dream Writer type Program that is VERY handy for IBM Query
The Processing Options for "PRUNQRY" look like the following:

1. Enter the first query to be run. . . . . . . .INVENTORYTB
and the record select option . . . . . . . . .*YES

2. Enter the second query to be run. . . . . . . YRSONHNDTB
and the record select option . . . . . . . . .*YES

3. Enter the third query to be run. . . . . . . .YRSONHNDT2
and the record select option . . . . . . . . .*YES


This allows for multiple querys to be run at the same time.(up to 8)

The CL (JRUNQRY) of the program first does the Printer Overrides then.
This code.

IF COND(&PSOPT1 *NE ' ') THEN(DO)
RUNQRY QRY(&PSOPT1) RCDSLT(&PSOPT2)
ENDDO

All I.S. has to do is set up the "PRUNQRY" version and then call that from
a menu.


If anyone is interested I can see about Posting the Code for the CL.


Scott Parker
Grote Industries, LLC.
WorldSoftware Version 8.1.2 AS/400 V4R5
----------------------
 

Spike

Active Member
TUBILUX,

We setup another environment that only allows access to query. When a user signs on, the query environment is just an additional environment listed. While in the environment, we change the users library list and authority and any other temporary changes. When the user leaves the environment, we restore things back to normal again. From this environment, users can create their own queries. Our users don't have access to command line.

We also setup queries to run off of JDE menus. We use two methods to do this. We either create a CL program to run the query, or we have created a generic CL that will accept two parameters from the menu. One is the Library the query is in (version) and the name of the query (option key). Each time you want to add a query to a menu, call the generic CL (job to execute) and pass in the query and library. No more changing or creating CL programs.

All these solutions, but I still don't have a way to change the job queues for these queries.

Ryan

Ryan Allen

OW Xe B7333 SP14.2
Enterprise Server - AS/400 V4R4
Deployment Server - Win2000
Fat - Win200
TSE/Citrix - Win2000
 

scott_parker

Reputable Poster
Attached (I hope the attach feature works) is a write up of how we are doing the IBM Query from a Dream Writer Front end.
Please let me know if anyone has any questions, comments or concerens.


Scott Parker
Grote Industries, LLC.
WorldSoftware Version 8.1.2 AS/400 V4R5<P ID="edit"><FONT SIZE=-1>Edited by scott parker on 3/29/01 07:23 AM.</FONT></P>
 

Attachments

  • 2-8256-JRUNQRY.TXT
    13.9 KB · Views: 268

Spike

Active Member
Re: RE: R:Query/400

Works great! Just click on the attachment link to the right.

Ryan Allen

OW Xe B7333 SP14.2
Enterprise Server - AS/400 V4R4
Deployment Server - Win2000
Fat - Win200
TSE/Citrix - Win2000
 

scott_parker

Reputable Poster
Actually,
If you click the link of my e-mail you will be taken to the "Forum" From
there you can click the word Attachment on my message and recieve the file.



Scott Parker
Grote Industries, LLC
mailto:scott.parker@grote.com





Scott Parker
Grote Industries, LLC.
WorldSoftware Version 8.1.2 AS/400 V4R5
 

ekempter

Administrator
Folks,

The attachment is on the forum (where Scott posted his message). Click
the link at the bottom of this message and scroll down until your find
scott's message. Click on attachment. We don't want to include attachments
with mailing list messages because of virus considerations and because
everyone isn't going to be interested in every attachment.



Place your system configuration information in your signature!
 
Top