Extracting data from a PHD

Wed, 7 Nov 2001 10:01:12 -0800

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C167B6.2FA780E0
Content-Type: text/plain;
	charset="iso-8859-1"

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 <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 

------_=_NextPart_001_01C167B6.2FA780E0
Content-Type: text/html;
	charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>FW: Extracting data from a PHD</TITLE>

<META content="MSHTML 5.00.2920.0" name=GENERATOR></HEAD>
<BODY>
<DIV>If you 
don't have to do anything fancy, you can just call the 
qsholist</DIV>
<DIV>a 
subfile and fiddle with it with quiz. You have to create a subfile 
dictionary</DIV>
<DIV>first, 
but that's easy.</DIV>
<DIV>&nbsp;</DIV>
<BLOCKQUOTE 
style="BORDER-LEFT: #0000ff 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px">
 <DIV align=left class=OutlookMessageHeader dir=ltr>-----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 </DIV>
 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 
 :^&gt;&gt; so a
 :BUILD PHDLIST;REC=-80,,F,ASCII;DISC=10000000 :FILE QSHOLIST=PHDLIST,OLD :QSHOW 
 &gt; set dictionary ........ &gt; set 
 report device printer &gt; set compress 
 &gt; show all &gt; 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 
 [<A 
 href="mailto:simopoulos@scoplife.gr">mailto:simopoulos@scoplife.gr</A>] 
 Sent: 07 November 2001 14:15 To: 
 Robert Mills Subject: Re: Extracting data from a 
 PHD 
 Qshow &gt; Set Dictionary 
 ........ &gt; Set language PDL &gt; Gen File (OR record,database ........) 
 Default File Name QSHOGEN </BLOCKQUOTE></BODY></HTML>

------_=_NextPart_001_01C167B6.2FA780E0--