powerh-l digest, Vol 1 #951 - 8 msgs
Greig Morrison
greig.morrison@sympatico.ca
Thu, 3 Jun 2004 08:13:09 -0400
Hi all,
I am unclear on what the use PUSH UPDATE or PUSH UPDATE STAY is trying
to accomplish here. The only table modified in 88 by Quick is MBX-SB-C
and the PUT takes care of it.
I am guessing by the cryptic file name MBX-SB-C, that it is possibly an
ALIAS. Could you provide the FILE statements for the screen to give us a
clearer picture?
What ACTIVITIES are available in the screen? Is it only used for Inquiry
or can data on the screen be changed requiring an update prior to
running the QTP/QUIZ processes in Designer 88? If files other than
MBX-SB-C are modified then they will require PUT verbs as well, since
the PUSH UPDATE and PUSH UPDATE STAY will occur too late.
If data changed by the QTPs in 88 is required in 89 then you need to
re-retrieve the screen data, hopefully using a GET verb you will be able
to do this.
-----Original Message-----
Message: 2
From: "terry terry" <ggjos@hotmail.com>
To: powerh-l@lists.sowder.com
Subject: RE: executing two designer programs sequentially
Date: Wed, 02 Jun 2004 14:48:40 +0000
Hi Bob,
This is the actual source code:
PROCEDURE DESIGNER 88 ;created 2004/05 to automate dates /procedure 89
created in 2002
BEGIN
IF VERIFY-STATUS="V" AND VERIFY-ID NE ""
THEN ERROR "CLAIM IS ALREADY VERIFIED/NO DATA MAY BE CHANGED"
ELSE
BEGIN
LET EMPLOYEE-NIN OF MBX-SB-C = EMPLOYEE-NIN OF BEN-SB
LET DATE-OF-APPLICATION OF MBX-SB-C = DATE-OF-APPLICATION OF
BEN-SB
LET DATE-OF-SICKNESS OF MBX-SB-C = DATE-OF-SICKNESS OF BEN-SB
LET BENEFIT-YEAR OF MBX-SB-C = BENEFIT-YEAR OF BEN-SB
LET BENEFIT-MONTH OF MBX-SB-C = BENEFIT-MONTH OF BEN-SB
LET BENEFIT-TYPE OF MBX-SB-C = BENEFIT-TYPE OF BEN-SB
LET NUM-DAYS OF MBX-SB-C = DAYS-SICK OF BEN-SB
PUT MBX-SB-C
PUSH UPDATE
RUN COMMAND "QTP AUTO=CUST-SB-HOL-TABLE-START.QTC" CLEAR SCREEN
RUN COMMAND "QUIZ AUTO=CUST-SB-CALC-DAYS1.QZC" CLEAR SCREEN
RUN COMMAND "QUIZ AUTO=CUST-SB-CALC-DAYS2.QZC" CLEAR SCREEN
RUN COMMAND "QTP AUTO=CUST-SB-CALC-DAYS-UPDATE.QTC" CLEAR SCREEN
RUN COMMAND "QTP AUTO=CUST-SB-HOL-TABLE-END.QTC" CLEAR SCREEN
PUSH UPDATE STAY
END
END
PROCEDURE DESIGNER 89 ;created in 2002/12 REQUIRES DATE-BENEFIT-STARTED
FROM
88 TO PROCESS
BEGIN
IF VERIFY-STATUS="V" AND VERIFY-ID NE ""
THEN ERROR "CLAIM IS ALREADY VERIFIED/NO DATA MAY BE CHANGED"
ELSE
BEGIN
LET EMPLOYEE-NIN OF BEN-SBMBX = EMPLOYEE-NIN OF BEN-SB
LET DATE-BENEFIT-STARTED OF BEN-SBMBX = DATE-BENEFIT-STARTED OF
BEN-SB
LET DATE-OF-APPLICATION OF BEN-SBMBX = DATE-OF-APPLICATION OF
BEN-SB
PUT BEN-SBMBX
RUN COMMAND "QUIZ AUTO=BEN-SB-CONT-UPDATE-2-DEC2002.QZS NOLIST"
CLEAR
SCREEN
;this quiz contains about 15 programs including qtps
and
quizs
END
END
_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8.
http://join.msn.com/?page=features/junkmail
--__--__--
Message: 3
Subject: RE: executing two designer programs sequentially
Date: Wed, 2 Jun 2004 11:11:37 -0400
From: "Deskin, Bob" <Bob.Deskin@Cognos.COM>
To: "terry terry" <ggjos@hotmail.com>, <powerh-l@lists.sowder.com>
Okay. There are a number of issues here. First of all, you have both
PUSH UPDATE and PUSH UPDATE STAY in 88. The result of this will be that
AFTER the execution of 88 completes, QUICK will do an Update (U),
followed by an Update Stay (US). Depending on the context QUICK is in
(data or action) after the Update, you may get an error or unexpected
results, possibly not even noticeable.
Next, if you need to do a complete update before doing the QUIZ and QTP
processes in 88, then break those out into a separate named designer
procedure (named DOIT for example) and have PUSH UPDATE STAY, DESIGNER
DOIT at the end of 88 as in:
PROCEDURE DESIGNER 88
BEGIN
...
PUSH UPDATE STAY, DESIGNER DOIT
END
PROCEDURE DESIGNER DOIT NODATA
BEGIN
<< QUIZ and QTP runs from 88 >>
END
And last, the question still remains exactly how the execution of 89
relates to 88. Once 88 is complete, I gather the user can run 89. Do
they have to do a find first? Is there data on the screen? The comments
say that a date is needed from 88. I gather that the Update in 88
updates the file that provides the date in 89. If that's the case, the
problem is probably the PUSH UPDATE. This would be confirmed if the user
must do a find before running 89. If that is the case, then removing the
PUSH UPDATE should solve the problem.
Bob Deskin
Product Manager, Application Development Tools
Cognos Inc. 3755 Riverside Drive, Ottawa ON K1G 4K9 CANADA
bob.deskin@cognos.com (613) 738-1338 ext 7268
-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of terry terry
Sent: June 2, 2004 10:49 AM
To: powerh-l@lists.sowder.com
Subject: RE: executing two designer programs sequentially
Hi Bob,
This is the actual source code:
PROCEDURE DESIGNER 88 ;created 2004/05 to automate dates /procedure 89
created in 2002
BEGIN
IF VERIFY-STATUS="V" AND VERIFY-ID NE ""
THEN ERROR "CLAIM IS ALREADY VERIFIED/NO DATA MAY BE CHANGED"
ELSE
BEGIN
LET EMPLOYEE-NIN OF MBX-SB-C = EMPLOYEE-NIN OF BEN-SB
LET DATE-OF-APPLICATION OF MBX-SB-C = DATE-OF-APPLICATION OF
BEN-SB
LET DATE-OF-SICKNESS OF MBX-SB-C = DATE-OF-SICKNESS OF BEN-SB
LET BENEFIT-YEAR OF MBX-SB-C = BENEFIT-YEAR OF BEN-SB
LET BENEFIT-MONTH OF MBX-SB-C = BENEFIT-MONTH OF BEN-SB
LET BENEFIT-TYPE OF MBX-SB-C = BENEFIT-TYPE OF BEN-SB
LET NUM-DAYS OF MBX-SB-C = DAYS-SICK OF BEN-SB
PUT MBX-SB-C
PUSH UPDATE
RUN COMMAND "QTP AUTO=CUST-SB-HOL-TABLE-START.QTC" CLEAR SCREEN
RUN COMMAND "QUIZ AUTO=CUST-SB-CALC-DAYS1.QZC" CLEAR SCREEN
RUN COMMAND "QUIZ AUTO=CUST-SB-CALC-DAYS2.QZC" CLEAR SCREEN
RUN COMMAND "QTP AUTO=CUST-SB-CALC-DAYS-UPDATE.QTC" CLEAR SCREEN
RUN COMMAND "QTP AUTO=CUST-SB-HOL-TABLE-END.QTC" CLEAR SCREEN
PUSH UPDATE STAY
END
END
PROCEDURE DESIGNER 89 ;created in 2002/12 REQUIRES DATE-BENEFIT-STARTED
FROM
88 TO PROCESS
BEGIN
IF VERIFY-STATUS="V" AND VERIFY-ID NE ""
THEN ERROR "CLAIM IS ALREADY VERIFIED/NO DATA MAY BE CHANGED"
ELSE
BEGIN
LET EMPLOYEE-NIN OF BEN-SBMBX = EMPLOYEE-NIN OF BEN-SB
LET DATE-BENEFIT-STARTED OF BEN-SBMBX = DATE-BENEFIT-STARTED OF
BEN-SB
LET DATE-OF-APPLICATION OF BEN-SBMBX = DATE-OF-APPLICATION OF
BEN-SB
PUT BEN-SBMBX
RUN COMMAND "QUIZ AUTO=BEN-SB-CONT-UPDATE-2-DEC2002.QZS NOLIST"
CLEAR
SCREEN
;this quiz contains about 15 programs including qtps
and
quizs
END
END
_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8.
http://join.msn.com/?page=features/junkmail
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
This message may contain privileged and/or confidential
information. If you have received this e-mail in error or are not the
intended recipient, you may not use, copy, disseminate or distribute it;
do not open any attachments, delete it immediately from your system and
notify the sender promptly by e-mail that you have done so. Thank you.
--__--__--
Message: 4
From: "terry terry" <ggjos@hotmail.com>
To: powerh-l@lists.sowder.com
Subject: RE: executing two designer programs sequentially
Date: Wed, 02 Jun 2004 16:12:20 +0000
Hi bob,
First of all , how this works is that the 88 procedure is run
then
the screen is cleared and the data is recalled .Secondly the 89
procedure is
then run and the screen is manually updated as in
"U" and return.When done this way every thing works well.I decided to
arrange things in such a way that the 2 procedures would run
sequentially ,
instead of 88 recall data ,then 89, I wanted
one action to execute both procedures and save the user needless
actions.
Thats when I began having problems.88 generates date-benefit-started
which
is needed for 89 to calculate the numbers of days for the claim.As I
said,
if the procedures are run separately they work well as long as the
screen is
cleared after 88, and the data is retrieved and 89 is then run.But 89
wont
run without retrieving the data on screen after 88 is run . I tried
using a
quiz in front of 89 to report on the screen what data was missing when
the
88 procedure is run and the date-benefit-started is
left
out which is needed for 89. I used your example but the 88 commands keep
running last after the 89. That is when I type "88/89" in the action
field
of the screen to have both procedures run sequentially ie 88 then 89.I
switched the order in the DOIT push procedure and 88 still runs last
after
89.
>Okay. There are a number of issues here. First of all, you have both
PUSH
>UPDATE and PUSH UPDATE STAY in 88. The result of this will be that
AFTER
>the execution of 88 completes, QUICK will do an Update (U), followed by
an
>Update Stay (US). Depending on the context QUICK is in (data or action)
>after the Update, you may get an error or unexpected results, possibly
not
>even noticeable.
>
End of powerh-l Digest