sqlcmd in shell script loop

Question

Hi I have a shell script that inserts disk status of linux servers in SQL server. Before inserting the SQL command, the program executes and ends properly. However, when I inserted the SQL command, the .sh file never goes to the next line to execute. It is always in a loop. Kindly help

#!/bin/bash

#Functions here
insert() {
echo "--INSERT FUNCTION--"
echo "$1"

fsname=$1
fs=$(echo "${fsname: -3}")

 sqlcmd -S <ipadd> -U <user> -P <pass> -d tech_admin -Q "EXEC insertDiskStatus $fs"
sleep 1

}
echo "TEST"
cd ~/Documents
pwd
df -Ph --exclude-type=tmpfs --exclude-type=ext3 --block-size=GB | column -t |         sed 1d > diskspace.log
filename=diskspace.log

while read -r line
do
 this=$line

 fs=$(echo $line | awk '{print $1}')

 insert $fs 

done < "$filename"

I tried to put return at the end of function, but it still continues to loop — roxsap
– roxsap, Commented Feb 11, 2015 at 1:15

dbCarl · Accepted Answer · 2016-02-10 20:50:35Z

6

I had the same problem. In my bash script, I have sqlcmd in a while loop and the loop would continue running the first item in the list over and over and not continue on to the next item. As mentioned in the comments, adding this < /dev/null to the end of sqlcmd line will cause it to get out of stuck spot in the loop and carry on to the next tiem.

edited Feb 10, 2016 at 20:50

answered Feb 10, 2016 at 20:42

dbCarl

1371 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

thetoolman Over a year ago

thanks for this answer! any idea why sqlcmd is doing this ?

Collectives™ on Stack Overflow

sqlcmd in shell script loop

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related