I'm doing some more documentation work on the isql manual. The current
version mentions a copy command in isql which "copies a table structure
to another table, or database".

I tried the following, in the employee database, seeing as the "help
copy" command simply barfs:

SQL> copy ;
Either source or destination tables are missing

SQL> copy country ;
Either source or destination tables are missing

SQL> copy country my_country;

**********************************************
* unixODBC - isql *
**********************************************
* Syntax *
* *
* isql DSN [UID [PWD]] [options] *
* *
* Options *
* *
* -b batch.(no prompting etc) *
* -dx delimit columns with x *
* -x0xXX delimit columns with XX, where *
* x is in hex, ie 0x09 is tab *
* -w wrap results in an HTML table *
* -c column names on first row. *
* (only used when -d) *
* -mn limit column display width to n *
* -v verbose. *
* -lx set locale to x *
* -q wrap char fields in dquotes *
* -3 Use ODBC 3 calls *
* -n Use new line processing *
* --version version *
* *
* Commands *
* *
* help - list tables *
* help table - list columns in table *
* help help - list all help options *
* *
* Examples *
* *
* isql WebDB MyID MyPWD -w < My.sql *
* *
* Each line in My.sql must contain *
* exactly 1 SQL command except for the *
* last line which must be blank (unless *
* -n option specified). *
* *
* Please visit; *
* *
* http://www.unixodbc.org *
* pharvey@... *
* nick@... *
**********************************************

Errors occurred (possibly duplicate domains) in creating MY_COUNTRY in
employee.



So, it appears that isql knows about the command and that it should have
a source and destination table, but I've no idea what the block of text
at the end is on about!

I was suspicious of the mention of "duplicate domains", so I created a
simple test table with a single integer column, added a couple of rows,
and tried to copy that. Same result.

This is on Linux Mint 13, KDE version, isql is called isql-fb and my
Firebird version is:

SQL> show version;
ISQL Version: LI-V2.5.1.26351 Firebird 2.5

Server version:
Firebird/linux AMD64 (access method), version "LI-V2.5.1.26351 Firebird 2.5"

Firebird/linux AMD64 (remote server), version "LI-V2.5.1.26351 Firebird
2.5/tcp (hubble)/P12"

Firebird/linux AMD64 (remote interface), version "LI-V2.5.1.26351
Firebird 2.5/tcp (hubble)/P12"

on disk structure version 11.2


Cheers,
Norm.

--
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767