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_01C1683A.47D77920 Content-Type: text/plain; charset="iso-8859-1" That is no problem. Have a look at the compressed output from QSHOW and you will see that each section is delimited by a row of dashes. All you have to do is work out an algorithm, which can be programmed/scripted in the language of your choice, that will drop the sections that you do not need. For example: Step 1 - extract required 'file section' from QSHOLIST to file_1. Step 2 - extract all 'record sections' mentioned in file_1 from QSHOLIST to file_2. Step 3 - extract all 'element sections' mentioned in file_2 from QSHOLIST to file_3. Step 4 - combine file_1, file_2 and file_3 into a single file. Basically this is what I did 'manually'. The only difference is that I removed unneeded record names from the 'element sections'. regards, Robert -----Original Message----- From: Leonard_Berkowitz@harvardpilgrim.org [mailto:Leonard_Berkowitz@harvardpilgrim.org] Sent: 07 November 2001 18:49 To: Witkopp, Richard Cc: PowerHouse List (E-mail) Subject: RE: Extracting data from a PHD 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 = = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list: powerh-l@lists.swau.edu Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu Unsubscribe: "unsubscribe" in message body to powerh-l-request@lists.swau.edu http://lists.swau.edu/mailman/listinfo/powerh-l This list is closed, thus to post to the list you must be a subscriber. ------_=_NextPart_001_01C1683A.47D77920 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">RE: Extracting data from a PHD That is no problem. Have a look at the compressed = output from QSHOW and you will see that each section is delimited by a = row of dashes. All you have to do is work out an algorithm, which can = be programmed/scripted in the language of your choice, that will drop = the sections that you do not need.
For example:
Step 1 - extract required 'file section' from = QSHOLIST to file_1.
Step 2 - extract all 'record sections' = mentioned in file_1 from QSHOLIST to file_2.
Step 3 - extract all 'element sections' = mentioned in file_2 from QSHOLIST to file_3.
Step 4 - combine file_1, file_2 and file_3 = into a single file.Basically this is what I did 'manually'. The only = difference is that I removed unneeded record names from the 'element = sections'.
regards,
Robert-----Original Message-----
From: Leonard_Berkowitz@harvardpilgrim.org
[mailto:Leonard_Berk= owitz@harvardpilgrim.org]
Sent: 07 November 2001 18:49
To: Witkopp, Richard
Cc: PowerHouse List (E-mail)
Subject: RE: Extracting data from a PHD
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.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
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 PMSent 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=3D-80,,F,ASCII;DISC=3D10000000
:FILE QSHOLIST=3DPHDLIST,OLD
:QSHOW
> set dictionary ........
> set report device printer
> set compress
> show all
> exitand 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 PHDQshow
> Set Dictionary ........
> Set language PDL
> Gen File (OR record,database ........)Default File Name QSHOGEN
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D = =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D
------_=_NextPart_001_01C1683A.47D77920--
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to = powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body = to powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you = must be a subscriber.