02-13-2009
Spool data file
Dear Gurus,
Tried searching for some clues in this forum but dont seem to be able to find my answer.
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 that I can capture the spooled data as a file. I need to create the spool file from the print job queue. How can I do that? Realised I can't use lp command to do it...clueless now...
thanks.
lweegp
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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)
Discussion started by: kripssmart
2 Replies
2. Shell Programming and Scripting
Hi,
I am trying to do this
For i in *.txt
do
sed 'some pattern checking' $i
done
>file
These text files are spool files.And when i find error in these spool files I want to append the text file contents to error.log file.
Or is there any option that I do this sed for only files that... (12 Replies)
Discussion started by: ran16
12 Replies
3. UNIX for Dummies Questions & Answers
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)
Discussion started by: Leo_NN
1 Replies
4. Shell Programming and Scripting
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)
Discussion started by: kknayak
1 Replies
5. Shell Programming and Scripting
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)
Discussion started by: cesarNZ
8 Replies
6. Shell Programming and Scripting
Hi All,
I have one Question, that is it possible to check the spool output?
What i mean to say is "spool the file only if data exists"
I am trying to fetch data from a sql query, and want to generate a file, on a condition that the file should be generated, only if the output of the sql... (5 Replies)
Discussion started by: spiabhi
5 Replies
7. Shell Programming and Scripting
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)
Discussion started by: abhi1988sri
1 Replies
8. UNIX for Dummies Questions & Answers
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)
Discussion started by: Pramod_009
7 Replies
9. Shell Programming and Scripting
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)
Discussion started by: Shanmugapriya D
6 Replies
10. Shell Programming and Scripting
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
purity-ng
PURITY-NG(6) Games Manual PURITY-NG(6)
NAME
purity-ng - general purpose purity testing software
SYNOPSIS
purity-ng [OPTION]... list|FILE|TESTNAME
DESCRIPTION
Purity is an interactive purity test program with a simple, user interface and datafile format. For each test, questions are printed to
the your terminal, and you are prompted for an answer to the current question. At a prompt, these are your choices:
y Answer "yes" to the question.
n Answer "no" to the question.
b Backup one question, if you answered it incorrectly, or someone is watching you take the test, and you don't (or do) want to admit a different answer.
s Print your current score on the test you are taking.
q Quit the test, and print the current score.
? Print a help screen for the current prompt.
At the end of the test, your score is printed out. For most purity tests, lower scores denote more "experience" of the test material.
OPTIONS
--version
print current version of purity-ng
-h, --help
show the help message and exit
-p print the test without prompting for answers.
-r decrypt the test using the Rot 13 algorithm.
To get a list of all purity tests available globally on your system, run purity-ng list.
AUTHORS
purity was originally written by Eric Lechner in 1989. purity-ng is a reimplementation of purity in Python for modern systems, written by
Simon Fondrie-Teitler and Luke Faraone.
This manual page was written by Luke Faraone.
BUGS
If you find bugs in the application, please report these to <https://bugs.launchpad.net/purity-ng> or to your distribution's distributor.
SEE ALSO
purity(6)
Running purity-ng format provides documentation about the datafile format.
Additional documentation is available online at <http://packages.python.org/purity-ng>.
January 7, 2011 PURITY-NG(6)