Sponsored Content
Top Forums UNIX for Advanced & Expert Users Passing Hash variable in to sql query in perl Post 302440939 by jam_prasanna on Thursday 29th of July 2010 02:43:06 AM
Old 07-29-2010
can any expert help me on this.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sql query variable not exactly unix

I know htis isnt exactly unix.... but hopefully someone can help me or direct me someplace to get help. I can run sql queries in scripts against my informix db using: dbaccess mydb myquery.sql >> sql.output I need to write my script to select based on todays date. Its very... (5 Replies)
Discussion started by: MizzGail
5 Replies

2. UNIX for Advanced & Expert Users

passing value to a variable in a SQL

Hi Folks, This is a small chunk of the bigger problem which i am facing and some help here will help me resolve the rest of the issue. Problem is that i need to pass the value of a variable from a shell script to a SQL query (infact a lot of SQL's) i have the following solution but somehow... (4 Replies)
Discussion started by: kamitsin
4 Replies

3. Shell Programming and Scripting

script variable within a sql query

I created a script to read a csv file with four columns. The script also saved values of each col in a arry. In the script, i connected to db try to run a query to pull out data baisc on the values from the csv file. select Num from tableName where Sec_Num in ('${isin}') /*isin is an arry... (1 Reply)
Discussion started by: Sherry_Run
1 Replies

4. Shell Programming and Scripting

Problem in Passing sql query for a script

Unix prompt ========= echo "Enter the query" read q ========== User has entered : SELECT * FROM employee ===================== Now the problem starts.. echo $q Output: SELECT "all files names in the PWD" FROM employee ================================================ ... (5 Replies)
Discussion started by: Niroj
5 Replies

5. Shell Programming and Scripting

passing a hash to another script in perl

I have a script (say script1.sh ) and I am calling a script (say script2.sh) within the script1.sh. Here in script1.sh I have a hash ( say %hash1) and i have to pass this hash to script2.sh. Basically i have to do some processing in Scirpt2.sh based on the hash(key,values). I wanted to know how can... (2 Replies)
Discussion started by: ammu
2 Replies

6. Shell Programming and Scripting

Passing a variable from shell script to mysql query?

I heard this was possible but from my research I haven't been able to figure it out yet. Seems it should be simple enough. Basically from a high level view I'm trying to accomplish... . $X='grep foo blah.log' then 'mysql command SELECT foo FROM bar WHERE ' . $X or something like that. ... (2 Replies)
Discussion started by: kero
2 Replies

7. Shell Programming and Scripting

perl - passing hash references to functions

hi there I have the following script in which i have created a PrintHash() function. I want to pass to this function the reference to a hash (in the final code i will be passing different hashes to this print function hence the need for a function). I am getting an error Type of arg 1 to... (1 Reply)
Discussion started by: hcclnoodles
1 Replies

8. Shell Programming and Scripting

Passing variable to sql

How to pass variable to sql file. Im tryin in two ways, Method 1: my.sql select * from table where col1 = '$1' and col2 = 'text'; Method 1execute: dbaccess database my.sql $var Method2: select * from table col1 in (`cat inputfile`) and col2 = 'text'; method... (2 Replies)
Discussion started by: Roozo
2 Replies

9. Shell Programming and Scripting

Passing value of variable to a query within shell script

I have a script in which i connect to database to run a query and get the result of the query to a temp file. This works fine , now what i want is there is flat file which contains the value to be used in the query. I want to read this file line by line and then run the query for each value in that... (7 Replies)
Discussion started by: gpk_newbie
7 Replies

10. Shell Programming and Scripting

Problem in passing IFS array to SQL Query

Hi, I have created a shell script that reads line from text file and insert into DB table. I have used IFS to separate the line text. Looks IFS is splitting text properly but while passing one of the values that has special characters in it to query, it is giving weird issue. Below is my... (2 Replies)
Discussion started by: yuvi
2 Replies
RCCONF(8)                                                        Debian GNU/Linux                                                        RCCONF(8)

NAME
rcconf - Debian Runlevel configuration tool SYNOPSIS
rcconf [options] DESCRIPTION
Rcconf allows you to control which services are started when the system boots up or reboots. It displays a menu of all the services which could be started at boot. The ones that are configured to do so are marked and you can toggle individual services on and off. Rcconf gets a list of services from /etc/init.d and looks in the /etc/rc?.d directories to determine whether each service is on or off. Rcconf detects ON state by existence of /etc/rc?.d/"S"NNname. If the number(NN of /etc/rc?.d/[SK]NNname) is not 20(default), rcconf saves the service name and the number in /var/lib/rcconf/services so as to be able to restore the service to its original configuration. If you purge rcconf package by 'dpkg --purge' or 'aptitude purge' or others, you may lose off state package due to deletion of /var/lib/rcconf/services. OPTIONS
--help Print out a usage message. --dialog Use dialog command to display menu --whiptail Use whiptail command to display menu --notermcheck Do not set window size by terminal property. --on service[,service,...] Set services to be on. This option enables rcconf in command line mode and no select menu will be displayed. --off service[,service,...] Set services to be off. This option enables rcconf in command line mode and no select menu will be displayed. --list List services which includes current status(on/off). This option enables rcconf in command line mode and no select menu will be displayed. Use --expert option together if you want to list all services. This result can be used as config_file of --config. --config config_file Set services on/off according to config_file. This option enables rcconf in command line mode and no select menu will be displayed. The format of this config file is "service_name on" or "service_name off" in each line. Refer to the result of --list. --expert Show and select all services for experts. In default, rcconf doesn't display system default services as a candidate such as mountall.sh to hide unnecessary services for users(but very important for system). The list of which services are considered expert can be found at the line @expertonly in /usr/sbin/rcconf. --now For each service that had the links changed, call the corresponding /etc/init.d/service-name script using invoke-rc.d, so the package starts or stops immediately. If you do not use this option, the changes will only take effect the next time you reboot (or change runlevel). --verbose Output verbose messages. Guide File Rcconf can display some description(Guide) for each services with Guide File. Guide File is placed on /var/lib/rcconf/guide, and this Guide File does not exist by default. If you want to use Guide, you need to define guides for each services in this file. If you run update-rcconf-guide before rcconf, rcconf can use default guides derived from package description. Update-rcconf-guide generates the file '/var/lib/rcconf/guide.default' from package description(only uses first line of it) using apt-cache. Rcconf refers Guides in /var/lib/rcconf/guide before /var/lib/rcconf/guide.default. If you install some packages after executed update-rcconf-guide, you need to re-create this file using update-rcconf-guide so as to refresh guide.default that includes new guides for installed new services. Updating /etc/rd?.c/ by the package(KNOWN PROBLEM) Rcconf saves /etc/rc?.d/[SK]NNname conditions into /var/lib/rcconf/services. This file is updated only when there exists /etc/rc?.d/SNNname. It means that the condition is not saved if /etc/rc?.d/SNNname doesn't exist for the package. If the old version of the package creates both /etc/rc?.d/SNNname and /etc/rc?.d/KNNname but the newer(updated) version of the package creates only /etc/rc?.d/KNNname, some stupid condition occurs. That is, rcconf displays this package as OFF state even as the updated package doesn't have /etc/rc?.d/SNNname. That is because rcconf can't detect disappearance of /etc/rc?.d/SNNname and previous /etc/rc?.d/SNNname condition remains in /var/lib/rcconf/services for restore. In that situation, remove the entry(corresponding package line) from /var/lib/rcconf/services. FILE
/var/lib/rcconf/services The service number data file. /var/lib/rcconf/lock Lock file. /var/lib/rcconf/guide.default Guide File update-rcconf-guide generates. /var/lib/rcconf/guide Guide File user(Administrator) can define. SEE ALSO
update-rc.d(8) update-rcconf-guide(8) AUTHOR
Atsushi KAMOSHIDA <kamop@debian.org> perl v5.10.1 2009-11-17 RCCONF(8)
All times are GMT -4. The time now is 10:58 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy