Testing if QDESIGN completed OK.
Robert Mills
robert.mills@windsong-services.co.uk
Mon, 11 Mar 2002 10:27:40 -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_01C1C8E7.5F7D1CC0
Content-Type: text/plain;
charset="iso-8859-1"
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.
------_=_NextPart_001_01C1C8E7.5F7D1CC0
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><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></BODY></HTML>
------_=_NextPart_001_01C1C8E7.5F7D1CC0--