multi dbviscmd batch export problem

Hi I try do export from a lot of data bases. my export cmd-file has some row like this: "c:\Program Files\DbVisualizer\dbviscmd.bat" -connection DB1_conn -userid user -password pwd -sqlfile DB1_export.sql "c:\Program Files\DbVisualizer\dbviscmd.bat" -connection DB2_conn -userid user -password pwd -sqlfile DB2_export.sql "c:\Program Files\DbVisualizer\dbviscmd.bat" -connection DB3_conn -userid user -password pwd -sqlfile DB3_export.sql ----- *But batch command execute only for one first row. 2-d and 3-d command don't execute. There is no error. If I comment 1-t row - then 2-d row will execute, but 3-d row don't wont execute.* ----- DB{X}_export.sql is script for export data from tables. All scripts has structure like this: @export on; @export set ....... ; @set maxrows 0; SELECT * FROM "table1"; ....... @export off; Edited by: bunak on 16.11.2013 13:32

Yes. I create cmd-file (or BAT file). It name is export.cmd. This file contains commands: "c:\Program Files\DbVisualizer\dbviscmd.bat" -connection DB1_conn -userid user -password pwd -sqlfile DB1_export.sql "c:\Program Files\DbVisualizer\dbviscmd.bat" -connection DB2_conn -userid user -password pwd -sqlfile DB2_export.sql "c:\Program Files\DbVisualizer\dbviscmd.bat" -connection DB3_conn -userid user -password pwd -sqlfile DB3_export.sql then in command line i execute this file C:\export_db\>export.cmd but only first command (line) in cmd-file is executed. ----- P.S. ----- By the way. The main task that I want to do - is do export from many databases. I try use batch file with dbviscmd.bat, because, there are not possible change database (or connection) in SQL Commander of GUI: http://www.dbvis.com/forum/thread.jspa?messageID=11900⹼ http://www.dbvis.com/forum/thread.jspa?messageID=12024 Edited by: bunak on 16.11.2013 19:53

good very very good it is working thank you