Sponsored Content
Top Forums Shell Programming and Scripting Run sql query after ssh in UNIX Post 302914041 by Corona688 on Thursday 21st of August 2014 12:51:27 PM
Old 08-21-2014
What is preventing you from doing so? What have you tried?
 

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
ntp.conf(5)							File Formats Manual						       ntp.conf(5)

Name
       ntp.conf - Network Time Protocol configuration file

Description
       The  file  is the configuration file for the Network Time Protocol (NTP) daemon, This file must be configured on your system before running
       Any host names that you specify in the file must have an entry in the file, or an entry in the master database, if the  database  is  being
       served to your system by BIND/Hesiod or Yellow Pages.

       The file has four entry formats:

       trusting no
	    This entry guarantees that your system synchronizes only to the NTP servers identified in the peer and server entries specified.  Dig-
	    ital recommends that all systems include the entry.

       peer server
	    This entry identifies server as one of the NTP servers that your system trusts, and from which your system will accept  time  synchro-
	    nization.	 Your  system  may  also  provide time synchronization to this server.	Servers can be identified by host name or internet
	    address.

	    NTP servers should be configured with entries.

       server server
	    This entry identifies server as one of the NTP servers that your system trusts, and from which your system will accept  time  synchro-
	    nization.	Your  system  can  not	provide  time  synchronization to this server.	Servers can be identified by host name or internet
	    address.

	    NTP clients should be configured with entries.

       peer   /dev/null       LOCL    1       -5      local
	    This entry identifies your system as a local reference clock.  A local reference clock is the most accurate system clock available	at
	    your  site.   If you receive time synchronization from the Internet NTP service, you should not include this entry on any of your sys-
	    tems.  At most, one system in a set of nodes running should be identified as a local reference clock.

	    A host which specifies this entry should not specify any or entries.

Examples
       This is a sample configuration file for an NTP client which receives time synchronization from the NTP servers: and Lines beginning with  a
       number sign (#) are comments.
       #
       #	       NTP  Configuration File
       #	This file is mandatory for the ntpd daemon
       #
       #
       #
       #   **  A L L  **
       #
       #  "trusting no" prevents this host from synchronizing
       #   to any host that is not listed below.  It is recommended
       #   that all hosts include the line "trusting no".
       #
       trusting no
       #
       #
       #    **	S E R V E R  **
       #
       #  If you are configuring a server, use "peer" entries to
       #  synchronize to other NTP servers.  For example, server1,
       #  server2, and server3.
       #
       #peer	      server1
       #peer	      server2
       #peer	      server3
       #
       #
       #
       #
       #    **	C L I E N T  **
       #
       #  If you are configuring a client, use "server" entries to
       #  synchronize to NTP servers.  For example, server1, server2,
       #  and server3.
       #
       server	      server1
       server	      server2
       server	      server3
       #
       #
       #
       #    **	L O C A L   R E F E R E N C E	C L O C K  **
       #
       #  If you are configuring a local reference clock, include the
       #  following entry and the "trusting no" entry ONLY.
       #
       #peer	 /dev/null LOCL 1    -5   local
       #

See Also
       ntp(1), ntpd(8), ntpdc(8)
       RFC 1129--Internet time synchronization:  The Network Time Protocol
       Introduction to Networking and Distributed System Services

																       ntp.conf(5)
All times are GMT -4. The time now is 10:04 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy