External Procedure

Overview

This guide is intended for database administrators (DBA) who choose to refer to tbPSM, the persistent stored module provided by Tibero® (Tibero), and application program developers.

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.

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

Required Knowledge

• Database

• RDBMS

• SQL

• tbPSM

System Requirements

.	Requirements
Platform	HP-UX 11i v3(11.31)
	Solaris (Solaris 11)
	AIX (AIX 7.1/AIX 7.2/AIX 7.3)
	GNU (X86, 64, IA64)
	Red Hat Enterprise Linux 7 kernel 3.10.0 or later
	Windows(x86) 64bit
Hardware	At least 2.5GB hard disk space
	More than 1 GB RAM
Compiler	PSM (C99 support needed)
	tbESQL/C (C99 support needed)

Document Organization

The guide contains 8 chapters.

Introduction to External Procedures

Describes the basic concept and the types of external procedure.

🔎 Go to Introduction to External Procedures

C External Procedures

Describes the features and the execution of the C external procedure.

🔎 Go to C External Procedures

Creating C External Procedures

Describes how to specify the basic environment variables to create C external procedures, and the actual steps to create the C external procedures.

🔎 Go to Creating C External Procedures

Executing C External Procedures

Describes how to map a PSM and a C parameter in C external procedure, and how to use the callback service.

🔎 Go to Executing C External Procedures

C External Procedure Utility

Describes the C external procedure utility used to create the functions of a user shared library.

🔎 Go to C External Procedure Utility

Java External Procedures

Describes the basic concept, main features, and executions of the Java External Procedure.

🔎 Go to Java External Procedures

Creating Java External Procedures

Describes how to specify the basic environment variables to create Java external procedures, and the actual steps to create the Java external procedures.

🔎 Go to Creating Java External Procedures

Executing Java External Procedures

Describes how to create Java application programs using Java external procedures, and how to use the internal JDBC driver.

🔎 Go to Executing Java External Procedures