Powerhouse 4GL RDBMS Question - Subitems

Charles Finley cfinley@xformix.com
Thu, 25 Sep 2003 07:34:23 -0700


With IMAGE DB you can define Subitems in Powerhouse which is nothing else as
using one single field out of the database and defining a data structure
within Powerhouse for this single DB field using the PHD (Powerhouse
Dictonary).

Example:
     Field in IMAGE DB:      X CHAR(10)
     Subitems in Powerhouse using field X of IMAGE DB:
                       subitem1 CHAR(3)
                       subitem2 CHAR(3)
                       subitem3 CHAR(4)

We are speaking with someone who has  told us that they have tried to do
this with a relational DB and learned that is under the impression that
Powerhouse does not support this ability to overlay fields   for a
relational DB, only for IMAGE DB. The client went on to say that you cannot
define Subitems in the Powerhouse Dictonary for a relational DB.

Can someone confirm this?

Charles Finley
Transformix Computer Corporation
(760)-439-3146