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.