Sv: Calling quiz from quick passing parameters...
Ole Hansen, ScanConsult
oh@scanconsult.dk
Tue, 13 Mar 2001 17:44:10 +0100
Hi Chris,
We accomplish this with a little more code than any of the other suggestions, but using below method, we can make multi-pass reports and pass virtually any number of parameters (a.o. CHOOSE-params) to the report - or any pre-quiz qtp's. Admittedly, the coding is a little more tedious and we create an overhead by the repeated RUN COMMAND statements.
Here is an example for MPE (the UNIX-version is slightly different, but works along the same lines) :
procedure designer PRTList nodata
begin
run command "purge rrjo000m,temp" nowarn
run command "build rrjo000m;rec=-72,,f,ascii;disc=3;temp"
let jobline = compname ; PARAM NO. 1
put rrjo000m reset
let jobline = nextdest ; PARAM NO. 2
put rrjo000m reset
let jobline = city ; PARAM NO. 3
put rrjo000m reset
close rrjo000m
let cmdline = "file phprint;dev=" + devclass + "," + &
ascii(defprior) + "," ascii(copies) + ";cctl"
run command cmdline nowarn on error continue
inform = "Printing list - please wait...." now
run command 'quiz auto=rcda600q < rrjo000m > wastebin' &
on error terminate
end
RRJO000M is a MPE DIRECT file which has one item (JOBLINE CHAR*72) declared in the dictionary.
Statistics from quiz goes into the file 'wastebin', i.e the user just sees the 'Printing list - please wait....' at the message line.´, which is cleared when then screen refreshes after the designer procedure.
FWIW.
/Ole Hansen
====================================================================
E-mail: oh@scanconsult.dk Cell Phone: +45 40 40 11 50
====================================================================
ScanConsult IT-Partners ApS Voice : +45 87 38 74 74
Jegstrupvej 96A Fax : +45 87 38 74 75
DK-8361 Hasselager Support : support@scanconsult.dk
Denmark Sales : sales@scanconsult.dk
http://www.scanconsult.dk
=== ParaSuite : A Suite of Air Cargo Handling solutions ===
=== ScanConsult is Authorized by Hewlett-Packard as HP 3000 ===
=== Select Independent Software Vendor and HP9000 Power Partner ===
=== We partner with Oracle, Lotus, Cognos, MiniSoft and others ===
-----Oprindelig meddelelse-----
Fra: Edis, Bob <bob.edis@fleetpride.com>
Til: 'powerh-l@sphere.swau.edu' <powerh-l@sphere.swau.edu>
Dato: 13. marts 2001 16:47
Emne: RE: Calling quiz from quick passing parameters...
>G'day again Ron
>
>The scenario you pose below may be impossible depending on the nature of the
>data in the subfile and the name/s of the record item/s. For example, if
>the value was a date range the link would not work; It would have to be in a
>choose statement.
>
>Regards,
>Blue
>
>-----Original Message-----
>From: Ron Olenic [mailto:ROlenic@spectra-inc.com]
>Sent: Tuesday, March 13, 2001 8:00 AM
>To: 'Edis, Bob'
>Subject: RE: Calling quiz from quick passing parameters...
>
>
>Hi Bob!
>
>This email is one of those niggling little things that I needed to respond
>to before I could concentrate on my own work. A pox on you!!
>
>When you linked to record 0 of the subfile, I assume that you were still
>reading the entire record set of the primary file. If you had changed the
>linkage to
>
>access *subfile &
> link to filename
>
>It would at least reduce the number of records read from the primary file,
>and hopefully provide a better response than 45 minutes. However, I still
>agree with your original thought, that passing the system variables is more
>efficient for a choose or select value.
>
>Ron
>
>-----Original Message-----
>From: Edis, Bob [mailto:bob.edis@fleetpride.com]
>Sent: Monday, March 12, 2001 5:46 PM
>To: 'Ron Olenic'
>Subject: RE: Calling quiz from quick passing parameters...
>
>
>G'day Ron
>
>I think that there will be a lot more I/O with this method. At least on a
>HP/UX platform I have experienced poor performance when using the following
>syntax:
>
>ACCESS filename &
> LINK TO RECORD 1 OF *subfile
>
>I was able to reduce a report run time from 45 minutes to 5 minutes by
>replacing the subfile linkage with a CHOOSE SYSTEMVALUE statement instead.
>
>What has been your experience?
>
>Regards,
>Blue
>
>-----Original Message-----
>From: Ron Olenic [mailto:ROlenic@spectra-inc.com]
>Sent: Monday, March 12, 2001 4:34 PM
>To: 'powerh-l@sphere.swau.edu'
>Subject: RE: Calling quiz from quick passing parameters...
>
>
>Hi Chris!
>
>Here is another way, since you are running version 8, Quick can write to
>subfiles. Create a permanent subfile file in QUIZ, and then declare it as a
>file in your QUICK screen. Write your data to the subfile, and then access
>it in quiz.
>
>
>Ron Olenic
>
>-----Original Message-----
>From: Gassett, Chris [mailto:Gassett@aavid.com]
>Sent: Monday, March 12, 2001 5:19 PM
>To: 'powerh-l@sphere.swau.edu'
>Subject: Calling quiz from quick passing parameters...
>
>
>I want to be able to run a Quiz report from within a Quick screen, but I
>want to be able to pass data from that the screen has already accessed to
>the report to choose specific data. Is this possible and if so are there
>any samples out there? Thanks in advance.
>
>PROCEDURE DESIGNER FRM
>BEGIN
> RUN COMMAND "quiz auto=$HOMEQUIZ/test.qzs nolist nostatistics"
>END
>
>
>Powerhouse Ver. 8.13 d3
>= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
>Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
>This list is closed, thus to post to the list, you must be a subscriber.
>
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.