Scalable Database Server, HiRDB Version 8 UAP Development Guide

[Contents][Index][Back][Next]

1.2.1 UAP format

To manipulate a HiRDB database, descriptions in the SQL language are embedded directly into a source program written in a high-level language.

The embedded method involves writing descriptions of a database language called SQL directly into a source program written in a high-level language. If you decide to create an embedded SQL UAP, program analysis becomes easy. All operations including the database operations (SQL) can be written as one program.

ODBC functions can also be specified in a UAP, and UAPs can also be created with JavaTM (SQLJ).

Organization of this subsection
(1) Source program
(2) SQL

(1) Source program

The following high-level languages can be used to write an embedded SQL UAP:

(2) SQL

SQL is a database language for writing the definition, data manipulation, operation, and control instructions of a database. You can use these instructions by embedding them into a source program written in a high-level language. Figure 1-2 shows the SQL functional organization.

Figure 1-2 SQL functional organization

[Figure]

For an overview of the SQL language types and functions for programs, see 1.2.2 List of SQL statements usable in HiRDB. For details about the embedded language, see the manual HiRDB Version 8 SQL Reference.