Table Of Contents

• Preface
• About This Manual
• 1. Using iSQL
• iSQL Overview
• Setting up iSQL
• iSQL Command-Line Options
• iSQL Commands
• iSQL Environment Variables
• Personalizing iSQL
• 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