UNIX for Dummies Questions & Answers

Hi,

In simple what I want is eg:

var1=Load
var2='1001'

I need Load to be set to '1001' so that if I do

Code:

echo $Load

the result should be '1001'... Why I need this and what I have tried is given below:

I am trying to write a script that would submit queries into my database. To supply parameters to the query, I need to assign values to the parameters in the query. For different queries, I dont know what the parameters would be. So, I have a file that has the parameters and their values in a csv format.

queryid,Parameter,value
1,Load_Key,1001
1,Audit_key,'2340'
1,Balancing_Ind,'Y'
2,Member_ID,SVSS01
2,Relationship_Ind,'SPOUS'
2,Balancing_Ind,'Y'

Now, when I am submitting the queries using a for loop in my script, when query 1 is submitted, I have the query as:
Select Count(*) From Load
Where Load_Key = $Load_Key
And Audit_Key In ($Audit_Key)
And Balancing_Ind=$Balancing_Ind

The parameters for different queries are different.

I did like this:

Code:

 
queryid=1
for var in `cat file.csv`
do
var=`echo "$var" | tr ',' ' '`
set $var
if [ $1 = $queryid ]
then
$2=$3
echo $Load_Key
echo $Audit_Key
echo $Balancing_Ind
else
echo nothing
fi
done

When it comes to line highlighted in Bold, it gives be an error:

./csvdecode.txt[14]: Load_Key=1001: not found.
./csvdecode.txt[14]: Audit_Key='2340': not found.
./csvdecode.txt[14]: Balancing_Ind='Y': not found.

Any help is really appreciated

Code:

for var in `cat abc.txt`
do
        array=(`echo "$var" | tr "," " "`);
        eval ${array[1]}=`echo ${array[2]}`;
        eval echo  ${array[1]} \$${array[1]} ;
done

Code:

sh chk_script.sh
Load_Key 1001
Audit_key 2340
Balancing_Ind Y
Member_ID SVSS01
Relationship_Ind SPOUS
Balancing_Ind Y

HTH,
PL

Code:

while IFS="," read var1 var2 var3
do
    eval $var2=`echo $var3`
    eval echo "$var2 \$$var2"
done < file