Strange Quiz data conversion error

[Deskin, Bob]

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.