If clause failin in script

smith43017 · #1 (**permalink**) 01-17-08, 10:33

if [ ${dbfile}='DBPTLFEP'||${dbfile}='DBPTLLMP']; then
db2 deactivate db ${dbfile}
fi

I want to deactivate db if name are DBPTLLMP,DBPTLFEP the vales I am reading from flat file.

smith43017 · #2 (**permalink**) 01-17-08, 10:36

Can some body can help me please

stolze · #3 (**permalink**) 01-17-08, 18:18

You are not using the correct syntax for conditions. Or-ing two conditions is done with -o. Furthermore, you should consider the case where $dbfile could be the empty string - this would result in "if [ ='...' ]; then", which is invalid syntax. Try this instead:

Code:

if [ "${dbfile}" = 'DBPTLFEP' -o "${dbfile}" = 'DBPTLLMP' ]; then
    db2 deactivate ${dbfile}
fi

smith43017 · #4 (**permalink**) 01-18-08, 12:00

Actuvally $dbfile doesn't have any empty string.

It have 7 line (no extra spaces)
each line one databse name. But thanks for adive in another post about reading man on test.

I will try this and let you guys jknow about it

smith43017 · #5 (**permalink**) 01-18-08, 12:24

HTML Code:

db2 list db directory|grep -p Indirect|grep -E "alias"|cut -c41-49>dbs
while read dbfile
do
if [ "${dbfile}" = 'DBPTLFEU' -o "${dbfile}" = 'DBPTLLMU' ]; then
    db2 deactivate db ${dbfile};
else
 db2 connect to ${dbfile};
 echo ${dbfile} 
 db2 -tvf ptldeadevnt.sql 
 db2 connect reset>/dev/null
fi
done < dbs

smith43017 · #6 (**permalink**) 01-18-08, 12:26

Thank you very much Stolze

Internet Services

Web Development

Digital Marketing

Consumer Tech