FW: Extracting data from a PHD

Robert Mills robert.mills@windsong-services.co.uk
Wed, 7 Nov 2001 17:17:00 -0000


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_01C167B0.02FD6330
Content-Type: text/plain;
	charset="iso-8859-1"

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


------_=_NextPart_001_01C167B0.02FD6330
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">



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=3D-80,,F,ASCII;DISC=3D10000000
:FILE QSHOLIST=3DPHDLIST,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

------_=_NextPart_001_01C167B0.02FD6330--