I have several methods depending on where I am at :
Query as noted previously:
>ba = vopdb1.y2kk
PASSWORD = >>
MODE = >>5
>form sets


DATA BASE: VOPDB1.Y2KK                  MON, AUG 14, 2000,  3:46 PM


DATA BASE LANGUAGE ATTRIBUTE: NATIVE-3000


                            ITEM   CURRENT   ENTRY    ENTRY   BLOCKING
SETS:                 TYPE  COUNT  CAPACITY  COUNT    LENGTH  FACTOR

   V-OP-BILL-MSTR     A     1      5000      37       5       23
   V-OP-CNTRL-MSTR    M     3      100       1        22      14
   V-OP-REC-MSTR      A     1      5000      37       4       25
   V-OP-TRANS-MSTR    M     4      100       1        18      14
   V-OP-BILL-DTL      D     8      10005     196      26      15
   V-OP-PAT-BILL      D     7      10008     37       28      12

>

Mpex as noted previously:
%listf [log in to unmask],db

                       MPEX %LISTF [log in to unmask]   PAGE 1
 SYSTEM SERIES 969-120   DPCL2140,MGR.ALTA0,DATA   MON, AUG 14, 2000,  3:47
PM



ACCOUNT=  ALTA0       GROUP=  Y2KK

FILENAME SET NAME     TYPE LDEV  ENTRY   CAPA-  %FULL BLK SECTORS %BLOCK
SECTRS
                                 COUNT    CITY        FCT         WASTED
WASTED

VOPDB101 V-OP-BILL-MSTR  A  45      37    5000   0.7%  23     880   0.8%
6
VOPDB102 V-OP-CNTRL-MSTR M  45       1     100   1.0%  14      32   1.3%
0
VOPDB103 V-OP-REC-MSTR   A  45      37    5000   0.7%  25     608   1.8%
11
VOPDB104 V-OP-TRANS-MSTR M  45       1     100   1.0%  14      48   4.1%
1
VOPDB105 V-OP-BILL-DTL   D  45     196   10005   2.0%  15    2672   0.2%
5
VOPDB106 V-OP-PAT-BILL   D  45      37   10008   0.4%  12    3344   6.1%
202

Supertool:

>ba vopdb1.y2kk
Database password [;]?

>fo

Database: VOPDB1.Y2KK.ALTA0

                      Set       Item             Entry    Load   Entry
Sets:                 Num Type  Count  Capacity  Count    Factor Length  B/F
   V-OP-BILL-MSTR     1   A     1      5000      37       1  %   5       23
   V-OP-CNTRL-MSTR    2   M     3      100       1        1  %   22      14
   V-OP-REC-MSTR      3   A     1      5000      37       1  %   4       25
   V-OP-TRANS-MSTR    4   M     4      100       1        1  %   18      14
   V-OP-BILL-DTL      5   D     8      10005     196      2  %   26      15
   V-OP-PAT-BILL      6   D     7      10008     37       0  %   28      12
>ea

Qshow:
> show file vopdb1
######                    Precision 2000 - ALT-7                  Page    1
                           F I L E   R E P O R T
                           For DICTIONARY:  phd
    File:               VOPDB1
    Organization:       DATABASE
    Type:               TURBOIMAGE
    Open:               VOPDB1.Y2KK
    Create Status:      Create
    Crit. Item Update:  No
    Records & Sizes:    V-OP-BILL-MSTR                    10 bytes Create
                        V-OP-REC-MSTR                      8 bytes Create
                        V-OP-CNTRL-MSTR                   44 bytes Create
                        V-OP-TRANS-MSTR                   36 bytes Create
                        V-OP-BILL-DTL                     52 bytes Create
                        V-OP-PAT-BILL                     56 bytes Create

but the only one which tells me the MPE name with the dataset name is MPEX.


from the desk of Cat Litten,

Senior Programmer Analyst, VPH

(Valley Presbyterian Hospital on the web at http://www.valleypres.org)






-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]]On
Behalf Of Scott Root
Sent: Monday, August 14, 2000 1:47 PM
To: [log in to unmask]
Subject: dataset filenames


Can someone tell me how I can produce a listing of the datasets and the
filenames they correspond to in an Image/SQL database? We're running MPEix
6.0 PP1.

-----------------------------------
Scott Root
System Manager
Prescom Industries Inc.
Newsletter Holdings, LLC
703-905-4551
-----------------------------------