Hi Charles,
The substructuring does not change with Eloquence. The implementation were
are using only requires you to change the location for the open statements.
Otherwise, the dictionary can remain the same.
Regards,
Christina Hasse
ADT N.A. Technical Manager
COGNOS CORPORATION
425 North Martingale Road, Suite 600
Schaumburg, IL 60173
[log in to unmask]
Office: 847 - 285 - 2905
Cell: 847 - 269 - 1909
Fax: 847 - 240 - 0252
http://powerhouse.cognos.com
-----Original Message-----
From: Charles Finley [mailto:[log in to unmask]]
Sent: Thursday, September 25, 2003 1:36 PM
To: Hasse, Christina; [log in to unmask]
Subject: RE: Powerhouse 4GL RDBMS Question - Subitems
Thanks to all who have responded. How are sub items handled in the
Powerhouse Eloquence implementation? Is it the same as with the IMAGE
implementation?
Charles Finley
Transformix Computer Corporation
(760)-439-3146
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]]On
Behalf Of Hasse, Christina
Sent: Thursday, September 25, 2003 10:31 AM
To: [log in to unmask]
Subject: FW: Powerhouse 4GL RDBMS Question - Subitems
Hi Charles,
I would also add that it is not that PowerHouse does not support
substructuring for relational databases, it is that relational databases do
not support substructuring.
With Image, you define the structure in both Image and PowerHouse in it's
entirety. The definition required within PowerHouse for a relational
database is just a pointer to where they actual definition is. The actual
structure does not get defined in PowerHouse only within the relational
database.
Regards,
Christina Hasse
ADT N.A. Technical Manager
COGNOS CORPORATION
425 North Martingale Road, Suite 600
Schaumburg, IL 60173
[log in to unmask]
Office: 847 - 285 - 2905
Cell: 847 - 269 - 1909
Fax: 847 - 240 - 0252
http://powerhouse.cognos.com <http://powerhouse.cognos.com/>
-----Original Message-----
From: Deskin, Bob [mailto:[log in to unmask]]
Sent: Thursday, September 25, 2003 11:48 AM
To: 'Charles Finley'; [log in to unmask]
Subject: RE: Powerhouse 4GL RDBMS Question - Subitems
That is correct.
With IMAGE, we read the schema into the dictionary and then allow what are
effectively overlays or substructures. With IMAGE, we read and write the
entire record.
With relational, we do not read the schema into the dictionary. Rather we
access the schema from QDESIGN, QUIZ, or QTP when we are parsing QDESIGN,
QUIZ, or QTP source code. With relational, we do not read and write the
entire row. Rather we read and write the columns that are used in the
screen, report, or run. This is the recommended approach for relational
databases.
Note that, while in common usage, substructuring is not really a normalized
approach to data and relational databases work best with normalized data.
This is an issue that must be dealt with when migrating PowerHouse from
IMAGE to relational.
Bob Deskin
Product Manager, Application Development Tools, Cognos Inc.
[log in to unmask] (613) 738-1338 ext 7268 FAX: (613) 727-1178
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA
-----Original Message-----
From: Charles Finley [ mailto:[log in to unmask]
<mailto:[log in to unmask]> ]
Sent: Thursday, September 25, 2003 10:34 AM
To: [log in to unmask]
Subject: Powerhouse 4GL RDBMS Question - Subitems
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
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: [log in to unmask]
Subscribe: "subscribe" in message body to [log in to unmask]
Unsubscribe: "unsubscribe <password>" in message body to
[log in to unmask]
http://lists.swau.edu/mailman/listinfo/powerh-l
<http://lists.swau.edu/mailman/listinfo/powerh-l>
This list is closed, thus to post to the list you must be a subscriber.
Join us at Cognos' biggest event of the year Enterprise 2003, The Cognos
Business Forum. Taking place in over 25 cities around the world, it's an
opportunity for Business and IT leaders to learn about strategies for
driving performance. Visit http://www.cognos.com/enterprise03
<http://www.cognos.com/enterprise03> for more details.
This message may contain privileged and/or confidential information. If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. Thank you.
Join us at Cognos' biggest event of the year Enterprise 2003, The Cognos
Business Forum. Taking place in over 25 cities around the world, it's an
opportunity for Business and IT leaders to learn about strategies for
driving performance. Visit http://www.cognos.com/enterprise03 for more
details.
This message may contain privileged and/or confidential information. If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. Thank you.
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
Join us at Cognos' biggest event of the year Enterprise 2003, The Cognos
Business Forum. Taking place in over 25 cities around the world, it's an
opportunity for Business and IT leaders to learn about strategies for
driving performance. Visit http://www.cognos.com/enterprise03 for more
details.
This message may contain privileged and/or confidential information. If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. Thank you.
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
