About This Manual

This manual explains the concepts, components, and basic use of Altibase

Audience

This manual has been prepared for the following Altibase users:

• Database managers
• Performance managers
• Database users
• Application developers
• Technical support engineers

It is recommended for those reading this manual possess the following background knowledge:

• Basic knowledge in the use of computers, operating systems, and operating system utilities
• Experience in using relational databases and understanding of database concepts
• Computer programming experience
• Experience in database server management, operating system management, or network administration

Organization

This manual has been organized as follows:

• Chapter 1. Data Types

  This chapter explains the data types that are supported in Altibase.

• Chapter 2. Altibase Properties

  This chapter explains the Altibase properties.

• Chapter 3. The Data Dictionary

  This chapter describes the specification of the Altibase data dictionary. The data dictionary of Altibase consists of meta tables, in which information about objects is stored, and the process tables, in which information about processes is stored.

• Chapter 4. Sample Schema

  This chapter provides information on the sample tables and the ER diagram.

Documentation Conventions

This section describes the conventions used in this manual. Understanding these conventions will make it easier to find information in this manual and other manuals in the series.

There are two sets of conventions:

• Syntax diagrams
• Sample code conventions

Syntax diagrams

This manual describes command syntax using diagrams composed of the following elements:

Elements	Meaning
	Indicates the start of a command. If a syntactic element starts with an arrow, it is not a complete command.
	Indicates that the command continues to the next line. If a syntactic element ends with this symbol, it is not a complete command.
	Indicates that the command continues from the previous line. If a syntactic element starts with this symbol, it is not a complete command.
	Indicates the end of a statement.
	Indicates a mandatory element.
	Indicates an optional element.
	Indicates a mandatory element comprised of options. One, and only one, option must be specified.
	Indicates an optional element comprised of options
	Indicates an optional element in which multiple elements may be specified. A comma must precede all but the first element.

Sample Code Conventions

The code examples explain SQL, stored procedures, iSQL, and other command line syntax.

The following describes the conventions used in the code examples:

Rules	Meaning	<Example>
[ ]	Indicates an optional item	VARCHAR [(size)] [[FIXED |] VARIABLE]
{ }	Indicates a mandatory field for which one or more items must be selected.	{ ENABLE | DISABLE | COMPILE }
|	A delimiter between optional or mandatory arguments.	{ ENABLE | DISABLE | COMPILE } [ ENABLE | DISABLE | COMPILE ]
. . .	Indicates that the previous argument is repeated, or that sample code has been omitted.	iSQL> SELECT e_lastname FROM employees; E_LASTNAME ------------------------ Moon Davenport Kobain . . . 20 rows selected.
Other Symbols	Symbols other than those shown above are part of the actual code.	EXEC :p1 := 1; acc NUMBER(11,2)
Italics	Statement elements in italics indicate variables and special values specified by the user.	SELECT * FROM table_name; CONNECT userID/password;
Lower case words	Indicate program elements set by the user, such as table names, column names, file names, etc.	SELECT ename FROM employee;
Upper case words	Keywords and all elements provided by the system appear in upper case.	DESC SYSTEM.SYS_INDICES;

Related Documents

For more detailed information, please refer to the following documents:

• Installation Guide
• Getting Started Guide
• Administrator's Manual
• Replication Manual

Altibase Welcomes Your Comments and Feedbacks

We welcome your feedback on this manual. Your input is valuable in helping us improve future versions of the manual.

If you find any errors, omissions, or other technical issues in the Altibase manual, please report them through the Customer Service Portal, and we will address them with care. For immediate assistance with technical matters, you may also request support through the Technical Support Portal.

Thank you for your continued interest and valuable feedback.