How to assign a value in a variable to a value in another variable Post: 302376577

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers How to assign a value in a variable to a value in another variable Post 302376577 by nsaikrishna on Tuesday 1st of December 2009 07:13:11 PM

12-01-2009

Registered User

How to assign a value in a variable to a value in another variable

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

nsaikrishna

View Public Profile for nsaikrishna

Find all posts by nsaikrishna

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

assign to variable

why i can't use this command: echo $arg | cut -c 1,2 | read remainArg or echo $arg | cut -c 1,2 | read $remainArg so that the result will be assign to remainArg. Anyway to do this? :)

2. Shell Programming and Scripting

assign a value to variable

I have to assign a result of a query to a vairable like this how can i do this Query = select count(*) from table x=`db2 ${Query}| sed -n '4p'` but this doesn't work, is there any other way to assign the result without redirecting the result to temp file. . Thanks Mark.

3. Shell Programming and Scripting

assign a value to a variable

I have a list of names in a file. i want to assign those names to a variable in such a manner eg: $cat file.txt pete lisa john var=pete-lisa-john how do i do this in shell scripting?

4. Shell Programming and Scripting

Not able to assign a value to variable

Hi Experts, I am facing some problem while developing the script.My input config.csv file contains the three columns namely pathname,filename,filetype.Based on the file type i have to use ftp command that is if filetype=csv then do ftp. The input file is cat config.csv...

5. Shell Programming and Scripting

Assign this to a variable....

bash-3.00$ /usr/bin/netstat -an -f inet | awk -F' ' '{if ($1$4 == "tcp*.21")print $5}' *.* bash-3.00$ A=` /usr/bin/netstat -an -f inet | awk -F' ' '{if ($1$4 == "tcp*.21")print $5}'` bash-3.00$ echo $A db2_lastdone.bkp As you can see ,after running command i get *.* in return but the same...

6. Shell Programming and Scripting

assign awk's variable to shell script's variable?

Dear All, we have a command output which looks like : Total 200 queues in 30000 Kbytes and we're going to get "200" and "30000" for further process. currently, i'm using : numA=echo $OUTPUT | awk '{print $2}' numB=echo $OUTPUT | awk '{print $5}' my question is : can I use just one...

7. Shell Programming and Scripting

Shell assign variable to another variable

How can I assign a variable to an variable. IE $car=honda One way I can do it is export $car=honda or let $car=2323 Is there any other ways to preform this task

8. UNIX for Beginners Questions & Answers

Need to pass variable in a command and assign value to a variable

Hello All, Hope you're doing well ! I am trying below command to be passed in a shell script, header_date_14 is a variable and $1 is the name of a file I intend to pass as a command line argument, however command line argument is not being accepted. header_date_14=$(m_dump...

9. UNIX for Beginners Questions & Answers

How can I assign awk's variable to shell script's variable?

I have the following script, and I want to assign the output ($10 and $5) from awk to N and L: grdinfo data.grd | awk '{print $10,$5}'| read N L output from gridinfo data.grd is: data.grd 50 100 41 82 -2796 6944 0.016 0.016 3001 2461. where N and L is suppose to be 3001 and 100. I use...

10. UNIX for Beginners Questions & Answers

Assign value to variable

Hi Guys, I need to assign the value of which has rows to a variable, Can you advise how to do that hive --orcfiledump /hdfs_path/ | grep "Rows" Rows: 131554 I need to assign this row count itself to a unix variable count=$(hive --orcfiledump /hdfs_path/ | grep "Rows") Expected ...

LEARN ABOUT DEBIAN

graphics::primitive::insets

Graphics::Primitive::Insets(3pm)			User Contributed Perl Documentation			  Graphics::Primitive::Insets(3pm)

NAME

       Graphics::Primitive::Insets - Space between things

DESCRIPTION

       Graphics::Primitive::Insets represents the amount of space that surrounds something.  This object can be used to represent either padding
       or margins (in the CSS sense, one being inside the bounding box, the other being outside)

SYNOPSIS

	 use Graphics::Primitive::Insets;

	 my $insets = Graphics::Primitive::Insets->new({
	   top	   => 5,
	   bottom  => 5,
	   left    => 5,
	   right   => 5
	 });

METHODS

   Constructor
       new Creates a new Graphics::Primitive::Insets.

   Instance Methods
       as_array
	   Return these insets as an array in the form of top, right, bottom and left.

       bottom
	   Set/Get the inset from the bottom.

       equal_to
	   Determine if these Insets are equal to another.

       left
	   Set/Get the inset from the left.

       right
	   Set/Get the inset from the right.

       top Set/Get the inset from the top.

       zero
	   Sets all the insets (top, left, bottom, right) to 0.

AUTHOR

       Cory Watson, "<gphat@cpan.org>"

SEE ALSO

       perl(1)

COPYRIGHT &; LICENSE
       Copyright 2008-2010 by Cory G Watson.

       This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.12.3							    2010-08-21					  Graphics::Primitive::Insets(3pm)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

assign to variable

Discussion started by: AkumaTay

2. Shell Programming and Scripting

assign a value to variable

Discussion started by: markjason

3. Shell Programming and Scripting

assign a value to a variable

Discussion started by: Shivdatta

4. Shell Programming and Scripting

Not able to assign a value to variable

Discussion started by: Amey Joshi