SS64 Forum

k100p

New Member

Registered: 21 Oct 2018

Posts: 1

Read a text file to connect to database!

Hi, I hope someone can help me. I am new to batch scripting. I want to read a file that has database names
and connect to each of them to get status and write output to a file. I'd like to do this from cmd command.

I really appreciate if I can get some help here.

Thanks in advance.

bluesxman

Member

From: UK

Registered: 29 Dec 2006

Posts: 1,129

Re: Read a text file to connect to database!

If it's just a simple list, you can do something like this ... you'll have to fill in some of the details as you've not given a great deal to go on.

for /f "usebackq tokens=*" %%a in ("your_list_of_databases.txt") do (
   status_command %%a
)

---

cmd | *sh | ruby | chef