Sponsored Content
Top Forums Shell Programming and Scripting Get SQL query result to file in putty Post 302905364 by Gautham on Wednesday 11th of June 2014 06:56:46 AM
Old 06-11-2014
Through what database you run your SQL Query ?.

In mySQL:
Code:
SELECT * FROM TABLE INTO OUTFILE '/your_location/filename';

In postgresql:

Code:
\o /your_location/filename/
SELECT * FROM TABLE;
\o


Last edited by Gautham; 06-11-2014 at 08:15 AM.. Reason: updated code
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

unloading sql query to file

In unload to "/usr/home/data.012202" I wish to use a date variable as in unload to "/usr/home/data.`date`" for the file is that possible in a query to do, or will i need to add a mv command after the query to do it. I tried backquotes, , and () on `date` but didn't seem to work Thanks... (2 Replies)
Discussion started by: Link_02
2 Replies

2. Shell Programming and Scripting

any possible to run sql result and output to file

Hi, I search all post...and no soluation about..if i would like to run a sql statement and output the result to txt file. for example, i usually run "sql" to logon the database and run select statement. Then I need to copy the output into the result.txt. Can I run the script to do this... (7 Replies)
Discussion started by: happyv
7 Replies

3. Shell Programming and Scripting

Redirecting sql select query result to txt file

Hi , I just found you while surfing for the string 'Redirecting sql select query output from within a shell script to txt file/excel file' Could you find time sending me the code for the above question? It'll be great help for me. I have a perl file that calls the sql file... (1 Reply)
Discussion started by: dolphin123
1 Replies

4. Shell Programming and Scripting

Redirecting sql select query result to txt file

Hi Yogesh, Lucky that i caught you online. Yeah i read about DBI and the WriteExcel module. But the server is not supporting these modules. It said..."Cannot locate DBI"..."Cannot locate Spreadsheet::WriteExcel" I tried creating a simple text file to get the query output, but the... (1 Reply)
Discussion started by: dolphin123
1 Replies

5. Shell Programming and Scripting

How to Format the result driven from a SQL Query

Hi All, I want to format the result driven from the query into neat format. For example pls find the below code, #! /bin/sh result=' sqlplus -s uname/passwrd@DBname select no,name,address,ph_no, passport_no,salary,designation from emp_table where salary>1000; exit EOF' ... (8 Replies)
Discussion started by: little_wonder
8 Replies

6. UNIX for Dummies Questions & Answers

How do I use SQL to query based off file data?

This is basically what I want to do: I have a file that contains single lines of IDs. I want to query the oracle database using these IDs to get a count of which ones match a certain condition. the basic idea is: cat myfile | while read id do $id in select count(PC.ptcpnt_id) from... (4 Replies)
Discussion started by: whoknows
4 Replies

7. Shell Programming and Scripting

redirecting sql query output to a file

Hi, I am executing sql files in my unix shell script. Now i want to find whether its a success or a failure record and redirect the success or failure to the respective files. meaning. success records to success.log file failure record to failure.log file. As of now i am doing like... (1 Reply)
Discussion started by: sailaja_80
1 Replies

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

9. UNIX for Advanced & Expert Users

Output the SQL Query result to a File

Hello Guys, This message is somewhat relates with last thread. But I need to re-write thing. I start over a little. I am stuck now and need your help. Here is my script- #! /bin/ksh export ORACLE_HOME=/opt/oracle/app/oracle/product/9.2 /opt/oracle/app/oracle/product/9.2/bin/sqlplus -s... (5 Replies)
Discussion started by: thepurple
5 Replies

10. Programming

Oracle simple SQL query result in: ORA-08103: object no longer exists

Dear community, please help with a query on Oracle. I'm using SQLPlus (but with SQLDeveloper is the same) to accamplish a sinple query like: select count(*) from ARCHIT_D_TB where (TYP_ID=22 OR TYP_ID=23) and SUB_TM like '%SEP%' and CONS=1234This is a very simple query that works perfect until... (5 Replies)
Discussion started by: Lord Spectre
5 Replies
putty(1)							 PuTTY tool suite							  putty(1)

NAME
putty - GUI SSH, Telnet and Rlogin client for X SYNOPSIS
putty [ options ] [ host ] DESCRIPTION
putty is a graphical SSH, Telnet and Rlogin client for X. It is a direct port of the Windows SSH client of the same name. OPTIONS
The command-line options supported by putty are: --display display-name Specify the X display on which to open putty. (Note this option has a double minus sign, even though none of the others do. This is because this option is supplied automatically by GTK. Sorry.) -fn font-name Specify the font to use for normal text displayed in the terminal. -fb font-name Specify the font to use for bold text displayed in the terminal. If the BoldAsColour resource is set to 1 (the default), bold text will be displayed in different colours instead of a different font, so this option will be ignored. If BoldAsColour is set to 0 and you do not specify a bold font, putty will overprint the normal font to make it look bolder. -fw font-name Specify the font to use for double-width characters (typically Chinese, Japanese and Korean text) displayed in the terminal. -fwb font-name Specify the font to use for bold double-width characters (typically Chinese, Japanese and Korean text). Like -fb, this will be ignored unless the BoldAsColour resource is set to 0. -geometry geometry Specify the size of the terminal, in rows and columns of text. See X(7) for more information on the syntax of geometry specifica- tions. -sl lines Specify the number of lines of scrollback to save off the top of the terminal. -fg colour Specify the foreground colour to use for normal text. -bg colour Specify the background colour to use for normal text. -bfg colour Specify the foreground colour to use for bold text, if the BoldAsColour resource is set to 1 (the default). -bbg colour Specify the foreground colour to use for bold reverse-video text, if the BoldAsColour resource is set to 1 (the default). (This colour is best thought of as the bold version of the background colour; so it only appears when text is displayed in the background colour.) -cfg colour Specify the foreground colour to use for text covered by the cursor. -cbg colour Specify the background colour to use for text covered by the cursor. In other words, this is the main colour of the cursor. -title title Specify the initial title of the terminal window. (This can be changed under control of the server.) -sb- or +sb Tells putty not to display a scroll bar. -sb Tells putty to display a scroll bar: this is the opposite of -sb-. This is the default option: you will probably only need to spec- ify it explicitly if you have changed the default using the ScrollBar resource. -log filename This option makes putty log all the terminal output to a file as well as displaying it in the terminal. -cs charset This option specifies the character set in which putty should assume the session is operating. This character set will be used to interpret all the data received from the session, and all input you type or paste into putty will be converted into this character set before being sent to the session. Any character set name which is valid in a MIME header (and supported by putty) should be valid here (examples are `ISO-8859-1', `windows-1252' or `UTF-8'). Also, any character encoding which is valid in an X logical font description should be valid (`ibm- cp437', for example). putty's default behaviour is to use the same character encoding as its primary font. If you supply a Unicode (iso10646-1) font, it will default to the UTF-8 character set. Character set names are case-insensitive. -nethack Tells putty to enable NetHack keypad mode, in which the numeric keypad generates the NetHack hjklyubn direction keys. This enables you to play NetHack with the numeric keypad without having to use the NetHack number_pad option (which requires you to press `n' before any repeat count). So you can move with the numeric keypad, and enter repeat counts with the normal number keys. -help, --help Display a message summarizing the available options. -pgpfp Display the fingerprints of the PuTTY PGP Master Keys, to aid in verifying new files released by the PuTTY team. -load session Load a saved session by name. This allows you to run a saved session straight from the command line without having to go through the configuration box first. -ssh, -telnet, -rlogin, -raw, -serial Select the protocol putty will use to make the connection. -l username Specify the username to use when logging in to the server. -L [srcaddr:]srcport:desthost:destport Set up a local port forwarding: listen on srcport (or srcaddr:srcport if specified), and forward any connections over the SSH con- nection to the destination address desthost:destport. Only works in SSH. -R [srcaddr:]srcport:desthost:destport Set up a remote port forwarding: ask the SSH server to listen on srcport (or srcaddr:srcport if specified), and to forward any con- nections back over the SSH connection where the client will pass them on to the destination address desthost:destport. Only works in SSH. -D [srcaddr:]srcport Set up dynamic port forwarding. The client listens on srcport (or srcaddr:srcport if specified), and implements a SOCKS server. So you can point SOCKS-aware applications at this port and they will automatically use the SSH connection to tunnel all their connec- tions. Only works in SSH. -P port Specify the port to connect to the server on. -A, -a Enable (-A) or disable (-a) SSH agent forwarding. Currently this only works with OpenSSH and SSH-1. -X, -x Enable (-X) or disable (-x) X11 forwarding. -T, -t Enable (-t) or disable (-T) the allocation of a pseudo-terminal at the server end. -C Enable zlib-style compression on the connection. -1, -2 Select SSH protocol version 1 or 2. -i keyfile Specify a private key file to use for authentication. For SSH-2 keys, this key file must be in PuTTY's format, not OpenSSH's or any- one else's. -sercfg configuration-string Specify the configuration parameters for the serial port, in -serial mode. configuration-string should be a comma-separated list of configuration parameters as follows: o Any single digit from 5 to 9 sets the number of data bits. o `1', `1.5' or `2' sets the number of stop bits. o Any other numeric string is interpreted as a baud rate. o A single lower-case letter specifies the parity: `n' for none, `o' for odd, `e' for even, `m' for mark and `s' for space. o A single upper-case letter specifies the flow control: `N' for none, `X' for XON/XOFF, `R' for RTS/CTS and `D' for DSR/DTR. SAVED SESSIONS
Saved sessions are stored in a .putty/sessions subdirectory in your home directory. MORE INFORMATION
For more information on PuTTY, it's probably best to go and look at the manual on the web page: http://www.chiark.greenend.org.uk/~sgtatham/putty/ BUGS
This man page isn't terribly complete. PuTTY tool suite 2004-03-24 putty(1)
All times are GMT -4. The time now is 03:51 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy