Sponsored Content
Top Forums Shell Programming and Scripting Run sql query after ssh in UNIX Post 302913994 by vbe on Thursday 21st of August 2014 09:16:40 AM
Old 08-21-2014
Maybe if you explained what you are up to can we help...
Because you have 2 options:
1) You connect using ssh balhblah -c YOURSCRIPT
2) You use a heredoc
(If you dont know what it is: Here Documents )

What you submitted will connect by opening a new shell on server2, the rest will continue to be executed by the script current shell...
This User Gave Thanks to vbe For This Post:
 

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. Shell Programming and Scripting

How to use sql data file in unix csv file as input to an sql query from shell

Hi , I used the below script to get the sql data into csv file using unix scripting. I m getting the output into an output file but the output file is not displayed in a separe columns . #!/bin/ksh export FILE_PATH=/maav/home/xyz/abc/ rm $FILE_PATH/sample.csv sqlplus -s... (2 Replies)
Discussion started by: Nareshp
2 Replies

3. Shell Programming and Scripting

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. #!/usr/bin/perl #database path $dbc='/opt/bin/psql -Userver... (0 Replies)
Discussion started by: sureshcisco
0 Replies

4. Shell Programming and Scripting

run query in shell script after ssh

Hi, I need to run sql query in shell script after getting connected to ssh. For that I connected to ssh through shell script using RSA keys done]. Now when I am running sql query, it's not working... but several other commands like 'ls'. 'mkdir', etc are working properly. Here is my code: ... (2 Replies)
Discussion started by: shekhar2010us
2 Replies

5. 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

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

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

8. 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

9. 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

10. 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
HTMAKE(1)						       GLOBAL cgi Utilities							 HTMAKE(1)

NAME
htmake - create GLOBAL hypertext source searchable by gsearch.cgi SYNOPSIS
htmake [htags options] [--url=base-url] [destdir] DESCRIPTION
htmake is a wrapper script that creates searchable hypertext from program source code and records information into a path database needed for a centralised search mechanism. Prior to using this command you must have installed gsearch.cgi using the htconfig -I option and configured the location of the path data- base in htmake.conf Before you can create the hypertext source you need to execute gtags(1) from the root directory of the source tree. htmake is then called from the same place. htmake uses htags(1) to create the hypertext with a unique id and htconfig(1) to make the required entries in the path database. OPTIONS
The following options will be passed to htags(1) if used. -a Make an alphabetical function index. -c Compress html. Use gzip(1) with .ghtml suffix. -C Compress html. Use gzip(1) with .html.gz suffix. -d tagdir, --tags=gtagsdbpath Specifies the directory in which GTAGS and GRTAGS exist. The default is the current directory. -F Use frames for definition index, file index and main view. -l Make a name tag for each line of hypertext created. -n Print out the line numbers. -t title The title of this hypertext. Defaults to the last component of the current path. --action=cgi-url Specify the location search queries are submitted to. Defaults to the value set in htmake.conf or to http://localhost/cgi-bin/gsearch.cgi The remaining options are more general or are passed to htconfig(1). --url=base-url the base url for your new hypertext source. For best results always use absolute url's here. eg. http://host/~user/mysource It defaults to file:/destdir destdir The directory in which hypertext is generated. The default is ./HTML -v, --verbose Activate the inbuilt screen saver. Give your phosphors a workout. EXAMPLES
$ cd /usr/src/myprog $ gtags $ htmake $ cd /usr/src/myprog $ gtags -c $ htmake -c --url=http://host/~user/prog/HTML /home/user/public_html/prog FILES
/etc/gtags/htmake.conf path database BUGS
As a wrapper htmake gets to inherit bugs from other software too. Isn't life fun. This is alpha software - expect anything! SEE ALSO
htconfig(1), htags(1), gtags(1), global(1). AUTHOR
Ron Lee <ron@debian.org> CREDITS
Thanks to Shigio Yamaguchi <shigio@gnu.org> for creating GLOBAL and releasing it as free software. A truly cool productivity tool! Debian GNU/Linux 27 March 1999 HTMAKE(1)
All times are GMT -4. The time now is 08:17 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy