 |
» |
|
|
|
|  | |
Lists information about data bases currently being accessed. Syntax | |
FO[RM] [ [ALL
data base name[:] ] [ITEMS
PATHS
SETS
data item name
data set name ] ]
|
For example:
>FORM
>FO PATHS
>FORM PRODUCT
|
Where data set name = PRODUCT Where 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. - 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 ITEMS Output” through Figure 3-6 “FORM Output” 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, or PATHS, it is treated as a keyword parameter when used in a FORM command. Figure 3-1 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-1 Language of the data base entries.
Figure 3-2 FORM PATHS Output
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-2 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-3 FORM SETS Output
DATA BASE: ORDERS TUE, MAR 9, 1987, 11:29 AM
DATA BASE LANGUAGE ATTRIBUTE: NATIVE-3000
ITEM 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-3 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. Number of entries currently stored in each data set. Number of computer words per entry. Maximum number of entries a block can contain.
Figure 3-4 FORM data item name Output
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-4 Data item type. Data set names.
Figure 3-5 FORM data set name Output
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-5 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.
Discussion 3-6 (figure follows) ACCOUNT is a key which links the detail data set SALES to the master data set CUSTOMER. The detail search item is 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 set can contain at most 12012 entries. Data set relations.
Figure 3-6 FORM Output
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 ENTRIES: 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
|
|
