DB2 to PDL dictionary utility?

[Whittall, Conrad]

Sorry Blue, but the DATABASE statement is only available in PowerHouse 8.

PowerHouse on AS/400 handles the DB2 database in much the same way (from a
data dictionary point of view) as PowerHouse 7.10 on OpenVMS handles Oracle
Rdb...through the FILE statement (where the TYPE will be SQL/400 instead of
RDB).

The GENPDLSRC program is indeed capable of generating PDL for DB2 tables,
although you will find that they are referred to throughout the PowerHouse
documentation as SQL/400 Collections. And you must generate the PDL for an
entire Collection, rather than for selected tables within a Collection.

Take a look at Chapter 4 in the "Dictionary and Utilities Reference (version
6.07)" manual of the "PowerHouse for AS/400" documentation set. In
particular, at the end of this chapter, is a topic headed "How GENPDLSRC
Handles Collections"

Best regards,
Conrad

Conrad Whittall
Marketing Manager, Application Development Tools, Cognos Incorporated

enterprise2000 - the North American Cognos User Conference
October 2-5, Anaheim, California

Join over one thousand customers and Cognos staff at this annual event
to see and hear how Cognos products are being used worldwide to create
business solutions that capture, update, query, report, analyze and
visualize information in Web, Windows and server-based environments.

Full details can be found at http://www.cognos.com/enterprise2000


-----Original Message-----
From: Edis, Bob [mailto:bob.edis@fleetpride.com]
Sent: Tuesday 26 September 2000 12:47
To: 'powerh-l@list.swau.edu'
Subject: RE: DB2 to PDL dictionary utility?


G'day Paul

As DB2 is a relational database you should be able to create a new PDL
script with a DATABASE section pointing to the DB2 database.  The metadata
should be inherited directly from the RDBMS rather than explicitly putting
it in the PHD.

Regards,
Blue

-----Original Message-----
From: Paul Hoeflinger [mailto:phoeflin@fmo.com]
Sent: Tuesday, September 26, 2000 10:08 AM
To: powerh-l@sphere.swau.edu
Subject: DB2 to PDL dictionary utility?




AS400 users,

     My company is in the process of obtaining an AS400 to run an order
entry
package. I have limited knowledge of the AS400 and the DB2 data base. I was
wondering if there is a product that will create a PH dictionary from a DB2
data
base.  A call to Cognos support indicated that the utility  "genpldsrc"
contained in PH607F might be used to create a PowerHouse dictionary from the
DB2
library tables. Can anyone verify if this utility will work or does anyone
have
any specific experience in generating a dictionary from DB2.

     Thanks in advance.


= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.