Introduction to Data Management

Accessing Databases With NonStop SQL
3-14 15873 Tandem Computers Incorporated
Figure 3-7. Output from the Report Writer
Business Administration Students
Student Name ID No.
_________________________ ______
Audrey Brown 2761
Rodney Carey 1654
Robert Colvin 3476
Carol Dooley 2003
Stephanie Duncan 1764
Samuel Edison 2002
Douglas Eliot 2009
Lana Fong 1777
April Fowler 1642
. . .
. . .
. . .
Modifying Data
You can use SQLCI to interactively insert, update, or delete data in the database.
Again, in each case, you use a very simple statement that specifies the columns you
want to access or change, and the values you wish these columns to have.
In most cases, however, business professionals modify data indirectly by running
programs written for them by application programmers, rather than by using SQLCI.
For large updates involving many rows, this is usually both more convenient and
safer.
Defining and
Administering Data
If you are a database administrator, you must define and create the database and its
dictionary, and maintain those items as the needs of the system grow.
The dictionary describes the structure of your database. The dictionary applies
whether the database is small or large and whether the database serves a simple set of
local applications or many applications distributed throughout a network. The
dictionary defines all objects such as tables, views, and columns contained in your
database. The dictionary also describes indexes to tables, partitions, programs that
access the database, constraints on data values, text associated with data descriptions,
and other information.