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 * * [email protected] * * [email protected] * ********************************************** 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
