Thank you, Sean Greetings.
Walter. On Wed, Feb 15, 2017 at 6:43 PM, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] <firebird-support@yahoogroups.com> wrote: > > > Walter, > > > If I connect to a database "Database1" using ISQL, I can write something > like: > > > > OUTPUT MyFile.DAT; > > SELECT * FROM MyTable; > > OUTPUT; > > > > And all the rows of "MyTable" will go to the text file "MyFile.DAT". > That's ok > > and works fine. > > > > But now, I want to connect to "Database2", which also have a table > called > > "MyTable" and with the same structure. > > > > After that, I want to insert into "MyTable" (of "Database2") the rows > > contained in "MyFile.DAT" > > > > How can I do such thing without a lot of effort writing an INSERT > command in > > each line of "MyFile.DAT"? > > The Firebird ISQL tool does not support such a feature. > > You could create 2 output files and then use command line utility to > combine results into single file. > > There are some third-party tools which could allow you to script this > process (I know that IBExpert supports it) > > > Sean > >
