PDL -Help!!!!

[Deskin, Bob]

Axiant can only do this via ODBC and I don't know that this is the way to
go. I suggest going with John's solution or looking at PowerHouse Architect.
PowerHouse Architect allows you to load the information from an IMAGE
database and then generate PDL.

Bob Deskin              
PowerHouse Web Product Manager and Senior Product Advisor
Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 4205 FAX: (613) 228-3149
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA


-----Original Message-----
From: Robert J.M. Edis [mailto:robert.edis@creatcomp.com]
Sent: Friday, September 17, 1999 2:23 PM
To: powerh-l@lists.swau.edu
Subject: RE: PDL -Help!!!!


Ok you nice Cognos people,  can Axiant workbench 'read' metadata from an
Image database and output PDL???  I know it can do this for relational
databases and even ISAM files via ODBC.

If it can, this may be a reasonable 'low' cost solution to your issue Joyce.
Otherwise John P's method might work out best for you.  Pressure Cognos for
an answer; it sounds like you are a new customer and that's good for Cognos.

Blue

-----Original Message-----
From: Joyce.Bleza@bartoncotton.com [mailto:Joyce.Bleza@bartoncotton.com]
Sent: Friday, September 17, 1999 2:14 PM
To: robert.edis@creatcomp.com; powerh-l@lists.swau.edu
Subject: RE: PDL -Help!!!!


Hi Robert,

Is you data already defined in an Image database?
Yes, its Image database.

Have you used PowerHouse before in your company?
No, this is the initial setup. 

What other platforms do you have access to?
I'm using HP3000, operation system version mpeix 5.5 and
I'm using PH729C9 version of powerhouse.

How many data files and elements do you need to define in the dictionary?
Too much to count.....

How are you accessing the data at the moment?
We use Query, Suprtool and COBOL.


-----Original Message-----
From: Robert J.M. Edis [mailto:robert.edis@creatcomp.com]
Sent: Friday, September 17, 1999 1:56 PM
To: powerh-l@lists.swau.edu
Subject: RE: PDL -Help!!!!


G'day Joyce

Is you data already defined in an Image database?
Have you used PowerHouse before in your company?
What other platforms do you have access to?
How many data files and elements do you need to define in the dictionary?
How are you accessing the data at the moment?

If you have access to a VMS box with PowerHouse, you can easily enter the
definitions in the PHD using the POW utility (PowerHouse Dictionary
Manager).  Another option is to use PH Architect.

If you create your PHD on a VMS box you can then use QSHOW to create a new
PDL file.  Copy this to your MPE box and compile.

If you don't have access to Architect or a VMS machine, maybe you could pay
someone else to create the PHD for you at a reasonable cost.  Check out
Creative Computing at www.creatcomp.com if this idea works for you.

Regards,

Blue

-----Original Message-----
From: Joyce.Bleza@bartoncotton.com [mailto:Joyce.Bleza@bartoncotton.com]
Sent: Friday, September 17, 1999 12:23 PM
To: PICKERIJ@norbord.com; Joyce.Bleza@bartoncotton.com;
powerh-l@lists.swau.edu
Subject: RE: PDL -Help!!!!


Sorry, We're using HP3000, mpeix 5.5

-----Original Message-----
From: Pickering, John (NORBORD) [mailto:PICKERIJ@norbord.com]
Sent: Friday, September 17, 1999 12:21 PM
To: 'Joyce.Bleza@bartoncotton.com'; powerh-l@lists.swau.edu
Subject: RE: PDL -Help!!!!



>Anybody out there could help me with creating a dictionary.
>I'm setting up my company in powerhouse, but the problem is that the newest
>version of powerhouse doesn't have QDD or any other tools that will allow
me
>in creating a new dictionary without typing each elements, items and
>etc....in using PDL I have to type all my items, and elements for all my
>database. As you all know, its so hard converting data types of elements.
So
>please, anybody out there that could point me in other direction with out
>purchasing a new tools, we're in tight budget.....

You don't specify what machine line you're using. The availability of
conversion tools will depend on this.

Here's what I'd do if it was an HP3000; if you're using a lesser machine
then you're on your own :-) Get a copy of ITOQ to create QDD source from the
Image root file(s). Then use the QDDTOPDL command file (it does a nicer job
than QSHOW) which should be included with the current version to convert the
QDD source to PDL source. I don't when the last time ITOQ was distributed
but you should still be able to get an unsupported version from your sales
rep or from somebody somewhere :-) This scenario will give you a good
starting point for a dictionary but I would still want to add in things like
picture clauses.

John Pickering
Toronto
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.