HP 3000 Manuals HP 3000 Manuals
FORM
Lists information about data bases currently being accessed.
Syntax
[ [ITEMS ]]
[[ALL ] [PATHS ]]
FO[RM] [[data base name[:]] [SETS ]]
[ [data item name]]
[ [data set name ]]
For example:
>FORM
>FO PATHS
>FORM PRODUCT
Where data set name = PRODUCT
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 through Figure 3-6 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.
______________________________________________________________________________
| |
| DATA BASE: ORDERS <--1 2--> TUE, MAR 9, 1987, 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 |
______________________________________________________________________________
Figure 3-1. FORM ITEMS Output
Discussion 3-1
1. Current data base name.
2. Current date and time.
3. Language of the data base entries.
4. Item name.
5. 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 |
__________________________________________________________________________________
Figure 3-2. FORM PATHS Output
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).
__________________________________________________________________________________
| |
| 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 |
__________________________________________________________________________________
Figure 3-3. FORM SETS Output
Discussion 3-3
1. Data set name.
2. Data set type (M=Master, A=Automatic, D=Detail).
3. Number of items in each data set entry.
4. Maximum number of entries each set can contain.
5. Number of entries currently stored in each data set.
6. Number of computer words per entry.
7. 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 |
__________________________________________________________________________________
Figure 3-4. FORM data item name Output
Discussion 3-4
1. Data item type.
2. 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 |
__________________________________________________________________________________
Figure 3-5. FORM data set name Output
Discussion 3-5
1. CUSTOMER is a manual master data set.
2. Data items in the CUSTOMER data set.
3. ACCOUNT is a key item linked to a detail data set.
4. Maximum number of entries CUSTOMER can contain.
5. Number of entries in the data set.
Discussion 3-6
1. 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.
2. DATE is a key item in DATE-MASTER linked to the SALES data set
through the search item PURCH-DATE.
3. PURCH-DATE is also used for sorting.
4. The SALES data set can contain at most 12012 entries.
5. 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 IT |
| 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 |
___________________________________________________________________________________
Figure 3-6. FORM Output