Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Resolve variable inside another variable
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
Old 08-09-2012
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
 

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 (4 Replies)
Discussion started by: pa3be
4 Replies

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! (2 Replies)
Discussion started by: serm
2 Replies

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,... (2 Replies)
Discussion started by: KingVikram
2 Replies

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... (6 Replies)
Discussion started by: hcclnoodles
6 Replies

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'... (3 Replies)
Discussion started by: gvinayagam
3 Replies

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... (3 Replies)
Discussion started by: rethink
3 Replies

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... (6 Replies)
Discussion started by: consult_jb
6 Replies

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... (4 Replies)
Discussion started by: adgangwar
4 Replies

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... (2 Replies)
Discussion started by: Mohana29_1988
2 Replies

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... (5 Replies)
Discussion started by: abcabc1103
5 Replies

LEARN ABOUT DEBIAN

rdf::query::plan::subselect

RDF::Query::Plan::SubSelect(3pm)			User Contributed Perl Documentation			  RDF::Query::Plan::SubSelect(3pm)

NAME

       RDF::Query::Plan::SubSelect - Executable query plan for sub-select queries.

VERSION

       This document describes RDF::Query::Plan::SubSelect version 2.908.

METHODS

       Beyond the methods documented below, this class inherits methods from the RDF::Query::Plan class.

       "new ( $query, [ \%logging_keys ] )"
	   Returns a new SubSelect query plan object. "<$query"> is a RDF:Query object representing a SELECT query.

       "execute ( $execution_context )"
       "next"
       "close"
       "query"
	   Returns the sub-select query object.

       "plan"
	   Returns the sub-select query plan object.

       "distinct"
	   Returns true if the pattern is guaranteed to return distinct results.

       "ordered"
	   Returns true if the pattern is guaranteed to return ordered results.

       "plan_node_name"
	   Returns the string name of this plan node, suitable for use in serialization.

       "plan_prototype"
	   Returns a list of scalar identifiers for the type of the content (children) nodes of this plan node. See RDF::Query::Plan for a list of
	   the allowable identifiers.

       "plan_node_data"
	   Returns the data for this plan node that corresponds to the values described by the signature returned by "plan_prototype".

       "graph ( $g )"

AUTHOR

	Gregory Todd Williams <gwilliams@cpan.org>

perl v5.14.2							    2012-01-31					  RDF::Query::Plan::SubSelect(3pm)
All times are GMT -4. The time now is 12:09 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy