Shell Programming and Scripting

Hi ,


I need help in creating the shell script for querying using a loop.
I haev written the code as follows . But i am getting an error : Line [41] doesn't required '(' . i have chagned but am getting again

#!/bin/ksh

##checking the Command Line Parameter
if test $1 = ""
then
echo "Config File is not provided as Input ">>/data/coml/logs/cnt_log.txt
else
# Checking the config file for the Parameters
#checking Table name
tablename=$(grep "Table Name" $1 | cut -d: -f2)
fi
if test $tablename = ""
then
tablename_error="Table name is missing"
fi

#Reading and checking Columns
columns=$(grep "Columns" $1 | cut -d: -f2)
if test $columns = ""
then
columns_error="Columns are not available in config file"
fi

echo "Table Name :"$tablename
echo "columns :"$columns
if [ $tablename = "" ] -o [ $columns = "" ]
then
echo "Parameters in Config file are Missing(Table Name, Columns are Missing:" | tee -a /data/coml/logs/dp_log.txt
exit 1
fi
#Actual Code

no_of_cols=$(echo $columns|awk -F, '{print NF}')
echo "No.of Columns :" $no_of_cols
var_loop=0
db2 connect to MLCDMD user fdrcrd using fdrcrd123
while test $var_loop -le $no_of_cols
do
field=$(echo $columns | cut -d, -f$var_loop)
db2 "select $field,count(*) 'cnt' from fdrc.$tablename"> $field.txt
var_loop= ( $var_loop ) + 1
done
exit

Hey, try updating the red line:

Code:

#!/bin/ksh

##checking the Command Line Parameter
if test $1 = ""
 then
        echo "Config File is not provided as Input ">>/data/coml/logs/cnt_log.txt
else
   # Checking the config file for the Parameters
        #checking Table name
        tablename=$(grep "Table Name" $1 | cut -d: -f2)
fi
        if test $tablename = ""
        then
         tablename_error="Table name is missing"
        fi

        #Reading and checking Columns
        columns=$(grep "Columns" $1 | cut -d: -f2)
        if test $columns = ""
        then
          columns_error="Columns are not available in config file"
        fi

        echo "Table Name :"$tablename
        echo "columns    :"$columns
        if  [ $tablename = "" ] -o  [ $columns = "" ]
        then
          echo "Parameters in Config file are Missing(Table Name, Columns are Missing:" | tee -a /data/coml/logs/dp_log.txt
          exit 1
fi
        #Actual Code

 no_of_cols=$(echo $columns|awk -F, '{print NF}')
echo "No.of Columns  :"  $no_of_cols
          var_loop=0
          db2 connect to MLCDMD user fdrcrd using fdrcrd123
          while test $var_loop -le $no_of_cols
 do
                field=$(echo $columns | cut -d, -f$var_loop)
                db2 "select $field,count(*) 'cnt' from fdrc.$tablename"> $field.txt
varloop=$(( varloop + 1 ))
           done
exit

Code:

if  [ $tablename = "" ] ||  [ $columns = "" ]

Code:

var_loop=$(( $var_loop + 1 ))

Assign without space between '=' and '(' ... var_loop=( $var_loop ) + 1

or use expr to increment the value.