hi,
can anyone help me by saying how can i spool a unix file.. do we need to specify the pathname as such to spool the file ..
right now, i tried giving like spool filename in the sql prompt.. but its not giving me the required output even if i can see that the command is being executed..
... (2 Replies)
HI
Have some problem with spooling out some relatively large number of records (~2-3 mil)
Small table - OK though.
Getting error: SP2 0308: cannot close spool file.
Any thoughts?
sqlplus -s user/pwd << EOF
set term off
set head off
set trims on
set pages 0
set... (1 Reply)
Dear Gurus,
Tried searching for some clues in this forum but dont seem to be able to find my answer. :confused:
Anyway i have a quick question:
Today I have produced a messages generated from a application and placed them on the print queue. Before this I had stopped the printer queue, so... (2 Replies)
Hi,
Iam a newbie. When I give the below query at SQL prompt.
SQL> select col1||'`ß`'||col2 from tablename where rownum<2;
1-J7WGX`ß`1-7OKC-23
Iam getting ß within appostropies...... If I remove appostropies and give the query it is throwing an error.
If I give the same query in spool as... (1 Reply)
hi all,
am trying to write a ksh script which will take a username, password, db instance as input arguments and login to the database using sqlplus and select some data via sql and spool to a file.
problem is that i am using "sqlplus -s" in order to hide the username/password and it doesnt... (8 Replies)
Hi
#Testing for file existence
if ; then
echo 'SCHOOL data is available for processing'
else
echo 'SCHOOL DATA IS NOT AVAILABLE FOR PROCESSING'
:
i wrote a script, where it begins by checking if file exists or not.
If it exists, it truncates the database... (2 Replies)
Hello,
I am trying to spool data from database into a file on solaris through ksh.
Data is getting fetched but the problem is record is getting split in to multiple lines.
excerpt from sql is
whenever sqlerror exit 1;
set define on
set echo off
set feed off
set head off
set... (1 Reply)
Hi All,
I have a problem with the column heading while spooling the data from the database. Since i want the column header, therefore i am not using SET HEADING OFF, and i am getting the header, but for the longer column name, some of the character from the column name is missing.
for... (7 Replies)
Hi,
I have a requirement of
Connecting to sqlplus from unix
Execute the package. The output of package is stored in a table
Need to query the table and move to txt file.
The problem iam facing is, when I try to spool the file. I get the sql query also along with the output.... (6 Replies)
Hello,
I have a shell script through which I am executing .sql file and spooling the result of Query from .sql . I want to spool the result in ascending order. Is there any parameter to be set to print result in ascending or descending order.
Thanks in advance. (4 Replies)
Discussion started by: Aparna.N
4 Replies
LEARN ABOUT DEBIAN
snexpire
snexpire,v0.3.8(8) System Manager's Manual snexpire,v0.3.8(8)NAME
snexpire - expire news under the sn system.
SYNOPSIS
snexpire [-v] [-exp] newsgroup [[-exp] newsgroup]...
DESCRIPTION
snexpire expires news in the sn news system, one article file (=10 articles, compile time default) at a time. snexpire always leaves
behind at least one article file, so that newly entered articles will have numbers not overlapping previously used numbers. As an excep-
tion if the expiration age is set to 0, then even this last file will be expired and subsequent article numbers will start from the begin-
ning. You will need to be root or own /var/spool/sn to run snexpire.
OPTIONS -v Output a line for each article expired. The format of this line is the same as for snscan.
ARGUMENTS
snexpire expires all newsgroups named on the command line. Each newsgroup may be preceded by -exp to control the expiration age. exp is
of the form #[hdwmy] where # is a number, followed by one of the characters h,d,w,m,y representing hours, days, weeks, months and years.
The default for -exp is a compile-time fixed. Each [-exp] applies to the next newsgroup only, any newsgroups after that one get default
treatment unless overridden by another [-exp].
FILES MODIFIED
/var/spool/sn/newsgroup/.times, /var/spool/sn/newsgroup/[0123456789]*, /var/spool/sn/{.chain,.table}.
ENVIRONMENT VARIABLES
SNROOT If this is set and is not empty, the value is used in place of /var/spool/sn, the default news spool directory.
FILES
/var/spool/sn/newsgroup/.expire
If this exists, its contents are taken to be exp if not overridden by -exp on the command line.
N.B. Harold Tay snexpire,v0.3.8(8)