Scott Root wrote,
> Can someone tell me how I can produce a listing of the data sets and the
> filenames they correspond to in an Image/SQL database? We're running MPEix
> 6.0 PP1.
**** Warning **** Lightly disguised Plug follows
The DISCOVER/3000 EXAMINE <database> can do that. The first
part of the dialogue shows the sets in numerical order
Example follows:
¤EXAMINE MMMCON
File MMMCON.DATA.MMMIS, PRIV, 128W, FB, EOF= 20
Enter password for Database MMMCON.DATA.MMMIS, enter / to skip ;
; accepted as 'creator' indicator
Enter data set to examine, ? to see all sets: ?
Set# Name Type Capacity #Entries % Full
1 MMM-CONTROL M 1 1 100
2 PASSWORDS M 7 6 86
3 PAY-RATES-MSTR M 20,011 5,367 27
4 MASTER-SETS M 31 8 26
5 EMPLOYEES M 6,607 6,513 99
6 ARMS02 M 503 400 80
7 ARMS03 M 1,009 853 85
8 DEVICES M 101 15 15
9 ARMS-TASKS M 101 0 0
10 BADGE-NUM-MSTR A 503 311 62
11 DUMMY-SORT-MSTR A 1 1 100
12 FAC-CODE-MSTR A 211 164 78
13 HELP-KEY-MSTR A 503 191 38
14 DETAIL-SETS-MSTR A 101 37 37
15 ARMS-TASK-MSTR A 351 197 56
16 ALLOWED-USERS D 364 297 82
17 HELP-FILES D 520 191 37
18 FACILITIES D 216 163 75
19 DETAIL-SETS D 112 53 47
20 STOCK-ROOMS D 32 26 81
21 ARMS04 D 4,012 2,083 52
22 SUB-SYSTEMS M 11 8 73
23 FUNCTIONS-MSTR A 211 168 80
24 USER-SEC D 18,584 14,757 79
25 SEC-FUNCTIONS D 556 155 28
26 USER-KEY-MSTR A 101 45 45
27 ACTIVE-USERS D 140 45 32
Enter data set to examine, ? to see all sets:
Bruce A. Randall
Impact Digital Solutions Inc.
130 Bradford St.
San Francisco, Ca. 94110
e-mail:[log in to unmask]
Web: http://www.idswest.com
Voice: 415 642-8015
Fax: 415 282-1947
|