Testing if QDESIGN completed OK.
Robert Mills
robert.mills@windsong-services.co.uk
Mon, 11 Mar 2002 11:56:58 -0000
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C1C8F3.D8E8FB40
Content-Type: text/plain;
charset="iso-8859-1"
Hi Joe,
Prior to posting my question to the list I searched:
1) The 8.3 manuals -- NOTHING.
2) Cognos web site. Only found document id: 66573 (JCW Settings used by PH
on MPE/IX). This only mentions QUICK, QUIZ and QTP. Omits QDESIGN, PDL,
QUTIL and QSHOW.
Any other ideas?
regards,
Robert W.Mills
-----Original Message-----
From: Boyle, Joe [mailto:Joe.Boyle@cognos.com]
Sent: 11 March 2002 10:36
To: 'Robert Mills'
Subject: RE: Testing if QDESIGN completed OK.
apologies Robert,
did'nt pick up on the QDESIGN reference. Can only find what you already
know, see below; have you tried the Cognos web site ?
Problem Description
Calls qtp from quick.
When calling QTP from Quick, is there a way to stop processing if an error
is returned? That is, only continue if no error is displayed?
Solution Description
Try the following:
scr TEST
file skills
FIELD EMPLOYEE OF SKILLS REQUIRED NOCHANGE
FIELD SKILL OF SKILLS
proc des test
begin
run command 'qtp info="auto=testqts"'
if jcw("cjwc") ne 0
then error "there was an error"
if jcw("cjcw") = 0
then warning "please continue"
.....
end
build
From: Robert Mills [mailto:robert.mills@windsong-services.co.uk]
Sent: 11 March 2002 10:28
To: 'Boyle, Joe'; PowerHouse List (E-mail)
Subject: RE: Testing if QDESIGN completed OK.
Joe,
Was aware that JCW=WARN1 and CJCW=1 when an error occurs within QDESIGN.
Warnings in QDESIGN, created for example by a '*W* Field overwrites the
screen background' or a '*W* Cluster overwrites the screen background',
results in JCW=0 and CJCW=0.
regards,
Robert W.Mills
-----Original Message-----
From: Boyle, Joe [mailto:Joe.Boyle@cognos.com]
Sent: 11 March 2002 09:51
To: 'Robert Mills'; PowerHouse List (E-mail)
Subject: RE: Testing if QDESIGN completed OK.
Hi Robert,
found the doc below, hope this helps,
Problem Description
Is there a technique to check if there were errors returned during a QUIZ
run?
Solution Description
Check the jcw values or the cjcw values. There are 5 possible jcw settings
(with 5 corresponding cjcw values). The jcw values are WARN1, WARN2, WARN3
WARN4 and WARN5. The cjcw settings have the "WARN" portion removed and only
report the numeric, for example, if jcw is set to WARN1 then cjcw will be
set to 1.
Example:
Here is an example to demonstrate how to check the the jcw values. The
following pdl and quiz report will create a data conversion error. By
running this sample we are able to see how the jcw is set. It is important
to note that jcw and cjcw values are only set when the quiz session is over,
which means if this is a multi pass report and it is necessary to find out
if there was an error in a pass before commencing with another this must be
taken into consideration.
CREATE DICTIONARY TSTJCW NOT PRELOADED
ELEMENT ELEMENT1 CHARACTER SIZE 2
FILE JCWTST ORGANIZATION INDEXED
RECORD JCWTST
ITEM ELEMENT1
INDEX IDXJCW UNIQUE
SEGMENT ELEMENT1
LOAD
The quiz report looks like the following:
access jcwtst
DEFINE T_TEMP1 NUM*2 = NCONVERT("*")
rep all
go
1998/07/07 JCWPHD PAGE 1
Element1 T_TEMP1
10 0
?
Records selected: 1
Lines printed: 3
Pages printed: 1
** Data conversion errors: 1
>
> e
END OF PROGRAM
SY3>showjcw
CIERROR = 0
JCW = WARN3
SECURITYANSWER = 0
CJCW = 3QUIZ = 0
-----Original Message-----
From: Robert Mills [mailto:robert.mills@windsong-services.co.uk]
Sent: 08 March 2002 16:57
To: PowerHouse List (E-mail)
Subject: Testing if QDESIGN completed OK.
Hi all,
Environment: MPE/iX and PH8.39c
I know that the jcw CJCW is set to 1 (one) if Qdesign detects any errors.
Anybody know how I can test for warnings?
regards,
*****************************
Robert W.Mills, Systems Development Manager, Windsong Services
Electron House, Cray Avenue, St. Mary Cray, Kent BR5 3PN, ENGLAND
Tel: +44 (0)1689.870622 x 3005 Fax: +44 (0)1689 899026
robert.mills@windsong-services.co.uk
********************************
The thoughts, comments, and opinions expressed herein are mine.
They do not reflect those of my employer, nor anyone else.
********************************
***Confidentiality Notice: This e-mail message, including any attachments,
is for the sole use of the intended recipients and may contain confidential
and privileged information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the intended recipient, please
contact the sender by reply e-mail and destroy all copies of the original
message.
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.
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.
------_=_NextPart_001_01C1C8F3.D8E8FB40
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Testing if QDESIGN completed OK.</TITLE>
<META content="MSHTML 6.00.2600.0" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=203024011-11032002><FONT face="Comic Sans MS" color=#0000ff
size=2>Hi Joe,</FONT></SPAN></DIV>
<DIV><SPAN class=203024011-11032002><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=203024011-11032002><FONT face="Comic Sans MS" color=#0000ff
size=2>Prior to posting my question to the list I searched:</FONT></SPAN></DIV>
<DIV><SPAN class=203024011-11032002><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=203024011-11032002><FONT face="Comic Sans MS" color=#0000ff
size=2>1) The 8.3 manuals -- NOTHING.</FONT></SPAN></DIV>
<DIV><SPAN class=203024011-11032002><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=203024011-11032002><FONT face="Comic Sans MS" color=#0000ff
size=2>2) Cognos web site. Only found document id: 66573 (JCW Settings used
by PH on MPE/IX). This only mentions QUICK, QUIZ and QTP. Omits QDESIGN, PDL,
QUTIL and QSHOW.</FONT></SPAN></DIV>
<DIV><SPAN class=203024011-11032002><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=203024011-11032002><FONT face="Comic Sans MS" color=#0000ff
size=2>Any other ideas?</FONT></SPAN></DIV>
<DIV><SPAN class=203024011-11032002><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=203024011-11032002><FONT face="Comic Sans MS" color=#0000ff
size=2>regards,</FONT></SPAN></DIV>
<DIV><SPAN class=203024011-11032002><FONT face="Comic Sans MS" color=#0000ff
size=2>Robert W.Mills</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Boyle, Joe
[mailto:Joe.Boyle@cognos.com]<BR><B>Sent:</B> 11 March 2002
10:36<BR><B>To:</B> 'Robert Mills'<BR><B>Subject:</B> RE: Testing if QDESIGN
completed OK.<BR><BR></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=379433310-11032002>apologies Robert,</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=379433310-11032002></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=379433310-11032002>did'nt pick up on the QDESIGN reference. Can only
find what you already know, see below; have you tried the Cognos web
site ?</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=379433310-11032002></SPAN></FONT> </DIV>
<DIV><FONT size=2><SPAN class=379433310-11032002><FONT size=1> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Problem Description </FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV><FONT face=Arial color=#0000ff size=2>Calls qtp from
quick.</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>When calling QTP from Quick, is
there a way to stop processing if an error is returned? That is, only
continue if no error is displayed? </FONT></DIV></BLOCKQUOTE>
<DIV> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Solution Description </FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV><FONT face=Arial color=#0000ff size=2>Try the following: </FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>scr TEST</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>file skills</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>FIELD EMPLOYEE OF SKILLS REQUIRED
NOCHANGE</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>FIELD SKILL OF
SKILLS</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>proc des test</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>begin</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>run command 'qtp
info="auto=testqts"'</FONT></DIV>
<DIV></FONT><FONT face=Arial color=#0000ff>if jcw(</FONT><FONT size=1><FONT
color=#0000ff><FONT face=Arial><FONT size=2><SPAN
class=379433310-11032002>"cjwc</SPAN>") ne 0</FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>then error "there was an
error"</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>if jcw("cjcw") = 0</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>then warning "please
continue"</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>.....</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>end</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>build</FONT></DIV></BLOCKQUOTE>
<P> </P></FONT></SPAN></FONT>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2><BR><B>From:</B> Robert Mills
[mailto:robert.mills@windsong-services.co.uk]<BR><B>Sent:</B> 11 March 2002
10:28<BR><B>To:</B> 'Boyle, Joe'; PowerHouse List
(E-mail)<BR><B>Subject:</B> RE: Testing if QDESIGN completed
OK.<BR><BR></DIV></FONT>
<DIV><FONT face="Comic Sans MS" color=#0000ff size=2><SPAN
class=468242210-11032002>Joe,</SPAN></FONT></DIV>
<DIV><FONT face="Comic Sans MS" color=#0000ff size=2><SPAN
class=468242210-11032002></SPAN></FONT> </DIV>
<DIV><FONT face="Comic Sans MS" color=#0000ff size=2><SPAN
class=468242210-11032002>Was aware that JCW=WARN1 and CJCW=1 when an error
occurs within QDESIGN. Warnings in QDESIGN, created for example by a
'*W* Field overwrites the screen background' or a '*W* Cluster overwrites
the screen background', results in JCW=0 and CJCW=0.</SPAN></FONT></DIV>
<DIV><FONT face="Comic Sans MS" color=#0000ff size=2><SPAN
class=468242210-11032002><FONT face=Arial
size=2></FONT></SPAN></FONT> </DIV>
<DIV><FONT face="Comic Sans MS" color=#0000ff size=2><SPAN
class=468242210-11032002><FONT face=Arial size=2>regards,</FONT> <BR><FONT
face=Arial size=2>Robert W.Mills</FONT> </DIV></SPAN></FONT>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Boyle, Joe
[mailto:Joe.Boyle@cognos.com]<BR><B>Sent:</B> 11 March 2002
09:51<BR><B>To:</B> 'Robert Mills'; PowerHouse List
(E-mail)<BR><B>Subject:</B> RE: Testing if QDESIGN completed
OK.<BR><BR></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=015144809-11032002>Hi Robert,</SPAN></FONT></DIV>
<DIV><SPAN class=015144809-11032002></SPAN> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=015144809-11032002>found the doc below, hope this
helps,</SPAN></FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Problem
Description</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Is there a technique to check
if there were errors returned during a QUIZ run?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Solution
Description</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Check the jcw values or the
cjcw values. There are 5 possible jcw settings (with 5 corresponding
cjcw values). The jcw values are WARN1, WARN2, WARN3 WARN4 and WARN5.
The cjcw settings have the "WARN" portion removed and only report the
numeric, for example, if jcw is set to WARN1 then cjcw will be set to 1.
</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=1><FONT face=Arial color=#0000ff
size=2>Example:</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Here is an example to
demonstrate how to check the the jcw values. The following pdl and quiz
report will create a data conversion error. By running this sample we
are able to see how the jcw is set. It is important to note that jcw and
cjcw values are only set when the quiz session is over, which means if
this is a multi pass report and it is necessary to find out if there was
an error in a pass before commencing with another this must be taken
into consideration.</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV><FONT face=Arial color=#0000ff size=2>CREATE DICTIONARY TSTJCW
NOT PRELOADED</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>ELEMENT ELEMENT1 CHARACTER
SIZE 2</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>FILE JCWTST ORGANIZATION
INDEXED</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>RECORD JCWTST</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>ITEM ELEMENT1 </FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>INDEX IDXJCW
UNIQUE</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>SEGMENT
ELEMENT1</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff
size=2>LOAD</FONT></DIV></BLOCKQUOTE>
<DIV> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>The quiz report looks like
the following:</FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV><FONT face=Arial color=#0000ff size=2>access jcwtst</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>DEFINE T_TEMP1 NUM*2 =
NCONVERT("*")</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>rep all</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>go</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>1998/07/07 JCWPHD PAGE
1</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Element1
T_TEMP1</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>10 0</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>?</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Records selected:
1</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Lines printed:
3</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Pages printed:
1</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>** Data conversion errors:
1</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>> </FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>> e</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>END OF
PROGRAM</FONT></DIV></BLOCKQUOTE>
<DIV> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>SY3>showjcw</FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV><FONT face=Arial color=#0000ff size=2>CIERROR = 0</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>JCW = WARN3</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>SECURITYANSWER =
0</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>CJCW = 3</FONT><FONT
face=Arial color=#0000ff size=2>QUIZ =
0</FONT></FONT><BR></DIV></BLOCKQUOTE></BLOCKQUOTE>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Robert Mills
[mailto:robert.mills@windsong-services.co.uk]<BR><B>Sent:</B> 08 March
2002 16:57<BR><B>To:</B> PowerHouse List (E-mail)<BR><B>Subject:</B>
Testing if QDESIGN completed OK.<BR><BR></DIV></FONT>
<P><FONT face="Comic Sans MS" size=2>Hi all,</FONT> </P>
<P><FONT face="Comic Sans MS" size=2>Environment: MPE/iX and
PH8.39c</FONT> </P>
<P><FONT face="Comic Sans MS" size=2>I know that the jcw CJCW is set to
1 (one) if Qdesign detects any errors. Anybody know how I can test for
warnings?</FONT> </P>
<P><FONT face="Comic Sans MS" size=2>regards,</FONT>
<P align=center><FONT face=Wingdings color=#000080
size=2>vvvvvvvvvvvvvvvvvvvvvvvvvvvvv</FONT></P>
<P align=center><FONT face="Comic Sans MS" color=#800080 size=2>Robert
W.Mills, Systems Development Manager, Windsong Services</FONT></P>
<P align=center><FONT face="Comic Sans MS" color=#800080 size=2>Electron
House, Cray Avenue, St. Mary Cray, Kent BR5 3PN, ENGLAND</FONT></P>
<P align=center><FONT face="Comic Sans MS" color=#800080 size=2>Tel: +44
(0)1689.870622 x 3005 Fax: +44 (0)1689 899026</FONT></P>
<P align=center><FONT face=Arial color=#0000ff
size=2>robert.mills@windsong-services.co.uk</FONT></P>
<P align=center><FONT face=Wingdings color=#000080
size=2>ssssssssssssssssssssssssssssssss</FONT></P>
<P align=center><I><FONT face="Comic Sans MS" color=#000080 size=2>The
thoughts, comments, and opinions expressed herein are
mine.</FONT></I></P>
<P align=center><I><FONT face="Comic Sans MS" color=#000080 size=2>They
do not reflect those of my employer, nor anyone else.</FONT></I></P>
<P align=center><FONT face=Wingdings color=#000080
size=2>ssssssssssssssssssssssssssssssss</FONT></P>
<P align=center><FONT face="Comic Sans MS" color=#800080
size=1>***Confidentiality Notice: This e-mail message, including any
attachments, is for the sole use of the intended recipients and may
contain confidential and privileged information. Any unauthorized
review, use, disclosure or distribution is prohibited. If you are not
the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original
message.</FONT></P><BR><BR></BLOCKQUOTE><BR>
<P><FONT face=Arial size=2>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.</FONT></P></BLOCKQUOTE></BLOCKQUOTE><BR>
<P><FONT face=Arial size=2>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.</FONT></P></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C1C8F3.D8E8FB40--