Irrational subfile behavior
Al Karman
alkarman@hotmail.com
Wed, 01 Sep 1999 20:51:45 GMT
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.