Extracting data from a PHD

[Leonard_Berkowitz@harvardpilgrim.org]

Yes, but the output of QSHOW is still a varying number of lines, per, say,
element, depending, among other factors, on how many different record
structures have that element.
===================
Leonard S. Berkowitz
Perot Health Care Systems
(Harvard Pilgrim Health Care account)
voice: 617-509-1212
fax:   617-509-3737
pager: 781-226-2431




"Witkopp, Richard" <Richard.Witkopp@idt.com>@cube.swau.edu on 11/07/2001
01:01:12 PM

Sent by:  powerh-l-admin@cube.swau.edu


To:   "PowerHouse List (E-mail)" <powerh-l@lists.swau.edu>
cc:

Subject:  RE: Extracting data from a PHD



If you  don't have to do anything fancy, you can just call the  qsholist
a  subfile and fiddle with it with quiz. You have to create a subfile
dictionary
first,  but that's easy.

-----Original Message-----
From: Robert Mills  [mailto:robert.mills@windsong-services.co.uk]
Sent: Wednesday,  November 07, 2001 9:17 AM
To: PowerHouse List  (E-mail)
Subject: FW: Extracting data from a  PHD



Thanks SD and Joe (Cognos),

I've already tried this way. It does give me what I want, or  at least all
the data is there, but not the way I want it :( The recipients of  this
info are non-PowerHouse aware and might not understand the PDL syntax  :^>>
so a

:BUILD PHDLIST;REC=-80,,F,ASCII;DISC=10000000
:FILE QSHOLIST=PHDLIST,OLD
:QSHOW
> set dictionary ........
> set  report device printer
> set compress
> show all
> exit

and then editing the resulting PHDLIST (QSHOLIST) file gave  the best
results -- so far.

Somebody suggested that I use Axiant. Would love to have tried  but the
evaluation licence I had for version 3.0 ran out a couple of months  ago
and I have deleted/destroyed the installation.

Now that I've got PERL on this machine I might try writing a  script to
massage a QSHOLIST.

regards,
Robert

-----Original Message-----
From: SD  mailto:simopoulos@scoplife.gr]
Sent: 07 November 2001 14:15
To:  Robert Mills
Subject: Re: Extracting data from a  PHD

Qshow
> Set Dictionary  ........
> Set language PDL
> Gen File (OR record,database ........)

Default File Name QSHOGEN