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.