Irrational subfile behavior
Al Karman
alkarman@hotmail.com
Wed, 01 Sep 1999 21:13:06 GMT
Good call, Pox-John....
Having the curse of 15+years in this parallel universe of applications
development, I have learned the hard way (is there ever an easy way?) to
:Purge <permsubfile>
:Listf <permsubfile>,2
A pox on 'yer pox!
>From: "Pickering, John (NORBORD)" <PICKERIJ@norbord.com>
>To: "'Al Karman'" <alkarman@hotmail.com>, powerh-l@lists.swau.edu
>Subject: RE: Irrational subfile behavior
>Date: 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.
'''''''''''''''''''''''''''''''''''''''
' 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.