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 PHP

pg_send_query

PG_SEND_QUERY(3)														  PG_SEND_QUERY(3)

pg_send_query - Sends asynchronous query

SYNOPSIS

       bool pg_send_query (resource  $connection, string  $query)

DESCRIPTION

       pg_send_query(3)  sends	a  query or queries asynchronously to the $connection. Unlike pg_query(3), it can send multiple queries at once to
       PostgreSQL and get the results one by one using pg_get_result(3).

	Script execution is not blocked while the queries are executing. Use pg_connection_busy(3) to check if the connection is  busy	(i.e.  the
       query is executing). Queries may be cancelled using pg_cancel_query(3).

	Although  the user can send multiple queries at once, multiple queries cannot be sent over a busy connection. If a query is sent while the
       connection is busy, it waits until the last query is finished and discards all its results.

PARAMETERS

	      o $connection
		- PostgreSQL database connection resource.

	      o $query
		- The SQL statement or statements to be executed.  Data inside the query should be properly escaped.

RETURN VALUES

       Returns TRUE on success or FALSE on failure.

	Use pg_get_result(3) to determine the query result.

EXAMPLES

       Example #1

	      pg_send_query(3) example

	      <?php
		$dbconn = pg_connect("dbname=publisher") or die("Could not connect");

		if (!pg_connection_busy($dbconn)) {
		    pg_send_query($dbconn, "select * from authors; select count(*) from authors;");
		}

		$res1 = pg_get_result($dbconn);
		echo "First call to pg_get_result(): $res1
";
		$rows1 = pg_num_rows($res1);
		echo "$res1 has $rows1 records

";

		$res2 = pg_get_result($dbconn);
		echo "Second call to pg_get_result(): $res2
";
		$rows2 = pg_num_rows($res2);
		echo "$res2 has $rows2 records
";
	      ?>

	      The above example will output:

	      First call to pg_get_result(): Resource id #3
	      Resource id #3 has 3 records

	      Second call to pg_get_result(): Resource id #4
	      Resource id #4 has 1 records

SEE ALSO

       pg_query(3), pg_cancel_query(3), pg_get_result(3), pg_connection_busy(3).

PHP Documentation Group 													  PG_SEND_QUERY(3)

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