Filter
Top Products
Connection
Connection refers to the relationship that connects a client to a server. A connection is made by specifying a
CONNECT statement in an application program. Conversely, a DISCONNECT statement cuts off the connection.
Cursor
A cursor is an indicator that indicates a row to be manipulated. A cursor is defined by a cursor declaration statement.
The OPEN and CLOSE statements start and stop cursor operations, respectively. The FETCH statement moves the
cursor.
Cursor SQL statement
A cursor SQL statement is a data manipulation SQL statements that uses a cursor to specify rows to be manipulated.
Data manipulation SQL
A data manipulation SQL is an SQL statement used to reference, add, delete, or update a database.
Data part
A constituent element of a storage structure. The data part contains storage data corresponding to the table data
(SEQUENTIAL structure or OBJECT structure) or data made up of index keys and table cluster keys (BTREE
structure).
Related term:
Index part
Data structure instance (DSI)
Expresses the storage structure for a table (base table). In addition to the information expressed in a DSO, a DSI
expresses a mapping to a database space. The relationship between a DSO and a DSI can be one-to-one or
one-to-many. A one-to-many relationship occurs only when a split table operation is applied.
Related terms:
Storage structure, DSO
Database generation
Storing the initial data in empty base tables immediately after database definition. SymfoWARE/RDB utilities are used.
Database name
Many database can be created as units of administration and design on one server system. To identify each database
uniquely, each is assigned a unique name (database name) on the server system.
203