Skip to content

Altibase 7.3 Documentation

2. Examples of iSQL in Use

Altibase 7.1
Altibase 7.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
- 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
Administrator
Administrator
- Administrator's Manual
  Administrator's Manual
- Replication Manual
  Replication Manual
- Performance Tuning Guide
  Performance Tuning Guide
- DB Link User's Manual
  DB Link User's Manual
- Altibase SSL TLS User's Guide
  Altibase SSL TLS User's Guide
- SNMP Agent Guide
  SNMP Agent Guide
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
- Error Message Reference
  Error Message Reference
Developer
Developer
- Stored Procedures Manual
  Stored Procedures Manual
- C/C++ External Procedures Manual
  C/C++ External Procedures Manual
- Precompiler User's Manual
  Precompiler User's Manual
- 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
- 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
- Altibase C Interface Manual
  Altibase C Interface Manual
- Log Analyzer User's Manual
  Log Analyzer User's Manual
- Monitoring API Developer's Guide
  Monitoring API Developer's Guide
Tools
Tools
- iSQL User's Manual
  iSQL User's Manual
- iLoader User's Manual
  iLoader User's Manual
- Utilities Manual
  Utilities Manual
  - About This Manual
  - 1. aexport
  - 2. altiComp
  - 3. aku
  - 4. altiMon
  - 5. Other Utilities
    
    5. Other Utilities
    
    altiAudit
    
    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
- Adapter for Oracle User's Manual
  Adapter for Oracle User's Manual
- Altibase 3rd Party Connector Guide
  Altibase 3rd Party Connector Guide
- Altibase Heartbeat User's Guide
  Altibase Heartbeat User's Guide
- Hadoop Connector User's Manual
  Hadoop Connector User's Manual
- 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
- altiShapeLoader User's Manual
  altiShapeLoader User's Manual
- dataCompJ User's Manual
  dataCompJ User's Manual

2. Examples of iSQL in Use#

This chapter describes several examples of the use of iSQL to manipulate databases.

Personalizing iSQL

Logging In to iSQL

© 1999-2025 Altibase Corp.