Thank you Vlad, but is not for me, is for an article of my blog, I am showing the alternatives for exporting data.
firebird21.wordpress.com Greetings. Walter. On Thu, Feb 16, 2017 at 3:44 AM, hv...@users.sourceforge.net [firebird-support] <firebird-support@yahoogroups.com> wrote: > > > ---In firebird-support@yahoogroups.com, <sistemas2000profesional@...> > wrote : > > Hello everybody > > 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"? > > If you need to export some data from one Firebird database to another > Firebird database, use EXECUTE STATEMENT ... ON EXTERNAL and forget about > files. > > Regards, > Vlad > > >