Command-line isql Tool

Go Up to Interactive Query

Command-line isql is a utility for processing SQL data definition (DDL) and data manipulation (DML) statements from interactive input or from a source file. It enables you to create and view metadata, add and modify data, grant user permissions, test queries, and perform database administration tasks.

For a description of the standard SQL commands available in isql, see the Language Reference Guide. For a description of special isql commands, see isql Command Reference.

You can use isql in the following ways:

• Interactively to process SQL statements, by entering statements at the isql prompt
• Noninteractively to process SQL statements in a file

Topics

• Invoking isql
• Setting isql Client Dialect
• Transaction Behavior in isql
• Extracting Metadata Using isql
• isql Commands
• Error Handling in isql