Numeric Null values in Quiz -
Fry, Mark
Mark.Fry@COGNOS.com
Wed, 18 Dec 2002 08:47:49 -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_01C2A672.24BF3AF0
Content-Type: text/plain;
charset="iso-8859-1"
Hi Leslie,
Check in the dictionary that your database definition has the 'null values
allowed' clause too.
eg
database test type oracle &
open 'ORACLE' &
owner scott userid 'scott' password 'tiger' &
null values allowed
Best regards,
Mark Fry
Mark.Fry@Cognos.com
-----Original Message-----
From: Ole Hansen [mailto:oh@scanconsult.dk]
Sent: 18 December 2002 07:39
To: powerh-l@lists.swau.edu; Leslie Tsukamoto
Subject: Sv: Numeric Null values in Quiz -
Hi Leslie,
Have you tried using 'IF itemname IS NULL', e.g. in QUIZ or QTP :
DEFINE USCITIZEN CHAR*12 = "UNDETERMINED" if us_indicator IS NULL &
ELSE "NO" if us_indicator = 0 &
ELSE "YES" if us_indicator = 1 &
ELSE "ERROR"
HTH.
Mange hilsner / With kind regards
Ole Hansen
===========================================================
E-mail: oh@scanconsult.dk Cell Phone: +45 4040 1150
===========================================================
ScanConsult IT-Partners ApS Voice : +45 8738 7474
Jegstrupvej 96A Fax : +45 8738 7475
DK-8361 Hasselager Support : support@scanconsult.dk
Denmark Sales : sales@scanconsult.dk
http://www.scanconsult.dk
= ParaSuite : A Suite of Air Cargo Handling solutions =
= ParaSafe : A Suite of IT-Security solutions =
= Partners : Hewlett-Packard, Cognos, Microsoft and more =
-----Original Message-----
From: Leslie Tsukamoto <leslie.tsukamoto@cae.com>
To: powerh-l@lists.swau.edu <powerh-l@lists.swau.edu>
Date: Wednesday, December 18, 2002 5:55 AM
Subject: Numeric Null values in Quiz -
>We are running an older version of Quiz (7.33.d3) on an Hp9000 and
accessing
>an Oracle 7.3.4 database. Recently we added a few new columns onto an
>existing table. These columns are indicators that allow us to track if a
>customer is a us-citizen or not. When the new columns were added, each
>existing record then had a null value in that column - it was decided to
>test in our application that if the column was null when the the record was
>being updated - we would force the user to update that field as well and to
>set it to either (no = 0) or (yes = 1). This has worked fine from a front
>end application perspective - however, in trying to report within quiz a
>listing of all customers and a value of Yes, No, or ? for the
'us-indicator'
>field, we found that pretty much everyone was showing up on our report as
No
>- upon further investigation - it appears that Quiz is (on it's own)
>apparently determining if we have a numeric field and the value is null -
>quiz assumes it to be 0 - we are unable to successfully test against a null
>value on that field even though we can with sqlplus and other applications.
>
>
>Can someone tell me - is there something that we can do to have quiz
>recognize these column values as Nulls so that we can determine which
>records have been updated to a true NO value and which ones haven't been
>updated at all ? We have been forced to code this particular report in
>sqlplus which deviates from the normal deployment of reporting.
>
>I am not sure if there is a dictionary setting that we can utilize or not -
>any ideas?
>
>Sincerely, Leslie
>
>Leslie J. Tsukamoto
>Manager of Programming, CAE SimuFlite
>ph: 407-445-0226
>fax: 407-295-9493
>email: leslie.tsukamoto@cae.com
>
>
>
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/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.
------_=_NextPart_001_01C2A672.24BF3AF0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2654.89">
<TITLE>RE: Numeric Null values in Quiz - </TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Hi Leslie,</FONT>
</P>
<P><FONT SIZE=3D2>Check in the dictionary that your database definition =
has the 'null values allowed' clause too.</FONT>
</P>
<P><FONT SIZE=3D2>eg</FONT>
</P>
<P><FONT SIZE=3D2>database test type oracle &</FONT>
<BR><FONT SIZE=3D2> open 'ORACLE' &</FONT>
<BR><FONT SIZE=3D2> owner scott userid 'scott' password =
'tiger' &</FONT>
<BR><FONT SIZE=3D2> null values allowed</FONT>
</P>
<P><FONT SIZE=3D2>Best regards,</FONT>
</P>
<P><FONT SIZE=3D2>Mark Fry</FONT>
<BR><FONT SIZE=3D2>Mark.Fry@Cognos.com</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Ole Hansen [<A =
HREF=3D"mailto:oh@scanconsult.dk">mailto:oh@scanconsult.dk</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: 18 December 2002 07:39</FONT>
<BR><FONT SIZE=3D2>To: powerh-l@lists.swau.edu; Leslie Tsukamoto</FONT>
<BR><FONT SIZE=3D2>Subject: Sv: Numeric Null values in Quiz - </FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Hi Leslie,</FONT>
</P>
<P><FONT SIZE=3D2>Have you tried using 'IF itemname IS NULL', e.g. in =
QUIZ or QTP :</FONT>
</P>
<P><FONT SIZE=3D2>DEFINE USCITIZEN CHAR*12 =3D "UNDETERMINED" =
if us_indicator IS NULL &</FONT>
<BR><FONT =
SIZE=3D2> &nb=
sp; ELSE =
"NO" if us_indicator =3D =
0  =
; &</FONT>
<BR><FONT =
SIZE=3D2> &nb=
sp; ELSE =
"YES" if us_indicator =3D =
1  =
; &</FONT>
<BR><FONT =
SIZE=3D2> &nb=
sp; ELSE =
"ERROR"</FONT>
</P>
<P><FONT SIZE=3D2>HTH.</FONT>
</P>
<P><FONT SIZE=3D2>Mange hilsner / With kind regards</FONT>
</P>
<P><FONT SIZE=3D2>Ole Hansen</FONT>
</P>
<P><FONT =
SIZE=3D2>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</FONT>
<BR><FONT SIZE=3D2>E-mail: =
oh@scanconsult.dk Cell =
Phone: +45 4040 1150</FONT>
<BR><FONT =
SIZE=3D2>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</FONT>
<BR><FONT SIZE=3D2>ScanConsult IT-Partners =
ApS Voice : =
+45 8738 7474</FONT>
<BR><FONT SIZE=3D2>Jegstrupvej =
96A &nb=
sp; =
Fax : +45 8738 7475</FONT>
<BR><FONT SIZE=3D2>DK-8361 =
Hasselager Support : =
support@scanconsult.dk</FONT>
<BR><FONT =
SIZE=3D2>Denmark &n=
bsp; =
Sales : sales@scanconsult.dk</FONT>
<BR><FONT =
SIZE=3D2> &nb=
sp; <A HREF=3D"http://www.scanconsult.dk" =
TARGET=3D"_blank">http://www.scanconsult.dk</A> &=
nbsp; =
</FONT>
<BR><FONT SIZE=3D2>=3D ParaSuite : A Suite of Air Cargo Handling =
solutions =3D</FONT>
<BR><FONT SIZE=3D2>=3D ParaSafe : A Suite of IT-Security =
solutions =
=3D</FONT>
<BR><FONT SIZE=3D2>=3D Partners : Hewlett-Packard, Cognos, =
Microsoft and more =3D</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Leslie Tsukamoto =
<leslie.tsukamoto@cae.com></FONT>
<BR><FONT SIZE=3D2>To: powerh-l@lists.swau.edu =
<powerh-l@lists.swau.edu></FONT>
<BR><FONT SIZE=3D2>Date: Wednesday, December 18, 2002 5:55 AM</FONT>
<BR><FONT SIZE=3D2>Subject: Numeric Null values in Quiz - </FONT>
</P>
<BR>
<P><FONT SIZE=3D2>>We are running an older version of Quiz (7.33.d3) =
on an Hp9000 and accessing</FONT>
<BR><FONT SIZE=3D2>>an Oracle 7.3.4 database. Recently we =
added a few new columns onto an</FONT>
<BR><FONT SIZE=3D2>>existing table. These columns are =
indicators that allow us to track if a</FONT>
<BR><FONT SIZE=3D2>>customer is a us-citizen or not. When the =
new columns were added, each</FONT>
<BR><FONT SIZE=3D2>>existing record then had a null value in that =
column - it was decided to</FONT>
<BR><FONT SIZE=3D2>>test in our application that if the column was =
null when the the record was</FONT>
<BR><FONT SIZE=3D2>>being updated - we would force the user to =
update that field as well and to</FONT>
<BR><FONT SIZE=3D2>>set it to either (no =3D 0) or (yes =3D =
1). This has worked fine from a front</FONT>
<BR><FONT SIZE=3D2>>end application perspective - however, in trying =
to report within quiz a</FONT>
<BR><FONT SIZE=3D2>>listing of all customers and a value of Yes, No, =
or ? for the 'us-indicator'</FONT>
<BR><FONT SIZE=3D2>>field, we found that pretty much everyone was =
showing up on our report as No</FONT>
<BR><FONT SIZE=3D2>>- upon further investigation - it appears that =
Quiz is (on it's own)</FONT>
<BR><FONT SIZE=3D2>>apparently determining if we have a numeric =
field and the value is null -</FONT>
<BR><FONT SIZE=3D2>>quiz assumes it to be 0 - we are unable to =
successfully test against a null</FONT>
<BR><FONT SIZE=3D2>>value on that field even though we can with =
sqlplus and other applications.</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>> </FONT>
<BR><FONT SIZE=3D2>>Can someone tell me - is there something that we =
can do to have quiz</FONT>
<BR><FONT SIZE=3D2>>recognize these column values as Nulls so that =
we can determine which</FONT>
<BR><FONT SIZE=3D2>>records have been updated to a true NO value and =
which ones haven't been</FONT>
<BR><FONT SIZE=3D2>>updated at all ? We have been forced to =
code this particular report in</FONT>
<BR><FONT SIZE=3D2>>sqlplus which deviates from the normal =
deployment of reporting.</FONT>
<BR><FONT SIZE=3D2>> </FONT>
<BR><FONT SIZE=3D2>>I am not sure if there is a dictionary setting =
that we can utilize or not -</FONT>
<BR><FONT SIZE=3D2>>any ideas?</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>>Sincerely, Leslie </FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>>Leslie J. Tsukamoto </FONT>
<BR><FONT SIZE=3D2>>Manager of Programming, CAE SimuFlite </FONT>
<BR><FONT SIZE=3D2>>ph: 407-445-0226 </FONT>
<BR><FONT SIZE=3D2>>fax: 407-295-9493 </FONT>
<BR><FONT SIZE=3D2>>email: leslie.tsukamoto@cae.com </FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>> </FONT>
<BR><FONT SIZE=3D2>></FONT>
</P>
<P><FONT SIZE=3D2>=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D</FONT>
<BR><FONT SIZE=3D2>Mailing list: powerh-l@lists.swau.edu</FONT>
<BR><FONT SIZE=3D2>Subscribe: "subscribe" in message body to =
powerh-l-request@lists.swau.edu</FONT>
<BR><FONT SIZE=3D2>Unsubscribe: "unsubscribe" in message body =
to powerh-l-request@lists.swau.edu</FONT>
<BR><FONT SIZE=3D2><A =
HREF=3D"http://lists.swau.edu/mailman/listinfo/powerh-l" =
TARGET=3D"_blank">http://lists.swau.edu/mailman/listinfo/powerh-l</A></F=
ONT>
<BR><FONT SIZE=3D2>This list is closed, thus to post to the list you =
must be a subscriber.</FONT>
</P>
<P><FONT SIZE=3D2>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>
</BODY>
</HTML>
------_=_NextPart_001_01C2A672.24BF3AF0--