Although isql has some handy interactive features, it is not restricted to being run in its shell. Many of the interactive commands are available as command-line switches. Some isql utilities, such as metadata extraction, are available only from the command shell. Operations on input and output files need not be interactive —in fact, calling isql with the –i[nput] and –o[utput] switches will not invoke the interactive shell.
Commands execute and, upon completion, return control automatically to the command shell. Calls to isql can also be batched inside shell scripts or batch files.
Certain switches can be used when invoking the interactive isql shell; they are noted in Table.
Operating isql in Command Mode
Open a command shell and cd to the Firebird /bin directory of your Firebird server or client installation. Use the following syntax pattern for isql calls:isql [options] [database_name] [-u[ser] <user-name> -pas[sword] <password>]
For SYSDBA operations, you can set the operating system variables ISC_USER and ISC_PASSWORD and avoid the need to enter them on commands. For non-SYSDBA activities, you will always need the owner credentials for operations on the database and/or objects.
The default terminator is the semicolon (;). You can change it to any character or group of characters with a command-line option.
You can set the isql dialect from the command line when invoking isql:isql -s n ;
where n is 1, 2, or 3.
Only the initial characters in an option are required. You can also type any portion of the text shown in Table in square brackets, including the full option name. For example, specifying –n, –no, or – noauto has the same effect.
Switches for isql Command-Line Options
Firebird Related Interview Questions
|RDBMS Interview Questions||MySQL Interview Questions|
|Linux Interview Questions||Mac OS X Deployment Interview Questions|
|Windows Administration Interview Questions||Windows Server 2003 Interview Questions|
|SQL Interview Questions||NoSQL Interview Questions|
|Advanced C++ Interview Questions|
Introduction To Client/server Architecture
About Firebird Data Types
Date And Time Types
Blobs And Arrays
From Drawing Board To Database
Creating And Maintaining A Database
Firebird’s Sql Language
Expressions And Predicates
Querying Multiple Tables
Ordered And Aggregated Sets
Overview Of Firebird Transactions In
Programming With Transactions
Introduction To Firebird Programming
Developing Psql Modules
Error Handling And Events
Security In The Operating Environment
Configuration And Special Features
Interactive Sql Utility (isql)
Database Backup And Restore (gbak)
Housekeeping Tool (gfix)
Understanding The Lock Manager
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.