Resolve variable inside another variable Post: 302684553

Sponsored Content

Top Forums Shell Programming and Scripting Resolve variable inside another variable Post 302684553 by vinay4889 on Thursday 9th of August 2012 05:56:32 PM

08-09-2012

Registered User

Corona,

I have a query and I want to run it passing parameters at runtime. For which I tried the way I explained below and believe me that is the purpose of program.

I need to run the Query(s) in a loop.There is metadata table which has one entry for each Id. Each Id has a Query attached.Query is a field in metadata table which I get passing Id to the table.This way I get corresponding Query for an Id.
Now this Query I cannot use directly.
The parameters (clause in query) I need to put in the query at runtime.These values ( values of the variables which I need to put in Query) also I will get from the same metadata table (where I got Query for an Id from). Again I will pass the Id and will the corresponding values.These values(in my example var1,var2,table1,table2) I need to pass in Query actually.

One more complexity here. I will get two set of values for each Id.
One set is for say set A and another is for set B.
Number of parameters in both sets will be same.
The value of these parameters I need to resolve. I assign values for the query from parameter set A first , resolve query and run it.
Then I assign values for the query for parameter set B then resolve the query and run it.

Ok , obviously same query will be used for an Id no matter how many set of values we have.

This is not a standard way , but a way which I am following. Please advise how can I improve this so that I do not get those errors.

Thanks

vinay4889

View Public Profile for vinay4889

Find all posts by vinay4889

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

ksh: A part of variable A's name is inside of variable B, how to update A?

This is what I tried: vara=${varb}_count (( vara += 1 )) Thanks for help

2. Shell Programming and Scripting

Resolve a Variable

Hi I have a variable which is a path ie: UBERROR=/cobwrk/mchr/prodsup/ub/wrk/../error is there anyway I can get the output of an echo to read: #echo $UBERROR /cobwrk/mchr/prodsup/ub/error instead of #echo $UBERROR /cobwrk/mchr/prodsup/ub/wrk/../error Many thanks!

3. UNIX for Dummies Questions & Answers

passing a variable inside a variable to a function

I would like to know how to pass a variable inside a variable to a function. sample code below -------------- for x in 1 9 do check_null $C$x ##call function to check if the value is null if then echo "line number:$var_cnt,...

4. Shell Programming and Scripting

variable inside variable inside loop headache

Hi Gurus I have a file called /tmp/CMDB which looks like this serial: 0623AN1208 hostname: server1 model: x4100 assetID: 1234 I am writing a for loop that will go through this file line by line creating a variable of itself. Using the first iteration of the loop (i.e. the first line) as...

5. Shell Programming and Scripting

Not able to store command inside a shell variable, and run the variable

Hi, I am trying to do the following thing var='date' $var Above command substitutes date for and in turn runs the date command and i am getting the todays date value. I am trying to do the same thing as following, but facing some problems, unique_host_pro="sed -e ' /#/d'...

6. Shell Programming and Scripting

evaluating a variable inside a variable

Hi there, i think im getting myself a little confused and need some help :wall: I am reading in a bunch of variables to my script from an external file and need to validate that a value has been set for each so if you can imagine, the user is required to pass in 4 values...

7. Shell Programming and Scripting

Resolve Environment Variable

I am tyring to resolve an environment variable that is part of a string I selected from our database. Simply put, I want cd to this folder before checking if a file exists. The variable $in_loc has the value '$PS_HOME/int/VSP' where $PS_HOME is the environment variable. I am using cd...

8. Shell Programming and Scripting

Resolve parameter value stored in a variable

Hi All, I have below variable, xyz=\$AI_XFR Now, if you will run the below command => echo $xyz $AI_XFR It is returning hardcoded string value. Whereas in environment, there is value in it. Like below: => echo $AI_XFR /home/aditya/sandbox/xfr/ I need to resolve this...

9. Shell Programming and Scripting

Cannot resolve $variable in awk

My script ---------- for i in `cat n`;do export k=`echo "CSN: "$i` //combining CSN: and value from n echo "$k" awk ''{print "CSN: "$0;}'{_=29}_&&_--' file1|tail -1 >> file2 done In the above script i cannot able to resolve $k in awk command file n contains ------------ 0000 1111 2222...

10. Shell Programming and Scripting

To print value for a $variable inside a $variable or file

Hi guys, I have a file "abc.dat" in below format: FILE_PATH||||$F_PATH TABLE_LIST||||a|b|c SYST_NM||||${SRC_SYST} Now I am trying to read the above file and want to print the value for above dollar variables F_PATH and SRC_SYST. The problem is it's reading the dollar variables as...

LEARN ABOUT REDHAT

variable

variable(n)						       Tcl Built-In Commands						       variable(n)

__________________________________________________________________________________________________________________________________________________

NAME

       variable - create and initialize a namespace variable

SYNOPSIS

       variable ?name value...? name ?value?
_________________________________________________________________

DESCRIPTION

       This  command  is  normally used within a namespace eval command to create one or more variables within a namespace.  Each variable name is
       initialized with value.	The value for the last variable is optional.

       If a variable name does not exist, it is created.  In this case, if value is specified, it is assigned to the newly created  variable.	If
       no  value  is  specified,  the new variable is left undefined.  If the variable already exists, it is set to value if value is specified or
       left unchanged if no value is given.  Normally, name is unqualified (does not include the names of  any	containing  namespaces),  and  the
       variable  is  created in the current namespace.	If name includes any namespace qualifiers, the variable is created in the specified names-
       pace.  If the variable is not defined, it will be visible to the namespace which command, but not to the info exists command.

       If the variable command is executed inside a Tcl procedure, it creates local variables linked to the corresponding namespace variables (and
       therefore  these  variables are listed by info locals.)	In this way the variable command resembles the global command, although the global
       command only links to variables in the global namespace.  If any values are given, they are used to modify the  values  of  the	associated
       namespace variables.  If a namespace variable does not exist, it is created and optionally initialized.

       A name argument cannot reference an element within an array.  Instead, name should reference the entire array, and the initialization value
       should be left off.  After the variable has been declared, elements within the array can be set using ordinary set or array commands.

SEE ALSO

       global(n), namespace(n), upvar(n)

KEYWORDS

       global, namespace, procedure, variable

Tcl									8.0							       variable(n)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

ksh: A part of variable A's name is inside of variable B, how to update A?

Discussion started by: pa3be

2. Shell Programming and Scripting

Resolve a Variable

Discussion started by: serm

3. UNIX for Dummies Questions & Answers

passing a variable inside a variable to a function

Discussion started by: KingVikram

4. Shell Programming and Scripting

variable inside variable inside loop headache

Discussion started by: hcclnoodles