Irrational subfile behavior
Al Karman
alkarman@hotmail.com
Wed, 01 Sep 1999 21:08:50 GMT
Funny you mention subtotalling - I do invoke that arcane function....
Why does Quiz insist on redefining, on its own, my fine work??
And a follow-up, Mr. President....why DOESN'T QTP do auto-redefine??
>From: "Ohmes, Matt" <Matt.Ohmes@COGNOS.com>
>To: 'Al Karman' <alkarman@hotmail.com>, powerh-l@lists.swau.edu
>Subject: RE: Irrational subfile behavior
>Date: 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.
______________________________________________________
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.