Dictionary/3000 Reference Manual (32244-90001)

30 Chapter3
Using the DICTDBM Commands
Using Commands to Define a Database
Adding Data Elements to Data Sets
The ADD command is used to associate the data elements with the data sets. Use the
command string ADD FILE to define this association. An entry is defined that associates
an element with a data set. Elements may not be associated with a BASE file directly.
DICTDBM will not accept such an entry and will issue an error message.
To display the association entries, use either the REPORT or SHOW commands. The
SHOW command uses an asterisk to indicate which element is the key element in the file
and to display the elements in the order in which they are associated with the file.
To delete an association entry, use the DELETE command. To change an association entry,
use the UPDATE command. To change the physical order in which the elements are
associated to the data set, use the RESEQUENCE command.
Securing a Database
The security that may be defined is the same security defined for an IMAGE database.
IMAGE allows the database designer to control access to specific data sets and data items
by defining up to 63 user classes. The classes are associated with data sets and data items
in read or write class lists. This association determines which user classes may access
which data elements and the type of access that is granted. For a complete description of
how to protect an IMAGE database, see the IMAGE/3000 Reference Manual.
In the Dictionary, user security classes are identified by an integer from 0 through 9999
and are associated with a password defined by the database designer. Each security class
number is unique and can be created only once.
When the Dictionary/3000 Database Creation utility program (DICTDBC) is used to create
the database, the security class numbers are reassigned by the utility to conform to the
numbering scheme used in IMAGE. The CREATE command must be used to define a user
security class entry. You use the command string CREATE CLASS for this entry. During
the command cycle, the prompt RESTRICT CLASS TO A FILE (N/Y) is issued which
allows you to restrict the use of the class to a particular database. You may choose to
respond Y to this prompt if the sets and elements you will add to this class belong to more
than one database but you want DICTDBC to include this class in the schema of only one
database. When DICTDBC retrieves the security classes associated with the sets and
elements of a database for which it is to generate a schema, it will skip those classes
restricted to another database.
After creating user security classes, either the LIST or DISPLAY command can be used to
display the entry. If you want to delete an entry from the Dictionary, use the PURGE
command. To change the entry, use either the MODIFY command or the RENAME
command.
The association between the security classes and the data sets or the elements is
established using either the SECURE or ADD command. The SECURE FILE and ADD
CLASS command strings allow you to specify protection at the element level, while ADD
CLASS-FILE specifies protection at the file level.
SECURE FILE is used to specify protection that applies to all the data elements in the file.
In this way, it is similar to using repeated ADD CLASS command strings. SECURE FILE
can also be used to specify protection for the file itself.