connecting to remote db from unix script Post: 302134904

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Connecting and Querying DB2 database from Unix Script?

I am trying to develop a script that can connect to a DB2 database mainframe and Query the database and display the results. I've been researching, but I have yet to find a definitive solution where I can enter in the Mainframe DB2 address db2:// and query the database and return the results. If...

2. Shell Programming and Scripting

Connecting to remote unix server using java?

I need help writing java code that can connect to a remote unix server, and run a script on that server. I have scoured the internet, but I have been unable to find proper documentation on how this can be accomplished. Any help is appreciated thanks.

3. Shell Programming and Scripting

ssh script for connecting unix system.

Hi All, I've a log file call netbackup.log in all the 5 servers in location usr/netbackup.log. I dont want to login in each server and check the log file. So i wanted to have a script written to have the log information at one place. I want to have the last 2 lines from the file...

4. Ubuntu

Connecting to a remote server

Hi, I have an interesting problem. I cannot connect to a personal server I set up. What's interesting is that I can connect to it from the LAN using its non-local IP address. However, I cannot seem to connect to it from anywhere else. Here's how my server is set up: My entire home has a...

5. UNIX for Advanced & Expert Users

Unix FTP Script connecting through proxy Not working

Hi All, can some one please help me to solve this issue, its urgent:confused: We need to FTP a file form our Unix server to an external client FTP location. I am trying to connect to the proxy server first and then use the below USER comment to connect to the external FTP server, and its working...

6. Shell Programming and Scripting

connecting to table to extract multiple rows into file from unix script

I need to extract the data from oracle table and written the below code. But it is not working.There is some problem with the query and output is shown is No rows selected" . If I run the same query from sql developer there is my required output. And if I run the shell script with simple sql...

7. Shell Programming and Scripting

Triggering remote UNIX shell script from Remote desktop

I m trying to run a batch script in remote desktop which executes unix commands on the unix server...the problem is i wnt the output in HTML format.so in my batch script i m giving the cmd like ssh hostname path ksh HC_Report.ksh>out.html ...but it generates the HTML file in remote desktop .i...

8. UNIX for Dummies Questions & Answers

SQL block in a Shell Script connecting to a local and remote DB

Hi All, In a Shell scriipt with a SQL block I want to issue a query against a local DB and a remote DB on a remote server. The shell script is running locally. This is how I connect to the local server. But I want the query to reference remote table in the join. Question can I specify a...

9. Shell Programming and Scripting

Connecting to remote host

Checking crontab job entry in 3 different hosts Hi Gurus, I am trying to connect to remote host from current host to check crontab entries. I have started like this ssh -n -l db2psp 205.191.156.17 ". ~/.profile >/dev/null 2>/dev/null; cd log ;ls | wc -l" I got this error ? ssh:...

10. Shell Programming and Scripting

Connecting to Windows server from UNIX through script

I am trying to connect to a Windows server say 10.1.1.10. This servers has a folder named RAJ in which there are multiple .zip files. All these zip files contain a text file called XYZ.txt. Now i have to merge the content of these XYZ.txt files from each of the .zip file and create a new text...

LEARN ABOUT DEBIAN

gretl

gretl(1)							   econometrics 							  gretl(1)

NAME

       gretl - GNU Regression, Econometrics and Time-series Library

SYNOPSIS

       gretl [ options ] [ datafile | scriptfile | sessionfile ]

DESCRIPTION

       gretl  is  an econometrics package, built around a shared library which may be accessed using a command-line client program (gretlcli) or a
       graphical user interface (gretl_x11).  The program gretl is a wrapper script that calls the GUI if the DISPLAY environment variable is set,
       otherwise the command-line client.

       For  details,  please  start up either the GUI or the command-line client and consult the online help, or read the printed manual, which is
       available in PDF format via the gretl website, http://gretl.sourceforge.net.

OPTIONS

       These are the options supported by the gretl_x11 program; gretlcli is a little different.

       -r script, --run script

	      Open a script.

       -c, --dump

	      Dump the configuration file.

       -d database, --db database

	      Open a local database.

       -e, --english

	      Force use of English.

       -r script, --run script

	      Open a script.

       -w database, --webdb database

	      Open a remote database.

       -h, --help

	      Give help information and exit.

       -v, --version

	      Give version information and exit.

FILES

       ~/.gretl2rc per-user configuration file

       ~/.gretl directory for user runtime files

ENVIRONMENT VARIABLES

       HOME   Specifies the user's home directory

       DISPLAY
	      Specifies the X window display to use

SEE ALSO

       gretlcli(1)

AUTHOR

       The gretl team

The gretl team							       1.9.5								  gretl(1)