This manual describes the syntax of the commands used with HiRDB Version 9, a nonstop database server program product. For details about prerequisite information that is not provided in this manual, see the manual HiRDB Version 9 Description (3020-6-450).
Intended readers
This manual is intended for users who will be constructing or operating HiRDB Version 9 ("HiRDB") relational database systems.
Readers of this manual must have the following:
The following manuals should be read before reading this manual:
Conventions: Diagrams
This manual uses the following conventions in diagrams:
Conventions: Fonts and symbols
The following table explains the text formatting conventions used in this manual:
Text formatting | Convention |
---|---|
Bold | Bold characters indicate text in a window, other than the window title. Such text includes menus, menu options, buttons, radio box options, or explanatory labels. For example:
|
Italic | Italic characters indicate a placeholder for some actual text to be provided by the user or system. For example:
|
Monospace | Monospace characters indicate text that the user enters without change, or text (such as messages) output by the system. For example:
|
The following table explains the symbols used in this manual:
Symbol | Convention |
---|---|
| | In syntax explanations, a vertical bar separates multiple items, and has the meaning of OR. For example: A|B|C means A, or B, or C. |
{ } | In syntax explanations, curly brackets indicate that only one of the enclosed items is to be selected. For example: {A|B|C} means only one of A, or B, or C. |
[ ] | In syntax explanations, square brackets indicate that the enclosed item or items are optional. For example: [A] means that you can specify A or nothing. [B|C] means that you can specify B, or C, or nothing. |
... | In coding, an ellipsis (...) indicates that one or more lines of coding have been omitted. In syntax explanations, an ellipsis indicates that the immediately preceding item can be repeated as many times as necessary. For example: A, B, B, ... means that, after you specify A, B, you can specify B as many times as necessary. |
() | Parentheses indicate the range of items to which the vertical bar (|) or ellipsis (...) is applicable. |
{{ }} | A double pair of curly brackets encloses multiple items, all of which you can specify multiple times as a unit. Example: {{pdbuffer -a option-name}} This example indicates that you can specify the above multiple times as follows: pdbuffer -a option-name pdbuffer -a option-name |
~ | A swung dash precedes the attributes of a user-specified value. |
<< >> | A double pair of angle brackets encloses the default value assumed by the system when the specification is omitted. |
< > | A single pair of angle brackets encloses the syntax element notation for a user-specified value. |
(( )) | A double pair of parentheses encloses the permitted range of values that can be specified. |
![]() ![]() | Round up the result to the next integer. Example: The result of ![]() ![]() ![]() |
![]() ![]() | Discard digits following the decimal point. Example: The result of ![]() ![]() ![]() |
MAX | Select the largest value as the result. Example: The result of MAX(3 ![]() |
MIN | Select the smallest value as the result. Example: The result of MIN(3 ![]() |
Syntax element conventions
The following table explains the syntactical element symbols used in this manual:
Syntax element notation | Explanation | |
---|---|---|
<alphabetic> | The alphabetic characters (A to Z and a to z) and the underscore (_) | |
<alphabetic symbol> | The alphabetic characters (A to Z and a to z) and the special characters #, @, and \ | |
<alphanumeric> | Alphabetic characters and the numeric digits (0 to 9) | |
<alphanumeric symbol> | Alphabetic symbols and numeric values | |
<unsigned integer> | Numeric value | |
<hexadecimal> | Numeric values and A to F (or a to f) | |
<identifier> | Alphanumeric character string beginning with an alphabetic character | |
<identifier> | For specifying an RDAREA name | Character string consisting of one or more alphanumeric symbols, underscores (_), hyphens (-), and at marks (@) that begins with an alphabetic symbol To include a space in an RDAREA identifier, enclose the entire identifier in double quotation marks ("). |
<identifier> | For specifying a host name | Character string consisting of one or more alphabetic characters (A to Z, a to z), numeric characters, periods (.), hyphens (-), underscores (_), and at marks (@) |
<identifier> | For specifying a global buffer name | Character string consisting of alphanumeric symbols that begins with an alphabetic symbol |
<identifier> | For specifying an in-memory data buffer name | Character string consisting of alphanumeric symbols that begins with an underscore (_) |
<symbolic name> | Character string consisting of alphanumeric symbols that begins with an alphabetic symbol | |
<character string> | String of any characters | |
<path name># | Name consisting of forward slashes (/), alphanumeric characters, periods (.), hash marks (#), and at signs (@) | |
<HiRDB file name> | Character string consisting of one or more alphabetic characters (A to Z, a to z), numeric characters (0 to 9), periods (.), underscores (_), and at marks (@) (maximum 30 characters) |
Conventions in command explanations
This manual explains each command in the format shown as follows; note that this format may differ slightly from one command to another:
Conventions: Version numbers
The version numbers of Hitachi program products are usually written as two sets of two digits each, separated by a hyphen. For example:
The version number might be shown on the spine of a manual as Ver. 2.00, but the same version number would be written in the program as 02-00.
Important notes on this manual
The following facilities are explained, but they are not supported:
The following products and option program products are explained, but they are not supported: