Shell Programming and Scripting

How to Get SQL query result to file in putty?

I have one SQL query and I want that query output to be redirected to the file.

Code:

 uname -a
SunOS XXX 5.8 Generic_117350-58 sun4u sparc SUNW,Sun-Fire-480R

Please suggest.

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

try

Code:

sqlplus -s ${DB_LOGON} <<EOSQL
WHENEVER SQLERROR EXIT FAILURE;
WHENEVER OSERROR EXIT FAILURE;
spool output.file
select * from dual;
spool off
EOSQL

Thanks for the quick answers.

but how we can do it for isql ?

iirc, isql supports -o <output file>.

At the risk of being pedantic, but to clarify what may be some fuzzy thinking, putty is just a terminal program - one of several that do exactly the same thing. All it does is take keystrokes from your keyboard and send them to a remote system to be processed, then receive and display whatever character strings the remote system produces in response. It has nothing in particular to do with getting SQL query result into a file.

As others are pointing out, how to get the query result into a file is a function of whatever program is actually processing your query - the client program to whatever your rdbms system is.

Also, be aware that however that file is created (like oracle's sqlplus SPOOL command) it will be created on that remote system. If you need to get the file from the remote system to your desktop where you are running putty, that is a different question.

Please clarify your exact requirement.

Yes agreed, But many times we don't have many options.
I have only putty to access this DB and I want to validate there itself. You should understand that there are many things which are not in our hand in actual world.(basically in any bank)
Then we have to try within our boundaries itself. Don't have any options .
I have tried all the inputs given in this post but nothing is working for me.
Please suggest how I can achieve this.

Thanks,
Pamu