Testing if QDESIGN completed OK.
Boyle, Joe
Joe.Boyle@cognos.com
Mon, 11 Mar 2002 09:51:27 -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_01C1C8E2.501F09A0
Content-Type: text/plain;
charset="iso-8859-1"
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.
------_=_NextPart_001_01C1C8E2.501F09A0
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 5.00.2314.1000" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=015144809-11032002>Hi
Robert,</SPAN></FONT></DIV>
<DIV><SPAN class=015144809-11032002></SPAN> </DIV>
<DIV><FONT color=#0000ff face=Arial 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 color=#0000ff face=Arial size=2>Problem Description</FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2>Is there a technique to check if
there were errors returned during a QUIZ run?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2>Solution Description</FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#0000ff face=Arial 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 color=#0000ff face=Arial size=2>Example:</FONT></DIV>
<DIV><FONT color=#0000ff face=Arial 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 color=#0000ff face=Arial size=2>CREATE DICTIONARY TSTJCW NOT
PRELOADED</FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2>ELEMENT ELEMENT1 CHARACTER SIZE
2</FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2>FILE JCWTST ORGANIZATION
INDEXED</FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2>RECORD JCWTST</FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2>ITEM ELEMENT1 </FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2>INDEX IDXJCW UNIQUE</FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2>SEGMENT ELEMENT1</FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2>LOAD</FONT></DIV></BLOCKQUOTE>
<DIV> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2>The quiz report looks like the
following:</FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV><FONT color=#0000ff face=Arial size=2>access jcwtst</FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2>DEFINE T_TEMP1 NUM*2 =
NCONVERT("*")</FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2>rep all</FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2>go</FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2>1998/07/07 JCWPHD PAGE
1</FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2>Element1 T_TEMP1</FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2>10 0</FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2>?</FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2>Records selected: 1</FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2>Lines printed: 3</FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2>Pages printed: 1</FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2>** Data conversion errors:
1</FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2>> </FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2>> e</FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2>END OF
PROGRAM</FONT></DIV></BLOCKQUOTE>
<DIV> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2>SY3>showjcw</FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV><FONT color=#0000ff face=Arial size=2>CIERROR = 0</FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2>JCW = WARN3</FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2>SECURITYANSWER = 0</FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2>CJCW = 3</FONT><FONT
color=#0000ff face=Arial size=2>QUIZ =
0</FONT></FONT><BR></DIV></BLOCKQUOTE></BLOCKQUOTE>
<BLOCKQUOTE>
<DIV align=left class=OutlookMessageHeader dir=ltr><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 color=#000080 face=Wingdings
size=2>vvvvvvvvvvvvvvvvvvvvvvvvvvvvv</FONT></P>
<P align=center><FONT color=#800080 face="Comic Sans MS" size=2>Robert
W.Mills, Systems Development Manager, Windsong Services</FONT></P>
<P align=center><FONT color=#800080 face="Comic Sans MS" size=2>Electron
House, Cray Avenue, St. Mary Cray, Kent BR5 3PN, ENGLAND</FONT></P>
<P align=center><FONT color=#800080 face="Comic Sans MS" size=2>Tel: +44
(0)1689.870622 x 3005 Fax: +44 (0)1689 899026</FONT></P>
<P align=center><FONT color=#0000ff face=Arial
size=2>robert.mills@windsong-services.co.uk</FONT></P>
<P align=center><FONT color=#000080 face=Wingdings
size=2>ssssssssssssssssssssssssssssssss</FONT></P>
<P align=center><I><FONT color=#000080 face="Comic Sans MS" size=2>The
thoughts, comments, and opinions expressed herein are mine.</FONT></I></P>
<P align=center><I><FONT color=#000080 face="Comic Sans MS" size=2>They do not
reflect those of my employer, nor anyone else.</FONT></I></P>
<P align=center><FONT color=#000080 face=Wingdings
size=2>ssssssssssssssssssssssssssssssss</FONT></P>
<P align=center><FONT color=#800080 face="Comic Sans MS"
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></BODY></HTML>
<BR>
<P><FONT SIZE=2 FACE="Arial">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>
------_=_NextPart_001_01C1C8E2.501F09A0--