Nonstop Database, HiRDB Version 9 UAP Development Guide
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).
The following high-level languages can be used to write an embedded SQL UAP:
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. The following figure shows the SQL functional organization.
Figure 1-2 SQL functional organization
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 9 SQL Reference.
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.