HP3000-L Archives

February 2003, Week 4

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:
From:
Craig Lalley <[log in to unmask]>
Reply To:
Craig Lalley <[log in to unmask]>
Date:
Thu, 27 Feb 2003 07:10:06 -0800
Content-Type:
text/plain
Parts/Attachments:
text/plain (62 lines)
Leonard,

I am not quite sure what your are asking, maybe this will help

%LISTF @.DATA.ACCT(DBSETNAME='CUSTOMER'),2   or 6

Works on my system.

That way if you know the dataset name "CUSTOMER" it will return the image file,
DBNAME01.DATA.ACCT.

Another trick is to modify DB.LISTF.VESOFT to return the values you need.

Regards,

-Craig

--- "Leonard S. Berkowitz" <[log in to unmask]> wrote:
> I am looking for a method to return the MPE file name of a TurboImage
> dataset.
>
> We have to move certain data along from a development data base to a UAT
> data base and eventually to production. We are using SUPRTOOL to extract
> and load the data, not a 3GL program. The amount of data (entries) is
> variable and unpredictable. Accordingly, it is essential that the process
> determine the number of free entries in the target dataset. I can do all of
> this with VEFINFO functions (DBSETENTRIES and DBSETCAPACITY) in MPEX, but I
> need the MPE file name, e.g., dbasef0.group.account. All the process
> "knows" is the TurboImage dataset name. With MPEX, I could get the dataset
> name (DBSETNAME) from the MPE file name, but there is nothing to go the
> other way.
>
> With a lot of work, I can run DBDRIVER with the output redirected to a disk
> file that I can parse. It is fairly simple for datasets 1-99, but for
> 100-199 I'll have to mess with two arrays (an array of ABCDEFGHIJ and an
> array of 10111213141516171819) and match the first two positions of the
> dataset number returned by DBINFO mode 201 in the DBDRIVER output.
>
> This is doable, but if someone has already invented this axle, I'd prefer
> to avoid reinventing it. An alternate method will be welcome.
>
> Thanks.
> --
> Leonard S. Berkowitz
> Perot Health Care Systems
> (Harvard Pilgrim Health Care account)
> voice: 617-509-1212
> fax: 617-509-1955
> pager: 781-226-2431
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *


__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/

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

ATOM RSS1 RSS2