Irrational subfile behavior
Pickering, John (NORBORD)
PICKERIJ@norbord.com
Wed, 1 Sep 1999 17:04:57 -0400
I note that the subfile is permanent. Did you create the subfile previously
with the counters defined as numeric (i.e. floating point)? Quiz then just
writes over the data but doesn't bother changing the file label where the
dictionary info is kept.
Just one more reason to avoid permanent subfiles.
John "a pox on permanent subfiles" Pickering
> -----Original Message-----
> From: Al Karman [SMTP:alkarman@hotmail.com]
> Sent: Wednesday, September 01, 1999 4: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.