Powerhouse 4GL RDBMS Question - Subitems

[Latimer, Richard]

Charles,

sub items are supported on DB2/400 -  and I would expect other versions
of the IBM's UDB - the down side is that you only have a really old
version of PH (6.07) to use. See example below:

The IBM data dictionary spec id:

                     
            Data        Field  Buffer    Buffer        Field    Column

 Field      Type       Length  Length  Position        Usage    Heading

 F0003      CHAR            6       6        15        Both
Tme_fplcreatn_char 
   Field text  . . . . . . . . . . . . . . . :  Tme_fplcreatn_char

   Alternative name  . . . . . . . . . . . . :  TME_FPLCREATN_CHAR

   Coded Character Set Identifier  . . . . . :     37


Within Qshow the element is defined  as:

 Item Name                         Type               Size Occurs
Offset 
 

 TME_FPLCREATN_CHAR                CHARACTER             6      1
14 
 .TME_FPLCREATN                    ZONED UNSIGNED        6      1
14 
 ..TME_FPLCREATN_HH                ZONED UNSIGNED        2      1
14 
 ..TME_FPLCREATN_MM                ZONED UNSIGNED        2      1
16 
 ..TME_FPLCREATN_SS                ZONED UNSIGNED        2      1
18 



regards
Richard




**********************************************************************
This electronic message together with any attachments is confidential. If
you receive it in error: (i) you must not use, disclose, copy or retain
it; (ii) please contact the sender immediately by reply email and then
delete the emails. Views expressed in this email may not be those of the
Airways Corporation of New Zealand Limited
**********************************************************************