HP3000-L Archives

June 2013, Week 2

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: Image: Simple List of Data Elements
From:
Neil Armstrong <[log in to unmask]>
Reply To:
Neil Armstrong <[log in to unmask]>
Date:
Mon, 10 Jun 2013 16:19:45 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (97 lines) 
Dear Tim,

Here are two example tasks one using query the other Suprtool, I just used
general names such as database, dataset and field(#) to give you an idea,
how to extract data. Suprtool is our product from Robelle, I'm just
showing it incase you have it on your system.

:FILE QSLIST=MYFILE;DEV=DISC
query.pub.sys
B=DATABASE
PASSWORD
5
AS LOCKOPTION=OFF
O=LP
S=DATASET
FIND ALL
REPORT
NOPAGE
D1,field1,8
D1,field2,18
D1,FIELD3,28
S1,FIELD1
END
EXIT

run suprtool.pub.robelle
base database,5,password
get dataset
ext field1
ext field2
ext field3
sort field1
out MYFILE,ascii
exit

Sincerely,



Neil Armstrong
Robelle


On 13-06-10 3:48 PM, "Howard Hoxsie" <[log in to unmask]> wrote:

>ftp://ftp.mrynet.com/os/HP-MPE/docs.hp.com/en/32650-90387/index.html
>
>The Query Manual for V and iX for help with other command syntax.  Haven't
>done this in decades personally, but used to do it lots of times per day
>way back when.
>
>Cheers!
>Howard
>
>
>On Mon, Jun 10, 2013 at 12:41 PM, Gribbin, Francis J. <
>[log in to unmask]> wrote:
>
>> Hi Tim,
>>
>> You can equate  QSLIST  to a disc file:    FILE
>>QSLIST=MYFILE,NEW;DEV=DISC
>> Then in your QUERY report set              OUTPUT=LP
>>
>> Your report will go to MYFILE and you can take it from there.
>>
>> Frank J. Gribbin
>> Information Systems
>> Potter Anderson & Corroon LLP
>>
>> -----Original Message-----
>> From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On
>> Behalf Of Tim
>> Sent: Monday, June 10, 2013 3:03 PM
>> To: [log in to unmask]
>> Subject: [HP3000-L] Image: Simple List of Data Elements
>>
>> One of my users wants me to extract data from Image data base and
>>provide
>> it in the form of a text list.  Is there an easy, non-professional way
>>to
>> do this, e.g. using Query?
>>
>> * To join/leave the list, search archives, change list settings, *
>> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>>
>>
>> * To join/leave the list, search archives, change list settings, *
>> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>>
>
>* To join/leave the list, search archives, change list settings, *
>* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2