Strange Results:
Pickering, John (NORBORD)
PICKERIJ@norbord.com
Thu, 12 Aug 1999 16:21:48 -0400
> Terry Pickering asks ...
>
<snip>
>Element: AMT-YTD-BUDGET
> Item Defaults: INTEGER-S Size 8
>ACCESS GLS-ACCOUNT-MSTR
>
> DEFINE T-BUDGET1 INT*8 = AMT-YTD-BUDGET
>
> REPORT &
> TAB 1 AMT-YTD-BUDGET PIC " ^^^,^^^,^^^" LEADING SIGN "-" BWZ OUT SCALE
> -2 &
> TAB 15 T-BUDGET1 PIC " ^^^,^^^,^^^" LEADING SIGN "-" BWZ OUT SCALE
>
> Amt Ytd T-BUDGET1
> Budget
>
> -30,980,000 11,969,673
>
>Notice how T-BUDGET-1 is reported incorrectly. It looks like a perfectly
>good number though and would be very hard to catch.
>
>Does anyone else think this is a "bug" and should be reported to Cognos?
Not me. Please note that int*8 is NOT the same as int size 8 !! Your defined
item t-budget1 is only 8 digits long (int*8) whereas your dictionary
definition for amt-ytd-budget is 8 bytes long (size 8). Quiz will dutifully
shove your 10 digit budget value into your 8 digit defined item but it will
usually report "data conversion errors" right after the "records selected,
lines & pages printed" statistics. If you do not get the data conversion
errors message then that might be a bug, but your problem as described above
is not a bug and should not be reported.
And glad to see you've dropped the "consultant extrodinaire" from your sig.
John Pickering (no relation)
Toronto
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.