Hi everyone.

 

I am cloning a DB using a recipe found at: http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gbak-recipies.html#gbak-recipies-clone-nodump via a batch script (Windows) but prior to cloning it, I wanted to see if there were any active connections to the destination (to avoid errors).

 

I run this command:

echo set heading; select rtrim(ltrim(count(mon$attachment_id))) from mon$attachments; | isql %DBPlay% -u %DBA% -p %DBPASS% -q

 

and get the following output:

 

Database:  employee.fdb, User: sysdba

SQL>

2

 

All I want is 2, none of the other stuff, so I can plug it into a variable, compare it etc.  Is it possible or am I way off the mark or is there a better tool?

 

TIA.

 

Andrew Zenz