"Ray Cotton" <[log in to unmask]> writes:
> I know it can be done but I am having a bad hair day, I want to use
> Query to extract data from on dataset and populate another empty
> database with that info.
>
> Please advise on the technique, I'm sure it involves QSLIST.
>
> If not is there another way, other than DBGeneral, Flexibase and so on.

I have a Cobol program that will load data from Query.  To get the data from
Query, I use the "save" command, like this:

>BASE=MYDB
PASSWORD = >>MYPASS
MODE = >>5
>SET=MYSET
>FIND KEY-ITEM="SOMEVALUE"
>SAVE MYFILE

MYFILE is saved as a SD file that I then run through my Cobol program (the
program is called MQUERY, by the way) and it can be added into any data base
you want (and any set you want, although that can get messy).

Contact me privately if you would like the program (source and all).

Jim Phillips                           Information Systems Manager
Email: [log in to unmask]     Therm-O-Link, Inc.
Phone: 330-527-2124                         P. O. Box 285
Fax:   330-527-2123                           10513 Freedom Street
Web:   http://www.tolwire.com          Garrettsville, OH  44231

I WANT MY MPE!

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