08-09-2012
Quote:
Originally Posted by
vinay4889
Corona,
I have a query and I want to run it passing parameters at runtime.
Okay.
Quote:
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.
Okay.
Quote:
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).
Now we're getting somewhere.
Instead of using shell variables, I might try using a language which has associative arrays, like awk, so values can easily be looked up and a string easily assembled without substitution anywhere you don't want it. This can be embedded in the shell script itself seamlessly, and will avoid the pitfalls of looking up variable names in the shell.
What does this metadata table look like, and how are you retrieving from it? What output would you want for given input?
Last edited by Corona688; 08-09-2012 at 07:50 PM..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
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
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
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
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
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
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
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
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
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::namedgraph
RDF::Query::Plan::NamedGraph(3pm) User Contributed Perl Documentation RDF::Query::Plan::NamedGraph(3pm)
NAME
RDF::Query::Plan::NamedGraph - Executable query plan for named graphs.
VERSION
This document describes RDF::Query::Plan::NamedGraph version 2.908.
METHODS
Beyond the methods documented below, this class inherits methods from the RDF::Query::Plan class.
"new ( $graph, $plan )"
"execute ( $execution_context )"
"next"
"close"
"graph"
Returns the graph variable.
"pattern"
Returns the query plan that will be used with each named graph in the model.
"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".
AUTHOR
Gregory Todd Williams <gwilliams@cpan.org>
perl v5.14.2 2012-01-31 RDF::Query::Plan::NamedGraph(3pm)