(P)DB_MANAG

COMMAND TYPE : PDB Management

PURPOSE:

To manage the catalogues in a Personal Data Base.

DESCRIPTION:

This command is used to manage the Personal Data Base. The user can insert, modify or delete a catalogue in the PDB. When the user has inserted a catalogue the new catalogue is available to the DIRA system.

There are three types of items that give the complete information of a catalogue: the catalogue items, the fields items and the documentation items. These are in three different DIRA system files (see chapter on system files) that are managed by the DB_MANAG.

The task allows to access all the items of the PDB system files. All the data are shown by masks on the screen and the user can move the cursor (by arrows) inside the fields of the mask, fill and modify the fields. Control Key allows to move to next mask (CTRL-V) or backward to the (CTRL-W)

A catalogue can be inserted in the PDB using this task or by DB_INSTAB or DB_FROMFT command. We suggest the use of this command after the catalogue insertion to verify the data coherence.

The COMMANDS:

INSERT

With this command the user inserts a new catalogue in the PDB or a new variable (a new field) in an existing catalogue. The name of a catalogue is an alphanumerical string of 12 or less characters that don't contains special symbols. All the alphabetic characters are translated in uppercase. The user must enter the name of the new catalogue and the number of fields; then the user must specify all the catalogue items, the fields items and documentation items. (See the System Files chapter for more details)

The command can be used in three ways:

INSERT Asks for name and number of fields
INSERT 'cat' Asks for number of variables
INSERT 'cat' VAR 'var'  Add the variable var to the cat

The name of a catalogue and the number of fields can not be modified in the mask of the catalogue items. Moreover, the user can add a new field to an existing catalogue with the insert command. (i.e. if the user needs to add the field ALFA at the existing catalogue OLDCAT he must enter: INSERT OLDCAT VAR ALFA).

MODIFY

This command allows to modify catalogues and fields items of an existing catalogue. If the user do not remember the right name of a catalogue he can enter the MODIFY command without parameters and a list of all the catalogue will be shown; he can move the cursor (by arrows) on the desired name and confirm with the RETURN or ENTER key.

Modifying a catalogue, the mask of the catalogue items is shown first, then the masks of the fields items (a mask for field), then the mask of the documentation. The user can directly access the mask of a given field or the mask of the documentation.

The command can be used in four ways:

MODIFY  Selects on the list of existing cat
MODIFY 'cat'  Modifies catalogue 'cat'
MODIFY 'cat' VAR 'var'  Modifies field 'var' of 'cat'
MODIFY 'cat' DOC  Modifies documentation items of 'cat'

The name of the catalogues and the number of the fields can not be modified with this command. Use INSERT or DELETE to add or remove a field in an existing catalogue.

See the System Files chapter for more details on how to modify the masks values.

DELETE

This command allows to delete a catalogue or a catalogue field from an existing catalogue. If the user doesn't remember the right name of a catalogue he can enter the DELETE command without parameters and a list of all the catalogue will be shown; he can move the cursor (by arrows) on the desired name and confirm with the RETURN or ENTER key.

The command can be used in four ways:

DELETE  Selects on the list of existing cat
DELETE 'cat'  Deletes catalogue 'cat'
DELETE 'cat' VAR  Selects on a list of existing fiels
DELETE 'cat' VAR 'var'  Deletes field 'var' of catalogue 'cat'

When a catalogue (or a field) is deleted it is not erased from the system files, but is flagged only. With the RESTORE command a deleted catalogue (or field) can be resumed. The PDB_PACK command removes definitely the deleted catalogues and fields.

RESTORE

The catalogues and the fields deleted can be resumed with this command. The user can have the names of the deleted catalogue entering a RESTORE command without parameters. He can have the name of the deleted fields of a catalogues entering RESTORE 'cat' VAR, where 'cat' is the name of an existing catalogue. Then a list of all the catalogues (fields) will be shown; and he can move the cursor (by arrows) on the desired name and confirm with the CR or ENTER key.

The command can be used in four ways:

RESTORE  Selects on the list of deleted cat
RESTORE 'cat'  Restores catalogue 'cat'
RESTORE 'cat' VAR  Selects on a list of deleted fields
RESTORE 'cat' VAR 'var'  Restores field 'var' of catalogue 'cat'

LIST

Prints, on the file DIRACAT.LIS, a working list of the catalogues and fields items. Use the DB_INFO command to have more explanatory lists. The user can have the list of a catalogue or the list of all the catalogues. If the user doesn't remember the right name of a catalogue he can enter the LIST command without parameters and a list of all the catalogues will be shown; he can move the cursor (by arrows) on the desired name and confirm with the RETURN or ENTER key.

The command can be used in four ways:

LIST  Select on the list of deleted cat
LIST 'cat'  Complete list catalogue 'cat'
LIST *  Short list of all the catalogues
LIST * ALL  Complete list of all the catalogues

EXIT

Exits from this task



Previous: PDB_INFO
Up: Commands
Next: PDB_PACK
Previous Page: PDB_INFO
Next Page: PDB_PACK