what is in this file?
To see try:
I would suspect that the $ORA_HOME variable (or one of its cousins) or your $PATH variable is not set correctly. the env command will show you all of your environment variables.
Next:
Change the way you run the script the script and run it. See if you get errors.
Note the dot preceding the slash. This fixes temporarily problems with your PATH environment variable
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)
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)
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)
Hello, I need to replace newline with tab at certain lines of the file (every four lines is a record).
infile.fq:
@GAIIX-300
ATAGTCAAAT
+
_SZS^\\\cd
@GAIIX-300
CATACGACAT
+
hhghfdffhh
@GAIIX-300
GACGACGTAT
+
gggfcfoutfile:
@GAIIX-300 ATAGTCAAAT + _SZS^\\\cd
@GAIIX-300 ... (6 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)
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 DEBIAN
faxlock
FAXLOCK(8) System Manager's Manual FAXLOCK(8)NAME
faxlock - tell a HylaFAX server to switch to LOCKWAIT state
SYNOPSIS
/usr/sbin/faxlock [ -q dir ] modem
DESCRIPTION
faxlock sends a message to a HylaFAX faxgetty(8) process servicing modem telling it to change its state to LOCKWAIT
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''.
OPTIONS -q dir Use a spooling area other than /var/spool/hylafax.
NOTES
When faxgetty changes it's state to LOCKWAIT, it will start looking for the UUCP lockfile for the device, and when the device is no longer
locked, proceed to re-initialize the modem.
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 FAXLOCK(8)