Skip to content
Altibase 7.3 Documentation
5. Other Utilities
Altibase 8.1
Altibase 7.3
Altibase 7.1
Altibase Sharding 3
한국어
English
Initializing search
Home
Getting Started
Administrator
Reference
Developer
Tools
External Tools
≡
Administrator
Getting Started Guide
Installation Guide
Administrator's Manual
Replication Manual
DB Link User's Manual
Altibase SSL/TLS User's Guide
Performance Tuning Guide
SNMP Agent Guide
Reference
General Reference
SQL Reference
Spatial SQL Reference
Error Message Reference
Developer
Stored Procedures Manual
C/C++ External Procedures Manual
Precompiler User's Manual
CLI User's Manual
ODBC User's Manual
JDBC User's Manual
API User's Manual
Altibase C Interface Manual
Log Analyzer User's Manual
Monitoring API Developer's Guide
Tools
iSQL User's Manual
iLoader User's Manual
Utilities Manual
External Tools
Adapter for JDBC User's Manual
Adapter for Oracle User's Manual
Altibase 3rd Party Connector Guide
Altibase Heartbeat User's Guide
Altibase Hadoop Connector User's Manual
Migration Center User's Manual
Replication Manager User's Manual
altiShapeLoader User's Manual
dataCompJ User's Manual
Altibase 7.3 Documentation
Home
Getting Started
Getting Started
Getting Started Guide
Getting Started Guide
About This Manual
1. Altibase Installation
2. Startup and Shutdown Altibase
3. Working with Altibase
4. DB Objects and Privileges
5. Multilingual Features
6. Database Replication
7. Fail-Over
8. Backup and Recovery
9. Developing Altibase Applications
Installation Guide
Installation Guide
About This Manual
1. About the Altibase Package Installer
2. Installing Products with the Altibase Package Installer
2. Installing Products with the Altibase Package Installer
System Requirements
Supported Platforms
Altibase Package Installer
Installing Altibase Products
Installing Altibase Client Products
3. Uninstalling Altibase and Meta Downgrade
4. Patching Products With the Altibase Package Installer
Appendix A. Installation Prerequisites
Appendix B. Configuring MAC Addresses in a Kubernetes Environment
Administrator
Administrator
Administrator's Manual
Administrator's Manual
About This Manual
1. Introduction
2. Altibase Components
3. Creating a Database
4. Startup and Shutdown
5. Objects and Privileges
6. Managing Tablespaces
6. Managing Tablespaces
Tablespaces Definition and Structure
Classifying Tablespaces
Disk Tablespace
The Undo Tablespace
Tablespace States
Managing Tablespaces
Examples of Tablespace Use
Managing-Space in Tablespaces
7. Partitioned Objects
8. Managing Transactions
9. Database Buffer Manager
10. Backup and Recovery
11. Incremental Backup and Recovery
12. Communication Layer
13. Securing Data
14. Database Auditing
15. Tuning Altibase
16. DB Diagnostic Monitoring
Appendix A. Trace Logs
Appendix B. Altibase Limitations
Replication Manual
Replication Manual
About This Manual
1. Replication Overview
2. Managing Replication
3. How to Use Replication
4. Executing DDL Statements in a Replication Environment
5. Executing DDL Synchronization
6. Fail-Over
7. Sequence Replication
8. ROLE
Appendix A. FAQ
Appendix B. Standard DDL Execution Procedure
Appendix C. SQL Apply Mode
Performance Tuning Guide
Performance Tuning Guide
About This Manual
1. Introduction to Performance Tuning
2. Altibase Server Tuning
3. The Query Optimizer
4. The Explain Plan
5. The Optimizer and Statistics
6. SQL Hints
7. SQL Plan Cache
DB Link User's Manual
DB Link User's Manual
About This Manual
1. Introduction to Database Link
2. Supported Objects, SQL Statements, and Data Types
3. Configuration of Database Link
4. Database Link-Related SQL Statements
4. Database Link-Related SQL Statements
CREATE DATABASE LINK
DROP DATABASE LINK
ALTER DATABASE LINKER
ALTER SESSION
SELECT
REMOTE_EXECUTE_IMMEDIATE
REMOTE Functions Supportive of Binding
REMOTE functions Supportive of Batch
COMMIT FORCE DATABASE LINK
ROLLBACK FORCE DATABASE LINK
Appendix A. Properties and Data Dictionary
Altibase SSL TLS User's Guide
Altibase SSL TLS User's Guide
About This Manual
1. Introduction to Altibase SSL/TLS
2. Installing and Starting SSL in Altibase
3. Managing SSL Connections
Appendix A: SSL Sample
SNMP Agent Guide
SNMP Agent Guide
About This Manual
1. Introduction to SNMP
2. Installing the SNMP Agent
3. How to Use SNMP
4. Checking and Changing Properties
5. Checking the Altibase Status
6. Traps
Appendix A. ALTIBASE-MIB
Appendix B. Troubleshooting
Reference
Reference
General Reference
General Reference
About This Manual
1. Data Types
1. Data Types
Character Data Types
Numeric Data Types
Date Data Type
Binary Types
LOB Data Type
Spatial Types
2. Altibase Properties
2. Altibase Properties
Database Initialization Properties
Performance Properties
Session Properties
Time-out Properties
Transaction Properties
Backup and Recovery Properties
Replication Properties
Network and Security Properties
Message Logging Properties
Database Link Properties
Auditing Properties
C/C++ External Procedure Agent Properties
Account Security Properties
Other Properties
3. The Data Dictionary
3. The Data Dictionary
Meta Tables
Performance Views
4. Sample Schema
4. Sample Schema
Information about the Sample Schema
E-R Entity-Relationship (ER) Diagram and Sample Data
SQL Reference
SQL Reference
About This Manual
1. Introduction to Altibase SQL
2. Altibase SQL Basics
3. Data Definition Language
3. Data Definition Language
ALTER DATABASE LINKER
ALTER DATABASE
ALTER INDEX
ALTER JOB
ALTER MATERIALIZED VIEW
ALTER QUEUE
ALTER REPLICATION
ALTER SEQUENCE
ALTER TABLE
ALTER TABLESPACE
ALTER TRIGGER
ALTER USER
ALTER VIEW
COMMENT
CONJOIN TABLE
CREATE DATABASE LINK
CREATE DATABASE
CREATE DIRECTORY
CREATE DISK TABLESPACE
CREATE INDEX
CREATE JOB
CREATE MATERIALIZED VIEW
CREATE MEMORY TABLESPACE
CREATE QUEUE
CREATE REPLICATION
CREATE ROLE
CREATE SEQUENCE
CREATE SYNONYM
CREATE TABLE
CREATE TEMPORARY TABLESPACE
CREATE TRIGGER
CREATE USER
CREATE VIEW
CREATE VOLATILE TABLESPACE
DISJOIN TABLE
DROP DATABASE LINK
DROP DATABASE
DROP DIRECTORY
DROP INDEX
DROP JOB
DROP MATERIALIZED VIEW
DROP QUEUE
DROP REPLICATION
DROP ROLE
DROP SEQUENCE
DROP SYNONYM
DROP TABLE
DROP TABLESPACE
DROP TRIGGER
DROP USER
DROP VIEW
FLASHBACK TABLE
GRANT
PURGE TABLE
RENAME TABLE
REVOKE
TRUNCATE TABLE
4. Data Manipulation Language
4. Data Manipulation Language
DELETE
DEQUEUE
ENQUEUE
INSERT
LOCK TABLE
MERGE
MOVE
SELECT
UPDATE
5. Data Control Language
5. Data Control Language
ALTER REPLICATION
ALTER SESSION
ALTER SYSTEM
AUDIT
COMMIT
DELAUDIT
NOAUDIT
ROLLBACK
SAVEPOINT
SET TRANSACTION
6. Set Operators
7. SQL Functions
7. SQL Functions
Aggregate Functions
Window(Analytic) Functions
Numeric Functions
Character Functions
Datetime Functions
Conversion Functions
Encryption Functions
Other Functions
8. Arithmetic Operators
9. SQL Conditions
Appendix A. Regular Expressions
Spatial SQL Reference
Spatial SQL Reference
About This Manual
1. Overview of Spatial Data
2. Spatial SQL
3. Spatial Application Development
4. Spatial Data Migration
Appendix A. Limitations on the Use of Spatial Data in Altiabase
Appendix B. Spatial Schema
Appendix C. Geometry Reference Tables
Error Message Reference
Error Message Reference
About This Manual
1. ID Error Code
2. SM Error Code
3. MT Error Code
4. RP Error Code
5. QP Error Code
6. ST Error Code
7. MM Error Code
8. ODBC Error Code
9. APRE Error Code
10. Utilities Error Code
11. CM Error Code
12. Database Link Error Code
13. Log Analyzer Error Code
Developer
Developer
Stored Procedures Manual
Stored Procedures Manual
About This Manual
1. Introduction to Stored Procedures
2. SQL Statements for Managing Stored Procedures
3. Stored Procedure Blocks
4. Control Flow Statement
5. Using Cursors
6. User-Defined Types
7. Typesets
8. Dynamic SQL
9. Exception Handlers
10. Pragma
11. Stored Packages
12. Altibase Stored Procedures and Built-in Functions
13. Altibase Stored Packages
13. Altibase Stored Packages
System-defined Stored Packages
DBMS ALERT
DBMS APPLICATION INFO
DBMS CONCURRENT EXEC
DBMS LOCK
DBMS METADATA
DBMS OUTPUT
DBMS RANDOM
DBMS RECYCLEBIN
DBMS SQL
DBMS SQL PLAN CACHE
DBMS STANDARD
DBMS STATS
DBMS UTILITY
STANDARD
SYS SPATIAL
UTL COPYSWAP
UTL FILE
UTL RAW
UTL SMTP
UTL TCP
Appendix A. Examples
C/C++ External Procedures Manual
C/C++ External Procedures Manual
About This Manual
1. Introduction
2. How to Use External Procedures
3. SQL Statements for External Procedures
Precompiler User's Manual
Precompiler User's Manual
About This Manual
1. The C/C++ Precompiler
2. Host Variables and Indicator Variables
3. Host Variable Declaration Section
4. C Preprocessor
5. Host Variable Data Types
6. Embedded SQL Statements
7. Handling Runtime Errors
8. Using Cursor
9. Using Arrays in Embedded SQL Statements
10. Dynamic SQL Statements
11. Using Stored Procedures in C/C++
12. Applications with Multiple Database Connections
13. Multithreaded Applications
14. Error Codes and Messages
Appendix A. Using Files and LOBs
Appendix B. Porting Pro*C Applications to APRE
Appendix C. The Method 4 of Dynamic SQL
Appendix D. Sample Applications
Appendix E. Precompiler FAQ
CLI User's Manual
CLI User's Manual
About This Manual
1. Altibase CLI Introduction
2. Altibase CLI Functions
2. Altibase CLI Functions
Altibase CLI API
SQLAllocConnect
SQLAllocEnv
SQLAllocHandle
SQLAllocStmt
SQLBindCol
SQLBindParameter
SQLBulkOperations
SQLCancel
SQLCloseCursor
SQLColAttribute
SQLColumns
SQLConnect
SQLDescribeCol
SQLDescribeParam
SQLDisconnect
SQLDriverConnect
SQLEndTran
SQLError
SQLExecDirect
SQLExecute
SQLFetch
SQLFetchScroll
SQLForeignKeys
SQLFreeConnect
SQLFreeEnv
SQLFreeHandle
SQLFreeStmt
SQLGetConnectAttr
SQLGetData
SQLGetDescField
SQLGetDescRec
SQLGetDiagField
SQLGetDiagRec
SQLGetEnvAttr
SQLGetFunctions
SQLGetInfo
SQLGetPlan
SQLGetStmtAttr
SQLGetTypeInfo
SQLMoreResults
SQLNativeSql
SQLNumParams
SQLNumResultCols
SQLParamData
SQLPrepare
SQLPrimaryKeys
SQLProcedureColumns
SQLProcedures
SQLPutData
SQLRowCount
SQLSetConnectAttr
SQLSetDescField
SQLSetEnvAttr
SQLSetPos
SQLSetStmtAttr
SQLSpecialColumns
SQLStatistics
SQLTablePrivileges
SQLTables
SQLTransact
3. LOB Interface
3. LOB Interface
LOB Handling Methods
LOB data types
LOB Function Overview
SQLBindFileToCol
SQLBindFileToParam
SQLFreeLob
SQLGetLob
SQLGetLobLength
SQLPutLob
SQLTrimLob
4. Using Cursors
Appendix A. Sample Codes
Appendix B. Data Types
Appendix C. Error Codes
Appendix D. Upgrade
ODBC User's Manual
ODBC User's Manual
About This Manual
1. Introduction
2. Installing and Configuring the Altibase ODBC Driver
3. ODBC Programming
JDBC User's Manual
JDBC User's Manual
About This Manual
1. Starting JDBC
2. Basic Functions
3. Advanced Functions
3. Advanced Functions
Auto-generated Keys
Timeout
DataSource
Connection Pool
Multiple ResultSet
JDBC와 Failover
JDBC Escapes
How to Use ResultSet
Atomic Batch
Date, Time, Timestamp
GEOMETRY
LOB
Controlling Autocommit
BIT, VARBIT
JDBC Logging
Hibernate
SQL Plan
4. Tips & Recommendation
5. Error Messages
6. JDBC 4.2 API References
Appendix A. Data Type Mapping
API User's Manual
API User's Manual
About This Manual
1. PHP Interface
2. PDO Driver
3. XA Interface
4. iLoader API
5. CheckServer API
6. Altibase ADO.NET
7.Altibase EF Core(Altibase.EntityFrameworkCore)
Altibase C Interface Manual
Altibase C Interface Manual
About This Manual
1. Introduction to Altibase C Interface
2. Data Type
3. ACI Functions Description
4. Prepared Statement Function Descriptions
5. Using Array Binding and Array Fetching
6. Using Failover
Log Analyzer User's Manual
Log Analyzer User's Manual
About This Manual
1. Log Analyzer Introduction
2. XLog Sender
3. Analyzing Logs
4. Log Analysis API
Appendix A. Error Codes
Appendix B. Sample Code
Monitoring API Developer's Guide
Monitoring API Developer's Guide
About This Manual
1. Introduction
2. Data Types
3. Functions
3. Functions
ABICheckConnection
ABIFinalize
ABIGetDBInfo
ABIGetErrorMessage
ABIGetEventName
ABIGetLockPairBetweenSessions
ABIGetLockWaitSessionCount
ABIGetMaxClientCount
ABIGetReadCount
ABIGetRepGap
ABIGetRepSentLogCount
ABIGetSessionCount
ABIGetSqlText
ABIGetStatName
ABIGetVSession
ABIGetVSessionBySID
ABIGetVSessionEvent
ABIGetVSessionEventBySID
ABIGetVSessionWait
ABIGetVSessionWaitBySID
ABIGetVSesstat
ABIGetVSesstatBySID
ABIGetVSysstat
ABIGetVSystemEvent
ABIInitialize
ABISetProperty
4. Sample Programs
Tools
Tools
iSQL User's Manual
iSQL User's Manual
About This Manual
1. Using iSQL
1. Using iSQL
iSQL Main Functionality
Setting up iSQL
iSQL Command-Line Options
iSQL Commands
iSQL Environment Variables
Personalizing iSQL
2. Examples of iSQL in Use
2. Examples of iSQL in Use
Logging In to iSQL
Starting Up and Shutting Down Altibase
Connecting and Disconnecting
Retrieving Information Related to the Database and Database Objects
Controlling Transactions
File Management
Formatting SELECT Query Results
Setting Output Options
Viewing iSQL Display Settings
Host Variables
Executing Prepared SQL Statements
Creating, Executing, and Dropping Stored Procedures
Creating, Executing, and Dropping Functions
Convenient User Functions
Using National Character Sets
iLoader User's Manual
iLoader User's Manual
About This Manual
1. iLoader Overview
2. Using iLoader
3. FORM Files
4. Troubleshooting and FAQs
Utilities Manual
Utilities Manual
About This Manual
1. aexport
2. altiComp
3. aku
4. altiMon
5. Other Utilities
5. Other Utilities
altiAudit
altiEncrypt
altiProfile
Altibase
Altierr
Altipasswd
Altiwrap
Awrite
checkServer
Dumpbi
Dumpct
Dumpdb
Dumpddf
Dumpla
Dumplf
Dumptrc
killCheckServer
Server
External Tools
External Tools
Adapter for JDBC User's Manual
Adapter for JDBC User's Manual
About This Manual
1. Introduction
2. Installation and Configuration
3. Usage Instructions
Appendix A. FAQ
Appendix B. DDL execution order when using the jdbcAdapter
Adapter for Oracle User's Manual
Adapter for Oracle User's Manual
About This Manual
1. Introduction
2. Installation and Configuration
3. Managing Adapter for Oracle
Appendix A. FAQ
Appendix B. DDL order when using oraAdapter
Altibase 3rd Party Connector Guide
Altibase 3rd Party Connector Guide
About This Manual
1. DBeaver
2. OpenLDAP
Altibase Heartbeat User's Guide
Altibase Heartbeat User's Guide
About This Manual
1. Introduction to Altibase Heartbeat
2. Commands
3. Configuring Altibase Heartbeat
4. Altibase Heartbeat Process
Hadoop Connector User's Manual
Hadoop Connector User's Manual
About This Manual
1. Introduction to Altibase Hadoop Connector
2. Installing the Altibase Hadoop Connector
3. Functions
Appendix A. Data Types
Migration Center User's Manual
Migration Center User's Manual
About This Manual
1. Introduction
2. Getting Started
3. GUI Mode Quick Guide
4. CLI Mode Quick Guide
5. Migration Center Internals
Appendix A. Migration Options
Appendix B. Migratable Database Objects
Appendix C. Data Type Mapping
Appendix D. Mapping Default Values
Appendix E. PSM Converter Rule List
Appendix E. PSM Converter Rule List
View Conversion Rules
Trigger Conversion Rules
Function Conversion Rules
Procedure Conversion Rules
Materialized View Conversion Rules
Package Conversion Rules
Library Conversion Rules
DML Conversion Rules
PSM Conversion Rules
Expression Conversion Rules
Appendix F. FAQ
Appendix F. FAQ
Common
Altibase
MS SQL
MySQL
Oracle
PostgreSQL
Tibero
TimesTen
Replication Manager User's Manual
Replication Manager User's Manual
About This Manual
1. Introduction
2. How to use Replication Manager
altiShapeLoader User's Manual
altiShapeLoader User's Manual
About This Manual
1. Introduction to altiShapeLoader
2. How to Use altiShapeLoader
3. Constraints
4. Converting Data Types
dataCompJ User's Manual
dataCompJ User's Manual
About This Manual
1. Introducing dataCompJ
2. Getting Started
3. How to Use dataCompJ
4. Functions
Appendix A. Data Type compatibility table between Other Databases
5. Other Utilities
#
Back to top