Irrational subfile behavior
Ohmes, Matt
Matt.Ohmes@COGNOS.com
Wed, 1 Sep 1999 17:04:51 -0400
Hi Al,
Hmmmm.. you don't show the code that created the subfile. Do you, by any
chance perform a summary operation against them, like SUBTOTAL? For
example:
Report &
TI-KEY &
TI-PLAN-ID &
TI-PART-ID &
TI-REC-CODE SUBTOTAL &
T-CB2-COUNT SUBTOTAL ...
If you do, then Quiz will usually write the results out as a floating point
number.
If you have QTP, define a temporary items as Zoned*2 and then COUNT or
SUBTOTAL into that to create the subfile.
Hope that helps!
Matt
Matt.Ohmes@Cognos.Com
Cognos Corporation
909 E. Las Colinas Blvd.
Suite 1900
Irving, TX 75039
214-259-6200
"Matt doesn't really know anything. He just likes to pontificate a lot.
We refuse to acknowledge that he works for Cognos or that we have ever
met him or anyone with whom he's ever been associated. Don't lend him
money and don't let him talk to your sister!" ;-)
-----Original Message-----
From: Al Karman [mailto:alkarman@hotmail.com]
Sent: Wednesday, September 01, 1999 3:52 PM
To: powerh-l@lists.swau.edu
Subject: Irrational subfile behavior
Good afternoon, fellow code-mules....
I've the following ?
I build a subfile (trwrk01) and define the 4x 'count' fields as zoned*2.
Now, riddle me this----how are my 'count' field morphing themselves into
floating point, hmmm ?
Q U I Z (PowerHouse 8.19.C1)
Copyright 1998 COGNOS INCORPORATED
acc *trwrk01
sho ite
INPUT OUTPUT
TRWRK01 TYPE SCALE SCALE DEC PICTURE
* TI-KEY CHAR X(14)
TI-PLAN-ID CHAR X(4)
TI-PART-ID CHAR X(10)
TI-REC-CODE CHAR X(3)
T-CB2-COUNT-81 NUM 0 0 0 ^^
T-CB2-COUNT-83 NUM 0 0 0 ^^
T-LO2-COUNT-1 NUM 0 0 0 ^^
T-LO2-COUNT-2 NUM 0 0 0 ^^
REF-NBR-LO2 CHAR X(2)
TI-401K-BASIC-PCT NUM 0 0 0 ^^
TI-AFT-BASIC-PCT NUM 0 0 0 ^^
ASD-T-PAYMENT NUM 0 0 0 ^^^^^^^^
TI-INT-RATE-LO2 NUM 0 0 0 ^^.^^^
TI-LOAN-LENGTH-LO2 NUM 0 0 0 ^,^^^
TI-PAYMENT-FREQ-LO2 CHAR X(2)
TI-LOAN-AMOUNT-LO2 NUM 0 0 0
e
End Run
qshow
Q S H O W (PowerHouse 8.19.C1)
Copyright 1998 COGNOS INCORPORATED
sho sub trwrk01
99/09/01 SUBFILE DICTIONARY
SUBFILE RECORD REPORT
Subfile: TRWRK01
> > Type: Permanent
> > Organization: Indexed
> > Format: 8
> > Record Size: 98 Bytes
> >
Item Type Offset Size Occurs
TI-KEY CHARACTER 0 14
TI-PLAN-ID CHARACTER 14 4
TI-PART-ID CHARACTER 18 10
TI-REC-CODE CHARACTER 28 3
T-CB2-COUNT-81 IEEE FLOAT 31 8
T-CB2-COUNT-83 IEEE FLOAT 39 8
T-LO2-COUNT-1 IEEE FLOAT 47 8
T-LO2-COUNT-2 IEEE FLOAT 55 8
REF-NBR-LO2 CHARACTER 63 2
TI-401K-BASIC-PCT ZONED UNSIGNED 65 2
TI-AFT-BASIC-PCT ZONED UNSIGNED 67 2
ASD-T-PAYMENT ZONED UNSIGNED 69 9
TI-INT-RATE-LO2 ZONED UNSIGNED 78 5
TI-LOAN-LENGTH-LO2 ZONED UNSIGNED 83 4
TI-PAYMENT-FREQ-LO2 CHARACTER 87 2
TI-LOAN-AMOUNT-LO2 ZONED UNSIGNED 89 9
> >
> > -- Index Contents --
> >
** TRIDX1 is a 14 byte REPEATING PRIMARY index **
> >
> >
Segment Type Size Ord Offset
TI-KEY CHARACTER 14 A 0
'''''''''''''''''''''''''''''''''''''''
' Al Karman '
' Information Technology Consulting '
' Internet: alkarman@hotmail.com '
' FAX: 248.671.5035 '
'''''''''''''''''''''''''''''''''''''''
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.