06-24-2008
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 data was just thrown into the text file. There was no format.
How should i include code in sql file (containg the select query) so that the output to the text file is formatted neately with tab.
Kindly help.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have about 12 columns and 15 rows to be retrived from sybase isql command through unix. But when i output the sql into a file and see it, the formatting is going for a toss. can someone please suggest how can i get the result correctly in the output file ?
Thanks,
Sateesh (2 Replies)
Discussion started by: kotasateesh
2 Replies
2. Shell Programming and Scripting
how to convert the result of the select query to comma seperated data and put in a .csv file using korn shell.
Pls help me as its very urgent.
Thanks,
Hema. (1 Reply)
Discussion started by: Hemamalini
1 Replies
3. Shell Programming and Scripting
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
Can someone tell me why I'm getting error when I try to run this?
#!/bin/csh -f
source ~/.cshrc
#
set SQLPLUS = ${ORACLE_HOME}/bin/sqlplus
#
set count=`$SQLPLUS -s ${DB_LOGIN} << END
select count(1) from put_groups where group_name='PC' and description='EOD_EVENT' and serial_number=1;... (7 Replies)
Discussion started by: gregrobinsonhd
7 Replies
5. Shell Programming and Scripting
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. Shell Programming and Scripting
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
7. Shell Programming and Scripting
So, I would like to run differen select queries on multiple databases..
I made a script wich I thought to be called something like..
./script.sh sql_file_name out.log
or to enter select statement in a command line..
(aix)
and I did created some shell script wich is not working..
it... (6 Replies)
Discussion started by: bongo
6 Replies
8. UNIX for Advanced & Expert Users
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
9. Shell Programming and Scripting
Hi
I want ot save SQL query result in one txt file. for that i have written one code line
sqlplus -s $dbstring @/usr/local/bin/sched/nightly_Cronjob/exec_123.sql >> /usr/local/bin/sched/nightly_Cronjob/result.txt
but it is not working .
database : Oracle
so please advice me how can i... (7 Replies)
Discussion started by: Himanshu_soni
7 Replies
10. 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.
uname -a
SunOS XXX 5.8 Generic_117350-58 sun4u sparc SUNW,Sun-Fire-480R
Please suggest. (7 Replies)
Discussion started by: pamu
7 Replies
LEARN ABOUT DEBIAN
jifty::dbi::filter::yaml
Jifty::DBI::Filter::YAML(3pm) User Contributed Perl Documentation Jifty::DBI::Filter::YAML(3pm)
NAME
Jifty::DBI::Filter::YAML - This filter stores arbitrary Perl via YAML
SYNOPSIS
use Jifty::DBI::Record schema {
column my_data =>
type is 'text',
filters are qw/ Jifty::DBI::Filter::YAML /;
};
my $thing = __PACKAGE__->new;
$thing->create( my_data => { foo => 'bar', baz => [ 1, 2, 3 ] } );
my $my_data = $thing->my_data;
while (my ($key, $value) = %$my_data) {
# do something...
}
DESCRIPTION
This filter provides the ability to store arbitrary data structures into a database column using YAML. This is very similar to the
Jifty::DBI::Filter::Storable filter except that the YAML format remains human-readable in the database. You can store virtually any Perl
data, scalar, hash, array, or object into the database using this filter.
In addition, YAML (at least the storage of scalars, hashes, and arrays) is compatible with data structures written in other languages, so
you may store or read data between applications written in different languages.
METHODS
encode
This method is used to encode the Perl data structure into YAML formatted text.
decode
This method is used to decode the YAML formatted text from the database into the Perl data structure.
IMPLEMENTATION
This class will attempt to use YAML::Syck if it is available and then fall back upon YAML. This has been done because the Syck library is
written in C and is considerably faster.
SEE ALSO
Jifty::DBI::Filter, YAML, YAML::Syck
AUTHOR
Andrew Sterling Hanenkamp <hanenkamp@cpan.org>
LICENSE
This program is free software and may be modified or distributed under the same terms as Perl itself.
perl v5.14.2 2010-09-21 Jifty::DBI::Filter::YAML(3pm)