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 302684579 by Corona688 on Thursday 9th of August 2012 06:43:29 PM
Old 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

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

cgi::application::plugin::devpopup::query

Query(3pm)						User Contributed Perl Documentation						Query(3pm)

NAME

       CGI::Application::Plugin::DevPopup::Query - show CGI query in DevPopup window

SYNOPSIS

	   use CGI::Application::Plugin::DevPopup;
	   use CGI::Application::Plugin::DevPopup::Query;

	   The rest of your application follows
	   ...

DESCRIPTION

       This module is a plugin for CGI::Application::Plugin::DevPopup.	Whenever used, it creates two sections in the DevPopup output.	First
       section, "Current Run Mode", shows name of run mode executed.  Second section, "CGI Query", contains a list of CGI query parameters and
       associated values passed to your CGI::Application.

       See "query()" in CGI::Application and CGI.pm for more information about query parameters.

VERSION

       1.03

SUBROUTINES
/METHODS
       No public methods for this module exist.

DEPENDENCIES

       CGI::Application::Plugin::DevPopup

CONFIGURATION AND ENVIRONMENT

       N/A

DIAGNOSTICS

       N/A

SEE ALSO

       CGI::Application::Plugin::DevPopup, CGI::Application

INCOMPATIBILITIES

       Not known.

BUGS AND LIMITATIONS

       Not known.

AUTHOR

       Serguei Trouchelle, <mailto:stro@cpan.org>

       Most of code is based by CGI::Application::Plugin::DevPopup by Rhesa Rozendaal, <mailto:rhesa@cpan.org>

LICENSE AND COPYRIGHT

       This module is distributed under the same terms as Perl itself.

       Copyright (c) 2009-2011 Serguei Trouchelle

perl v5.12.4							    2011-11-01								Query(3pm)
All times are GMT -4. The time now is 01:31 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy