About This Document

Intended Audience

This guide is intended for database users who want a reference for the Structured Query Language (SQL), which is required to perform database tasks or develop application programs using Tibero ® (hereafter Tibero).

SQL provided by Tibero supports parts of the SQL-92 and SQL-99 standards, which were coestablished by the American National Standards Institute (ANSI) and the International Organization for Standardization/International Electrotechnical Commission (ISO/IEC).

Required Knowledge

This guide describes SQL statements needed to manage information in Tibero. The user must have knowledge of the following in order to understand this guide:

Document Scope

This guide does not contain all the information required to operate Tibero . For information related to installation, configuration, operation and management, refer to each relevant guide.

Note

For more information about Tiberoinstallation and configuration, refer to Tibero Installation Guide.

Document Organization

This guide consists of 9 chapters and 1 appendix.

Descriptions for each are as follows:

Conventions

ConventionMeaning
<AaBbCc123>Program source code file name
<Ctrl>+CHold down the Ctrl key and press the C key
[Button] Name of a GUI button or menu
Bold Emphasis
Italics Reference to another guide
" " (Double quotation marks)Reference to a chapter or section in this or another guide
'Input' User input on the screen
Email account, website, or a reference to other chapters or sections
>Proceeding order of menu
+----Files or directories exist in this directory
|----Files or directories do not exist in this directory

Note

Reference or caution
[Figure 1.1] Figure caption
 AaBbCc123
Commands, screen output after executing command, or sample code
{ }Required items
[ ]Optional items
|Selective items

Revision History

VersionDescription
v2.1.7.4
v2.1.7.3
v2.1.7.2
  
  
  
  
  
  
  
  

System Requirements

 Requirements
PlatformHP-UX 11i (IA64)
Solaris (Solaris 10)
AIX (PPC 5L/AIX 5.3)
GNU (X86, 64, IA64)
Linux kernel 2.6 or later
Windows (x86) 32-bit/64-bit
HardwareAt least 2.5 GB hard disk space
More than 1 GB RAM
CompilerPSM (C99 support needed)
tbESQL/C (C99 support needed)

Related Documents

DocumentDescription

Tibero

Installation Guide

Describes the system requirements and specific methods for installation and uninstallation.

Tibero

tbCLI Guide

Describes the tbCLI (Call Level Interface) concepts, components and program structure, as well as data types, functions, and error messages needed to write tbCLI applications.

Tibero

Application Developer's Guide

Describes how to develop application programs by using application libraries.

Tibero

External Procedure Guide

Describes how to create and use external procedures.

Tibero

JDBC Developer's Guide

Describes how to develop application programs by using the JDBC functions provided in Tibero.

Tibero

tbESQL/C Guide

Describes how to create various database application programs in the C programming language.

Tibero

tbESQL/COBOL Guide

Describes how to create various database application programs in the C programming language.

Tibero

tbPSM Guide

Introduces the concepts, syntax, and components of tbPSM (Procedure Storage Module). This guide also describes how to execute the control structure, complex type, sub programs, packages, and SQL statements required for creating a tbPSM program and to handle any errors.

Tibero

tbPSM Reference Guide

Introduces the tbPSM package, a storage procedure module. This guide also describes the prototypes, parameters, and examples of each procedure and function included in this package.

Tibero

Administrator's Guide

Describes how to manage Tibero in order to guarantee smooth operation. This guide also describes the various functions that support management.

Tibero

Utility Guide

Describes how to install, use, and configure the utilities that handle database related operations.

Tibero

TAS Guide

Describes how to manage files in Tibero Active Storage (TAS).

Tibero

Error Reference Guide

Describes troubleshooting methods for various errors that may occur while using Tibero.

Tibero

Reference Guide

Describes the initialization parameters, data dictionary, and static and dynamic views used by Tibero.

Tibero

SQL Reference Guide

Describes the SQL statements required for creating application programs or operating a database.

Tibero

Spatial Reference Guide

Describes the geometry type and spatial procedures and functions of Tibero and how to use them.

Tibero

TEXT Reference Guide

Describes how to create and use the text index provided by Tibero.