Download User Manual

Form Command [FO]
The Form command displays a description of the items and datasets in a database. It
is similar in format to the FORM command of QUERY.
FORM [ SETS | ITEMS | PATHS
dataset | data-item | filename ]
(Default: fields in current dataset)
If you request information about a specific detail dataset, Suprtool will print the path
information in DBSCHEMA format. The path shows the related master dataset and
the sort item-name. The capacity is also shown in DBSCHEMA format. The
blocking factor appears after the capacity in parentheses. If dynamic dataset
expansion (a feature of MPE/iX 5.0) has been enabled, the initial capacity and the
increment are shown next. On MPE/iX 5.0 or later, the highwater mark is shown.
The record length in bytes appears last.
When showing the form of a dataset, Dbedit shows the byte offset of each field after
the subcount, type, and sublength. The first field always appears at offset one. If you
have specified a date format or the number of implied decimal points with the Item
command, these attributes will appear as part of the form listing.
The QUERY ALL option is not supported.
Example
>base store,5
>item last-ship-date,date
,yymmdd
>item unit-cost
,decimal,2
>edit
{enter Dbedit}
#form d-inventory
D-INVENTORY
Detail
Entry:
BIN-NO
J1
1
LAST-SHIP-DATE
J2
3
<<YYMMDD>>
ON-HAND-QTY
J2
7
PRODUCT-NO
Z8
11 (M-PRODUCT)
SUPPLIER-NAME
X16 19 (!M-SUPPLIER)
UNIT-COST
P8
35
<< .2 >>
Capacity: 112 Entries: 3 Entry Length: 19 Blocking: 14
Formout File
The Form command writes all output to the file Formout. This file defaults to
$stdlist. You can redirect this file to a line printer or a disc drive. If you redirect the
Formout file to a disc file, Suprtool assumes a temporary file by default.
>:file formout;dev=lp
>form sets
>:file formout;dev=disc
>form d-inventory
{writes to line printer}
{writes to temporary file}
Form Keywords
The Form command shows Items, Paths, and Sets before searching for a dataset or
file with these names. Use a string (e.g., "sets") to display the form of a dataset or
file that matches one of the Form keywords.
>form "paths"
Suprtool 4.4 for HP e3000: Database Editing
Dbedit Commands • 317