FORM
MPE documents | |
 Complete PDF | |
| Table of Contents | |
| E0300 Edition 7 ♥ | |
| E1098 Edition 6 |
Syntax
FO[RM] [ [ALL | data base name[:]]
[ITEMS | PATHS | SETS | INDEXES |
data item name | data set name ]]
For example:
>FORM >FO PATHS >FORM PRODUCTWhere data set name = PRODUCT
>FO ACCOUNTWhere data item name =ACCOUNT
Parameters
- ALL
used alone will display the data sets, data items, and path information for every open data base to which you have access. If used with additional FORM parameters, QUERY will display information designated by these parameters for every open data base.
- data base name
is the name of a data base opened with either MULTIDB, DEFINE, or DATA-BASE= commands. If not specified, FORM will use the primary data base currently defined by the DEFINE or DATA-BASE= command. data base name may be used to qualify ALL. data base name must be followed by a colon when qualifying another parameter.
- INDEXES
displays information about the data items linked to Third Party Indexing (TPI) software, if any. See the TPI Vendor's documentation for information.
- ITEMS
lists information about each data item in the data base to which you have access.
- PATHS
lists the relationship between data sets in the data base to which you currently have access.
- SETS
lists information about each data set in the data base to which you have access.
- data item name
is the name of a data item in the data base currently being accessed.
- data set name
is the name of a data set in the data base currently being accessed.
Discussion
FORM provides information about the currently open data base(s). The information contains only the names of data sets and data items to which you have at least read access. No other data sets and data items are listed. If no data base is currently defined, QUERY issues an error message and prompts you for another command. If OUTPUT=TERM, the listing is sent to the standard list device for the job or session. If OUTPUT=LP, the listing is sent to the file named QSLIST. Refer to the OUTPUT= command for more information about QSLIST. Figure 3-1 "FORM ALL INDEXES " through Figure 3-8 "FORM Example" illustrate the output resulting from each FORM command option. If you enter FORM name and name refers to both a data set and a data item, the data set information is listed. If a data set or a data item has the name SETS, ITEMS, INDEXES, or PATHS, it is treated as a keyword parameter when used in a FORM command. Figure 3-1 FORM ALL INDEXES
DATA BASE: TOYDB TUE, NOV 11, 1999, 8:13 AM
DATA BASE LANGUAGE ATTRIBUTE : NATIVE-3000
DATA BASE HAS 3 INDEXED SETS WITH WILDCARD CHARACTER= "~"
NO TPI INDEXES
DATA BASE: TESTDB TUE, NOV 11, 1999, 8:13 AM
TPI INDEXES:
PATH, B6 DETAIL
ITEM1, X2
SISD, B16 ORDER-DETAILS
SHIPDATE X4
PIER X8
Figure 3-2 FORM ITEMS Output
DATA BASE: ORDERS <----- 1 2 -----> TUE, JAN 7, 1986, 11:29 AM
DATA BASE LANGUAGE ATTRIBUTE: NATIVE-3000 <----- 3
ITEMS:
ACCOUNT <----- 4 J2 <----- 5
CITY X12
CREDIT-RATING R2
DATE X6
FIRST-NAME X10
INITIAL U2
LAST-NAME X16
PURCH-DATE X6
STATE X2
STOCK# U8
STREET-ADDRESS X26
TOTAL J2
ZIP X6
Discussion 3-2
Current data base name.
Current date and time.
Language of the data base entries.
Item name.
Item type and length.
DATA BASE: ORDERS TUE, MAR 9, 1987, 11:29 AM
DATA BASE LANGUAGE ATTRIBUTE: NATIVE-3000
PATH IDENTIFYING INFORMATION
ASSOCIATED
MASTER SET NAME DETAIL SET NAME SEARCH SET NAME SORT ITEM NAME
CUSTOMER SALES ACCOUNT PURCH-DATE
DATE-MASTER SALES PURCH-DATE
ASSOCIATED
DETAIL SET NAME SEARCH ITEM NAME SORT ITEM NAME MASTER SET NAME
SALES ACCOUNT PURCH-DATE CUSTOMER
!STOCK#
PURCH-DATE DATE-MASTER
Discussion 3-3
The FORM PATHS command lists the detail data sets associated
with each master data set and the master data sets associated with
each detail data set. It also lists the detail set item which is
used as a key (search item name) and the detail set item which is
used for sorting (if any).
Figure 3-4 FORM SETS Output
DATA BASE: ORDERS TUE, MAR 9, 1987, 11:29 AM
DATA BASE LANGUAGE ATTRIBUTE: NATIVE-3000
ITEM CURRENT ENTRY ENTRY BLOCKING
SETS: TYPE COUNT CAPACITY COUNT LENGTH FACTOR
CUSTOMER M 9 2003 15 41 10
DATE-MASTER A 1 211 18 3 22
SALES D 4 12012 13 19 14
^ ^ ^ ^ ^ ^ ^
| | | | | | |
1 2 3 4 5 6 7
Discussion 3-4
Data set name.
Data set type (M=Master, A=Automatic, D=Detail).
Number of items in each data set entry.
Maximum number of entries each set can contain currently.
Number of entries currently stored in each data set.
Number of computer words per entry.
Maximum number of entries a block can contain.
DATA BASE: ORDERS TUE, MAR 9, 1987, 11:29 AM
DATA BASE LANGUAGE ATTRIBUTE: NATIVE-3000
ITEM NAME:
ACCOUNT J2 <----- 1
IS A MEMBER OF THESE SETS:
CUSTOMER <----- 2
SALES
Discussion 3-5
Data item type.
Data set names.
DATA BASE: ORDERS TUE, MAR 9, 1987, 11:29 AM
DATA BASE LANGUAGE ATTRIBUTE: NATIVE-3000
SET NAME:
CUSTOMER,MANUAL <----- 1
ITEMS:
ACCOUNT, <----- 2 J2 3 -----> <<KEY ITEM>>
LAST-NAME, X16
FIRST-NAME, X10
INITIAL, U2
STREET ADDRESS, X26
CITY, X12
STATE, X2
ZIP, X6
CREDIT-RATING, R2
CAPACITY: 2003 <----- 4 ENTRIES 15 <----- 5
Discussion 3-6
CUSTOMER is a manual master data set.
Data items in the CUSTOMER data set.
ACCOUNT is a key item linked to a detail data set.
Maximum number of entries CUSTOMER can contain.
Number of entries in the data set.
ACCOUNT is a key which links the detail data set SALES to the master data set CUSTOMER. The detail search item is also named ACCOUNT.
DATE is a key item in DATE-MASTER linked to the SALES data set through the search item PURCH-DATE.
PURCH-DATE is also used for sorting.
The SALES data sett can containe at most 12012 entries.
Data set relations.
DATA BASE: ORDERS TUE, MAR 9, 1987, 11:29 AM
DATA BASE LANGUAGE ATTRIBUTE: NATIVE-3000
SET NAME:
CUSTOMER,MANUAL
ITEMS
ACCOUNT, J2 (1) <<KEY ITEM>>
LAST-NAME, X16
FIRST-NAME X10
INITIAL U2
STREET ADDRESS, X26
CITY, X12
STATE X2
ZIP X6
CREDIT-RATING R2
CAPACITY: 2003 ENTRIES 15
SET NAME:
DATE-MASTER,AUTOMATIC
ITEMS:
DATE, X6 (2) <<KEY ITEM>>
CAPACITY: 211 ENTRIES: 18
SET NAME:
SALES,DETAIL
ITEMS:
ACCOUNT, J2 (1) <<SEARCH ITEM>>
STOCK#, U8 <<SEARCH ITEM>>
TOTAL, J2
PURCH-DATE, X6 (2 & 3)<<SEARCH ITEM, SORT ITEM>>
CAPACITY: 12012 (4) ENTIRES 13
PATH IDENTIFYING INFORMATION (5)
ASSOCIATED
MASTER SET NAME DETAIL SET NAME SEARCH SET NAME SORT ITEM NAME
CUSTOMER SALES ACCOUNT PURCH-DATE
DATE-MASTER SALES PURCH-DATE
ASSOCIATED
DETAIL SET NAME SEARCH ITEM NAME SORT ITEM NAME MASTER SET NAME
SALES ACCOUNT PURCH-DATE CUSTOMER
!STOCK#
PURCH-DATE DATE-MASTER
Figure 3-8 shows the messages when B-trees are utilized by a database and the
FORM command is entered. The number of indexed sets, the wildcard
character, the status of the BTREEMODE1 flag when OFF, and the
individual sets and items that have been indexed will be reported as shown.
Figure 3-8 FORM Example
>FORM
DATA BASE: TOYDB MON, MAY 30, 1997, 10:48 AM
DATA BASE LANGUAGE ATTRIBUTE: NATIVE-3000
DATA BASE HAS 2 INDEXED SETS WITH WILDCARD CHARACTER= "~"
WARNING! DATA BASE BTREEMODE1 IS OFF. WILDCARD DISABLED.
SET NAME:
CUSTOMERS,MANUAL/INDEXED
ITEMS:
CUSTOMER-NO, X6 <<KEY,INDEX ITEM>>
CUSTOMER-NAME, X30
CAPACITY: 50 ENTRIES: 8
SET NAME:
ORDER-MASTER,AUTOMATIC/INDEXED
ITEMS:
ORDER-NO, X8 <<KEY,INDEX ITEM>>
CAPACITY: 503 ENTRIES: 16
SET NAME:
INVOICES,DETAIL
ITEMS:
INVOICE-NO, X6
CUSTOMER-NO, X6 <<SEARCH,INDEX ITEM>>
ORDER-NO, X8 <<SEARCH,INDEX ITEM>>
AMOUNT, P12
CAPACITY: 5016 ENTRIES: 5000
MAXIMUM CAPACITY: 5016 INITIAL CAP.: 38 INCREMENT: 38
Dynamic Dataset Capacities
The last line in shows how QUERY reflects the Dynamic Dataset Capacity Expansion capability. When a dataset has utilized the Dynamic Expansion feature, QUERY will display the CURRENT, MAXIMUM, and INITIAL capacities and the INCREMENT amount.
|
FIND procedure |
Chapter 4 QUERY/iX COMMANDS (cont) |