EnglishFrenchSpanish

Ad


OnWorks favicon

isql-fb - Online in the Cloud

Run isql-fb in OnWorks free hosting provider over Ubuntu Online, Fedora Online, Windows online emulator or MAC OS online emulator

This is the command isql-fb that can be run in the OnWorks free hosting provider using one of our multiple free online workstations such as Ubuntu Online, Fedora Online, Windows online emulator or MAC OS online emulator

PROGRAM:

NAME


isql — Firebird Interactive SQL shell

SYNOPSIS


isql [ -a ] [ -cache bufnum ] [ -database database ] [ -echo ] [ -input infile ] [
-noautocommit ] [ -nowarnings ] [ -output outfile ] [ -password password ] [ -page
pagelen ] [ -role role ] [ -s sqldialect ] [ -terminator lineterm ] [ -user user ] [
-x ] [ -z ]

DESCRIPTION


This manual page documents briefly the isql command.

This manual page was written for the Debian distribution because the original program does
not have a (free) manual page. Instead, it has non-free documentation you can get from
InterBase (Borland) or FireBird project sites; see at the end of the document.

isql is a program that allows the user to issue arbitrary SQL commands to a Firebird
database as well as exctacting the metadata.

isql in Debian is available under isql-fb name due to filename conflict with binary from
other package. If for some reason it is needed to have it under original name it is
possible to add /usr/lib/firebird/bin at the beginning of PATH variable which should solve
eventual problem.

OPTIONS


isql can handle various command line options. Most options can be abbreviated. Below are
given the shortest abbreviations as well as the full versions. A summary of options
follows.

-a
Extract DDL statements necessary to re-create database's metadata. The CREATE
DATABASE statement is surrounded by C-style comment. Statements are printed to
standard output unless redirection is used. See -output. See -x.

-c[ache] buffers
Specify default number of cache buffers to be used in connections.

-d[atabase] database
Used together with -x. Specifies target database name when extracting. See -x.

-e[cho] Display each statement before executing it.

-x|-ex[tract]
Extracts DDL statements to recreate database metadata. The only difference with
-a is that -extract behaves differently if -d is also specified.

If no -d is specified, -x behaves exactly as -a. If -d is specified, the CREATE
DATABASE statement is uncommented, replacing database name with database.

-i[nput] infile
Reads commands from infile instead of standard input. Exits with commit after
the last command.

-m[erge_stderr]
Merges standard error to standard output. Useful for redirecting both streams.

-n[oautocommit]
Normally, all DDL statements like CREATE TABLE are automatically committed in a
separate transaction. This option disables the automatic commit of DDL
statements.

-nowarnings
Disables displaying of SQL warnings.

-o[utput] outfile
All output is redirected to the given outfile.

-page[length] n
Prints column headers every n output lines. Default is 20.

-pas[sword] password
Uses given password as a default for connecting to the database.

-r[ole] sqlrole
Uses given sqlrole as a default for connecting to the database.

-s[qldialect] sqldialect
Uses given sqldialect as a default for connecting to the database.

-t[erminator] lineterm
Set command line terminator. Default is semicolon (`;').

-u[ser] username
Uses given username as a default for connecting to the database.

-z Show version string before doing anything else.

Use isql-fb online using onworks.net services


Free Servers & Workstations

Download Windows & Linux apps

  • 1
    Alt-F
    Alt-F
    Alt-F provides a free and open source
    alternative firmware for the DLINK
    DNS-320/320L/321/323/325/327L and
    DNR-322L. Alt-F has Samba and NFS;
    supports ext2/3/4...
    Download Alt-F
  • 2
    usm
    usm
    Usm is a unified slackware package
    manager that handles automatic
    dependency resolution. It unifies
    various package repositories including
    slackware, slacky, p...
    Download usm
  • 3
    Chart.js
    Chart.js
    Chart.js is a Javascript library that
    allows designers and developers to draw
    all kinds of charts using the HTML5
    canvas element. Chart js offers a great
    array ...
    Download Chart.js
  • 4
    iReport-Designer for JasperReports
    iReport-Designer for JasperReports
    NOTE: iReport/Jaspersoft Studio Support
    Announcement: As of version 5.5.0,
    Jaspersoft Studio will be the official
    design client for JasperReports. iReport
    will...
    Download iReport-Designer for JasperReports
  • 5
    PostInstallerF
    PostInstallerF
    PostInstallerF will install all the
    software that Fedora Linux and others
    doesn't include by default, after
    running Fedora for the first time. Its
    easy for...
    Download PostInstallerF
  • 6
    strace
    strace
    The strace project has been moved to
    https://strace.io. strace is a
    diagnostic, debugging and instructional
    userspace tracer for Linux. It is used
    to monitor a...
    Download strace
  • More »

Linux commands

Ad