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_01C1B624.D590D080
Content-Type: text/plain
To stop the error appearing, you could try coding the define as follows:
DEFINE DI-AMT INT*10 = NCONVERT(DC-AMOUNT) &
IF DC-REC080[1:1] <> "$" AND DC-REC080[1:1] <> "W" &
AND DC-REC080[1:1] <> "\" AND DC-REC080[1:1] = "&" &
ELSE 0
Regards,
Mark Fry
Cognos Limited
email: Mark.Fry@Cognos.com
Cognos Limited
Registered in England, number 1635598. Registered office: Westerly Point,
Market Street, Bracknell, Berkshire, RG12 1QB
-----Original Message-----
From: Deskin, Bob [mailto:Bob.Deskin@cognos.com]
Sent: 15 February 2002 13:22
To: powerh-l@lists.swau.edu
Subject: RE: Strange Quiz data conversion error
I wonder what's in bytes 30-39 of the header and trailer records.
The way QUIZ works is that all DEFINEs are evaluated before the records are
selected. Why? Because the defined item might be used in the selection. Yes,
I know that the DEFINEs are coded after the selection, but QUIZ isn't that
picky. Of course, since you select out the records where the DEFINEs are
meaningless, you never see those results mixed in. However, you can still
get a data conversion error.
Bob Deskin
PowerHouse Web Product Manager, Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA
-----Original Message-----
From: Mike Palandri [mailto:palandri@eug4ja.lane.edu]
Sent: Friday, February 15, 2002 8:07 AM
To: powerh-l@lists.swau.edu
Subject: Strange Quiz data conversion error
Powerhouse 7.10F3 OpenVMS Alpha
I have subfile whose records conatain a single 80 byte char element,
DC-REC080. There are 3 header records, 2 trailer records, and 305
detail records. The detail records contain a right justified integer
in bytes 30-39 that needs to be totaled.
I have a select statement that correctly selects the 305 details, and
defined items to extract the integer. (This is done with two defines
because I need the character item DC-AMOUNT for another purpose.)
ACCESS *GLST426
SELECT IF DC-REC080[1:1] <> "$" AND DC-REC080[1:1] <> "W" &
AND DC-REC080[1:1] <> "\" AND DC-REC080[1:1] = "&"
DEF DC-AMOUNT CHAR*10 = DC-REC080[30:10]
DEF DI-AMT INT*10 = NCONVERT(DC-AMOUNT)
The problem is that the DI-AMT define always results in a single data
conversion error. It doesn't matter if I set the report limit to 1, 100
or NOLIMIT, ther is always one error. However, when I report both items,
DI-AMT is always converted correctly.
The SELECT *is* selecting the correct records, as only 305 are processed,
and
I've examined them all.
Here's what's odd: I used the same SELECT to create a second subfile that
contains only the 305 detail records. The code runs fine against that
file. Somehow the presence of the header and trailer records in the
original
subfile is causing the data conversion error, despite them being selected
out.
I can't use a second subfile in production, and even though the data
conversion error doesn't seem to harm anything, I'd like to eliminate it.
Any ideas?
Thanks,
Mike
.
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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_01C1B624.D590D080
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
RE: Strange Quiz data conversion error
To stop the error appearing, you could try coding the =
define as follows:
DEFINE =
DI-AMT =
INT*10 =3D NCONVERT(DC-AMOUNT) &
IF DC-REC080[1:1] <> "$" AND =
DC-REC080[1:1] <> =
"W" &
AND DC-REC080[1:1] <> =
"\" AND DC-REC080[1:1] =3D =
"&" &
ELSE 0
Regards,
Mark Fry
Cognos Limited
email: Mark.Fry@Cognos.com
Cognos Limited
Registered in England, number 1635598. =
Registered office: Westerly Point, Market Street, Bracknell, =
Berkshire, RG12 1QB
-----Original Message-----
From: Deskin, Bob [mailto:Bob.Deskin@cognos.com]<=
/FONT>
Sent: 15 February 2002 13:22
To: powerh-l@lists.swau.edu
Subject: RE: Strange Quiz data conversion =
error
I wonder what's in bytes 30-39 of the header and =
trailer records.
The way QUIZ works is that all DEFINEs are evaluated =
before the records are
selected. Why? Because the defined item might be =
used in the selection. Yes,
I know that the DEFINEs are coded after the =
selection, but QUIZ isn't that
picky. Of course, since you select out the records =
where the DEFINEs are
meaningless, you never see those results mixed in. =
However, you can still
get a data conversion error.
Bob =
Deskin =
PowerHouse Web Product Manager, Application =
Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: =
(613) 727-1178
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON =
K1G 4K9 CANADA
-----Original Message-----
From: Mike Palandri [mailto:palandri@eug4ja.lane.edu=
]
Sent: Friday, February 15, 2002 8:07 AM
To: powerh-l@lists.swau.edu
Subject: Strange Quiz data conversion error
Powerhouse 7.10F3 OpenVMS Alpha
I have subfile whose records conatain a single 80 =
byte char element,
DC-REC080. There are 3 header records, 2 =
trailer records, and 305
detail records. The detail records contain a right =
justified integer
in bytes 30-39 that needs to be totaled.
I have a select statement that correctly selects the =
305 details, and
defined items to extract the integer. (This is =
done with two defines
because I need the character item DC-AMOUNT for =
another purpose.)
ACCESS *GLST426
SELECT IF DC-REC080[1:1] <> "$" AND =
DC-REC080[1:1] <> "W" &
AND DC-REC080[1:1] <> =
"\" AND DC-REC080[1:1] =3D "&"
DEF =
DC-AMOUNT &nb=
sp; CHAR*10 =3D DC-REC080[30:10]
DEF =
DI-AMT =
INT*10 =3D NCONVERT(DC-AMOUNT)
The problem is that the DI-AMT define always results =
in a single data
conversion error. It doesn't matter if I set =
the report limit to 1, 100
or NOLIMIT, ther is always one error. However, =
when I report both items,
DI-AMT is always converted correctly.
The SELECT *is* selecting the correct records, as =
only 305 are processed,
and
I've examined them all.
Here's what's odd: I used the same SELECT to create a =
second subfile that
contains only the 305 detail records. The code =
runs fine against that
file. Somehow the presence of the header and =
trailer records in the
original
subfile is causing the data conversion error, =
despite them being selected
out.
I can't use a second subfile in production, and even =
though the data
conversion error doesn't seem to harm anything, I'd =
like to eliminate it.
Any ideas?
Thanks,
Mike
.
=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
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.
=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
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 imm=
ediately from your system and notify the sender promptly by e-mail that =
you have done so. Thank you.
------_=_NextPart_001_01C1B624.D590D080--