Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

run sql query via perl script

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting run sql query via perl script
# 1  
Old 08-03-2010
run sql query via perl script
Hello,

If I run this command on the server it works.
# dbc "update config set radio_enabled = 0;"

how can I execute the same command in perl. I have defined the dbc path. Can any one please correct the last line.

Code:
 
#!/usr/bin/perl
 
#database path
$dbc='/opt/bin/psql -Userver server -c '

`$dbc "update config set radio_enabled = 0;"`;

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Run sql query in shell script and output data save as delimited text

I want to run sql query in shell script and output data save as delimited text (delimited text would be comma) Code: SPOOL_FILE=/pgedw/dan.txt SQL=/pgedw/dan.sql sqlplus -s username/password@myhost:port/servicename <<EOF set head on set COLSEP , set linesize 32767 SET TRIMSPOOL ON SET... (8 Replies)
Discussion started by: Jaganjag
8 Replies

2. Shell Programming and Scripting

Run sql query after ssh in UNIX

I am running this test.ksh on server1. It successfully logins to server2 but runs the queries of query.sql on server1. query.sql is present in both server1 and server2 Can anybody please help. I need to run queries on server2 itself.:confused: Below is the test script... (10 Replies)
Discussion started by: shruthimithra
10 Replies

3. UNIX for Dummies Questions & Answers

Script to run sql query.

Please read How To Ask Questions The Smart Way (1 Reply)
Discussion started by: balu_279013
1 Replies

4. Shell Programming and Scripting

Shell script to run sql query having a long listing of parameters

Hi, I have a query regarding execution of a sql query having long listing of parameters ..I need to execute this query inside a shell script. The scenario is like.... Suppose I have a file abc.txt that has the card numbers..it could be in thousands.. then I need to fire a query like ... (12 Replies)
Discussion started by: vsachan
12 Replies

5. Shell Programming and Scripting

Run SQL thru shell script: how to get a new line when run sql query?

Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database. I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :( What should I do? I'm not sure that... (2 Replies)
Discussion started by: Kapom
2 Replies

6. Shell Programming and Scripting

How to run a SQL select query in Oracle database through shell script?

I need to run a SQL select query in Oracle database and have to capture the list of retrieved records in shell script. Also i would like to modify the query for certain condition and need to fetch it again. How can i do this? Is there a way to have a persistent connection to oracle database... (9 Replies)
Discussion started by: vel4ever
9 Replies

7. Shell Programming and Scripting

perl- oracle sql query

Hi, I am new to perl.How to query oracle database with perl??? Thanks (1 Reply)
Discussion started by: tdev457
1 Replies

8. Shell Programming and Scripting

Need help to run sql query from a script..which takes input from a file

I need to run sql script from shell script which takes the input from a file and contents of file will be like : 12345 34567 78657 and query will be like : select seq_nbr from bus_event where event_nbr='12345'; select seq_nbr from bus_event where event_nbr='34567'; select seq_nbr... (1 Reply)
Discussion started by: rkrish
1 Replies

9. Shell Programming and Scripting

Need help in printing a sql query in perl

Hi All, I have the following sql query select abcd from udbadm.log where xyz='1'. I have 16k queries similar to this with different values for xyz. I want to print the values of 'abcd' for each row. I have the following perl code, but not sure how i can print that particular... (1 Reply)
Discussion started by: userscript
1 Replies

10. Shell Programming and Scripting

Incorrect SQL query in perl

I the the following perl script, however it does not return anything. Did i form my syantax wrongly? $sth=$dbh->prepare("select a.rowid,a.* from Table1 a where a.field1 = \'$Indicator1\' and a.schedule = \'$Indicator2\' and a.lastdate <= sysdate"); $sth->execute() ... (1 Reply)
Discussion started by: new2ss
1 Replies
Login or Register to Ask a Question

LEARN ABOUT DEBIAN

asp-perl

ASP-PERL(1p)						User Contributed Perl Documentation					      ASP-PERL(1p)

NAME

       asp-perl - Apache::ASP CGI and command line script processor

SYNOPSIS

       asp-perl [-hsdb] [-f asp.conf] [-o directory] file1 @arguments file2 @arguments ...

	   -h  Help you are getting now!
	   -f  Specify an alternate configuration file other than ./asp.conf
	   -s  Setup $Session and $Application state for script.
	   -d  Set to debug code upon errors.
	   -b  Only return body of document, no headers.
	   -o  Output directory, writes to files there instead of STDOUT
	   -p  GlobalPackage config, what perl package are the scripts compiled in.

DESCRIPTION

       This program will run Apache::ASP scripts from the command line.  Each file that is specified will be run, and the $Request->QueryString()
       and $Request->Form() data will be initialized by the @arguments following the script file name.

       The @arguments will be written as space separated words, and will be initialized as an associate array where %arguments = @arguments.  As
       an example:

	asp-perl file.asp key1 value1 key2 value2

       would be similar to calling the file.asp in a web environment like

	/file.asp?key1=value1&key2=value2

       The asp.conf script will be read from the current directory for parameters that would be set with PerlSetVar normally under mod_perl.  For
       more information on how to configure the asp.conf file, please see < http://www.apache-asp.org/cgi.html >

SEE ALSO

       perldoc Apache::ASP, and also http://www.apache-asp.org

COPYRIGHT

       Copyright 1998-2004 Joshua Chamas, Chamas Enterprises Inc.

       This program is distributed under the GPL.  Please see the LICENSE file in the Apache::ASP distribution for more information.

perl v5.14.2							    2011-08-15							      ASP-PERL(1p)