Query for administration

[penzk001]

Hi,

I need to run a particular query on all the databases of an enviroment. The report must include the database name which I thing I can obtain it from (
set isolation to dirty read;
database sysmaster;
select name from sysdatabases
where name not in ('sysmaster','sysutils')
and to check if a user has connect to any database in this database or not (select count(username) from sysusers where username = 'user001'.

How can I implement it, so that I can run an SQL script

 

[olded]

Hi:

Are you asking how to embed SQL in a unix shell script? If so, read this article. It should give you some ideas:

http://www.samag.com/documents/s=7732/sam0212c/0212c.htm