By "spool" you mean by virtue of the ">result.txt", not the Oracle SPOOL command, right? Since it's not there.
Is there any reason you remove the file in your while-loop?
Yes, the "spool" would be the result.txt, sorry for the mislead :P
I remove it because of the second function doCSVSQL. Since it's another SQL file it doesn't go well with multiple records, so I delete and create it again to only have 1 record inside it.
And yes, I know it's brutal :P I tried making a variable like this:
Code:
customer_id=$(-query)
But I got a "Line too long" error.
Again, I'm sorry if this is a mess, but thanks
I'm gonna try and remove the delete part and the second function right now and see how it works.
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)
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)
Since I'm not an expert in shell scripting, I have question on sending script result to file. I have script like this...
if condition=0: then
echo "service is not running" | mail -s "Server Status" uname@companyname
fi
sleep 10
if configtion=1: then
echo "service is not running" | mail -s... (3 Replies)
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)
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)
Hello,
How can I run this script every 1 hour and save its result to result.txt
ifconfig | grep 'inet addr:'| grep -v '127.0.0.1' | cut -d: -f2 | awk '{ print $1}'
Regards
Shaan (5 Replies)
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)
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)
Hello all,
I am trying to spool a SQL query output file from back-end to desktop in a certain path but it didn't work,the query writes the output in a file in the same directory at the back-end.
note : i use the same query in sql developper and file was created in the desired path fine
code... (1 Reply)
Discussion started by: bmaksoud
1 Replies
LEARN ABOUT NETBSD
lprm
LPRM(1) BSD General Commands Manual LPRM(1)NAME
lprm -- remove jobs from the line printer spooling queue
SYNOPSIS
lprm [-] [-P printer] [-w maxwait] [job# ...] [user ...]
DESCRIPTION
lprm will remove a job, or jobs, from a printer's spool queue. Since the spooling directory is protected from users, using lprm is normally
the only method by which a user may remove a job. The owner of a job is determined by the user's login name and host name on the machine
where the lpr(1) command was invoked.
Options and arguments:
-Pprinter
Specify the queue associated with a specific printer (otherwise the default printer is used).
-w maxwait
Specify the maximum time to wait in seconds for remote responses. The default is 300 seconds or 5 minutes.
- If a single '-' is given, lprm will remove all jobs which a user owns. If the super-user employs this flag, the spool queue will be
emptied entirely.
user Causes lprm to attempt to remove any jobs queued belonging to that user (or users). This form of invoking lprm is useful only to the
super-user.
job # A user may dequeue an individual job by specifying its job number. This number may be obtained from the lpq(1) program, e.g.
% lpq -l
1st:ken [job #013ucbarpa]
(standard input) 100 bytes
% lprm 13
If neither arguments or options are given, lprm will delete the currently active job if it is owned by the user who invoked lprm.
lprm announces the names of any files it removes and is silent if there are no jobs in the queue which match the request list.
lprm will kill off an active daemon, if necessary, before removing any spooling files. If a daemon is killed, a new one is automatically
restarted upon completion of file removals.
ENVIRONMENT
If the following environment variable exists, it is used by lprm.
PRINTER If the environment variable PRINTER exists, and a printer has not been specified with the -P option, the default printer is assumed
from PRINTER.
FILES
/etc/printcap Printer characteristics file.
/var/spool/output/* Spooling directories.
/var/spool/output/*/lock Lock file used to obtain the pid of the current daemon and the job number of the currently active job.
DIAGNOSTICS
``Permission denied'' if the user tries to remove files other than his own.
SEE ALSO lpq(1), lpr(1), lpd(8)HISTORY
The lprm command appeared in 3.0BSD.
BUGS
Since there are race conditions possible in the update of the lock file, the currently active job may be incorrectly identified.
BSD June 6, 1993 BSD