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_01C1BF8C.36E15BF0
Content-Type: text/plain;
charset="iso-8859-1"
Hi Harold,
which version of PH are you using ?
there is an old bug logged against 7.10.C, details, including work around,
below,
Problem Description:
Define an RDB field as an element in the dictionary with a
negative output scale will result in the following error...
*W* Data access error. (relationname)
%RDB-E-ARITH_EXCEPT, truncation of a numeric value at runtime
%SYSTEM-F-INTOVF, arithmetic trap, integer overflow at PC=004A2C25, PSL
There is a workaround in the bug details as below,
Remove the negative output scale from PHD and
put negative OUTPUT SCALE when using item in source.
Not very acceptable because clients will have to modify all
source using item instead of enterring once in PHD.
Alternative work arounds suggested by Paul S:
Declare data type as SIGNED LONGWORD in the database
and recompile applications. This is big enough
to hold the returned scaled up value.
OR Leave the type as SIGNED WORD in the database, but
declare it with a SCALE of -4. Thus the meta data
would better reflect the displayed unit type.
If this is done, the OUTPUT SCALE need not
be specified in PDL.
regards,
Joe Boyle.
-----Original Message-----
From: Johnson, Harold A EDUC:EX
[mailto:Harold.A.Johnson@gems1.gov.bc.ca]
Sent: 26 February 2002 23:50
To: PowerHouse List (E-mail)
Subject: Error in QSHOW
Hi Experts. I get the following error when trying to do a "show record" in
QSHOW. We have a number of tables and views (> 400) in an RDB database. If
I do this command on an individual table, its OK. But when I try to do a
"show record.. anything" which returns more than one table, this error pops
up.
*E* Relational Database access failed.
%RDB-E-ARITH_EXCEPT, truncation of a numeric value at runtime
%COSI-F-INTOVF, integer overflow
Any idea how I can find the table/view that is causing the problem without
having to examine every single table/view individually? I don't get any
errors when doing the same thing with SQL. e.g. "show table", "show view".
thnx
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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_01C1BF8C.36E15BF0
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
RE: Error in QSHOW
Hi Harold,
which version of PH are you using ?
there is an old bug logged against 7.10.C, details, including work around, below,
Problem Description:
Define an RDB field as an element in the dictionary with a
negative output scale will result in the following error...
*W* Data access error. (relationname)
%RDB-E-ARITH_EXCEPT, truncation of a numeric value at runtime
%SYSTEM-F-INTOVF, arithmetic trap, integer overflow at PC=004A2C25, PSL
There is a workaround in the bug details as below,
Remove the negative output scale from PHD and
put negative OUTPUT SCALE when using item in source.
Not very acceptable because clients will have to modify all
source using item instead of enterring once in PHD.
Alternative work arounds suggested by Paul S:
Declare data type as SIGNED LONGWORD in the database
and recompile applications. This is big enough
to hold the returned scaled up value.
OR Leave the type as SIGNED WORD in the database, but
declare it with a SCALE of -4. Thus the meta data
would better reflect the displayed unit type.
If this is done, the OUTPUT SCALE need not
be specified in PDL.
regards,
Joe Boyle.
-----Original Message-----
From: Johnson, Harold A EDUC:EX
[mailto:Harold.A.Johnson@gems1.gov.bc.ca]
Sent: 26 February 2002 23:50
To: PowerHouse List (E-mail)
Subject: Error in QSHOW
Hi Experts. I get the following error when trying to do a "show record" in
QSHOW. We have a number of tables and views (> 400) in an RDB database. If
I do this command on an individual table, its OK. But when I try to do a
"show record.. anything" which returns more than one table, this error pops
up.
*E* Relational Database access failed.
%RDB-E-ARITH_EXCEPT, truncation of a numeric value at runtime
%COSI-F-INTOVF, integer overflow
Any idea how I can find the table/view that is causing the problem without
having to examine every single table/view individually? I don't get any
errors when doing the same thing with SQL. e.g. "show table", "show view".
thnx
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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_01C1BF8C.36E15BF0--