PH Access to Data Areas

Whittall, Conrad Conrad.Whittall@Cognos.COM
Tue, 8 May 2001 15:06:19 -0400


OK, please bear with me here as I haven't touched an AS/400 (unfortunately)
for a few years. However, I do remember that one of the enhancements
introduced with PowerHouse 6.07 was the ability to treat data areas just
like any other PowerHouse data FILE.

You need to declare the FILE in your PowerHouse data dictionary as normal,
except that the file TYPE will be DATA AREA...which may be a local, process
or group data area (which you specify as *LDA, *PDA or *GDA with no library
name as the OPEN name for the file). PowerHouse treats these data areas as
single record files with a PowerHouse ORGANIZATION of DIRECT.

You can find a discussion of this in the "PowerHouse for AS/400 Dictionary
and Utilities Reference" manual for version 6.07 of PowerHouse, under the
FILE statement on pages 215-235.

My guess is that once you have declared your data areas as FILEs in the
PowerHouse data dictionary then you can use either QUICK or QTP to read and
write to these data areas, as well as using QUIZ to read them.

I hope that this points you in the right direction.

Best regards,
Conrad

Conrad Whittall
Marketing Manager, Application Development Tools
Cognos Incorporated, 3755 Riverside Drive, Ottawa, Ontario, K1G 4K9, Canada

Developer productivity never goes out of style!

For details of the Cognos PowerHouse family of high-productivity
development tools for Web, Windows and terminal-based business
applications, and to request your own free copy of our new product
demo CD, simply click here http://www.cognos.com/powerhouse.

-----Original Message-----
From: joann.l.olsen@us.abb.com [mailto:joann.l.olsen@us.abb.com]
Sent: Monday 7 May 2001 14:00
To: 'powerh-l@list.swau.edu'
Subject: PH Access to Data Areas

We are on an AS/400 platform, but using some PowerHouse for creating
reports.
When a user runs a Dream Writer, the version that they have selected is held
in
the Logical Data Area (LDA).  When the job ends the LDA ceases to exist.  I
would like to be able to use the version in my PowerHouse Quiz routine to
obtain
the responses to the various prompts in the Data Selection Values.  The
version
is part of the index needed to read the F98301 & F9831 files. How can I read
this data area or move the information contained in the data area to a
subfile?

Thanks for your help.