06-18-2008
hi andom,
thanks for replying.. actually i am connecting sqlplus from a shell script..i will be writing the sql queries onto a .sql file and will be given as input to sqlplus...
i tried the spool command as you said..
sql.sql file will be having -
spool \tmp\resultfile.lst
select STATEMENT
spool off;
exit
sqlplus -s user/pass@db @sql.sql
what i am expecting is to get the spooled .lst output of this select query..
what i know is that if i am spooling some file, then i will be getting a .lst file as the output.. if i am wrong then correct me please..
but after exiting from the sqlplus i cant find this resultfile in the tmp directory ! ..i want to use that file ..
can anyone help me...
thanks,
Krips.
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Does anybody know if HP-UX uses any other directories besides /var/spool/lp/request to spool print jobs? I checked the man pages, and it only mentions /var/spool/lp in general. I was just wondering if anyone knew of some other place it might possibly use. thanks in advance for any help! (2 Replies)
Discussion started by: doeboy
2 Replies
2. UNIX for Dummies Questions & Answers
Hi
From shell script i am invoking sqlplus to connect to oracle database and then i spool a csv file as with output. What i want to do is to change the file name with timestamp on it so after spooling finish shell script change file name with time stamp.
can someone help me to do that .
Thanks... (2 Replies)
Discussion started by: ukadmin
2 Replies
3. Shell Programming and Scripting
Hi,
I want to spool the output from a .sql file to a .txt file through shell script.
the contents of .sql are:
spool /arboru02/scripts/customer_profile_def.txt
select profile_id ||','|| account_no
from customer_profile_def;
spool off
exit
and shell scrip is like:
#!/bin/sh... (9 Replies)
Discussion started by: ss_ss
9 Replies
4. Red Hat
Hello all,
I need to setup a print server that listens on three separate network interfaces, and sends jobs to the corresponding print queue. Example:
192.168.69.100 - printer1 -> Out to 139.177.69.100:9100
192.168.69.101 - printer2 -> Out to 139.177.69.101:9100
192.168.69.102 - printer2 ->... (3 Replies)
Discussion started by: ZekesGarage
3 Replies
5. UNIX for Dummies Questions & Answers
Hi
I have done a search for this but couldn't find much on it.
I am creating a tar file with the command below
tar cvf /export/home/user/backup/*Will this is being created I have a job spooling to 5 texts files in the following directory /export/home/user/backup/STATS/
The tar files... (1 Reply)
Discussion started by: sgarvan
1 Replies
6. Shell Programming and Scripting
Hi ,
Im spooling file from oracle to csv using shell script. Below is the code im using.. The o/p is not coming in right format.. Please help me out in this..
O/p is coming as header till batch id ,im not able to see date_stored,type,type1..
Please any one can give me some suggestion
... (1 Reply)
Discussion started by: jkumsi
1 Replies
7. Shell Programming and Scripting
Hi everyone and nice to meet you :)
I'm having some issues with a script I'm writing.
It's probably most chaotic, I'm no ksh guru, but the idea is to extract an ID with that query, spool it into a file, and read that file making the ID a variable. This has to be done for every row extracted by... (10 Replies)
Discussion started by: Arkadia
10 Replies
8. Shell Programming and Scripting
Hi,
I am extracting the records of a table from oracle into a csv file using spool command in unix script. I retrieve the error message as
msgcnt 18512 vxfs: mesg 001: vx_nospace - /dev/vg02/lvol12 file system full (1 block extent)
How to resolve it ? (4 Replies)
Discussion started by: sabural
4 Replies
9. UNIX for Dummies Questions & Answers
Hi Guys,
Another questions to the genius over here. I have spool the dataf from the database into a .csv file. But can it be possible to have all the rows and column with the boundaries..for example the .csv file which i have is as below:
20140327 BU 9A 3
20140327 SPACE 9A 3
20140327... (8 Replies)
Discussion started by: Pramod_009
8 Replies
10. UNIX for Beginners Questions & Answers
Hi, I need to write a script that will run a simple select count(*) query and sends the result of that query to me via email.
Here's what I already have.
#!/bin/ksh
######################################################################
# File Name : counts.sh
# Created : 2019/27/19... (1 Reply)
Discussion started by: clef
1 Replies
LEARN ABOUT LINUX
faxabort
FAXABORT(8) System Manager's Manual FAXABORT(8)
NAME
faxabort - tell a HylaFAX server to abort a receive
SYNOPSIS
/usr/sbin/faxabort [ -q dir ] modem
DESCRIPTION
faxabort sends a message to a HylaFAX faxgetty(8) process servicing modem telling it to abort any active receive operation.
The specified modem can either be the name (typically the last component of the terminal port the modem is attached to), or the full name
of the associated FIFO named pipe file, e.g. ``FIFO.ttym2''.
Note that to abort a send operation the faxrm(1) command must be used.
OPTIONS
-q dir Use a spooling area other than /var/spool/hylafax.
NOTES
On some systems it is not possible to abort a received facsimile because of problems in the operating system; on such systems the message
sent by faxabort will be (silently) ignored.
FILES
/var/spool/hylafax default spooling area
/var/spool/hylafax/FIFO fifo for contacting faxq
Consult hylafax-server(5) for a complete discussion of the structure and content of the spooling area.
SEE ALSO
hylafax-server(5), faxq(8), faxgetty(8)
March 3, 1995 FAXABORT(8)