08-12-2009
Are you sure it is not spooling the data out or you are not getting any data from your sql command? Did you take the -s out and run it?
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. AIX
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)
Discussion started by: lweegp
2 Replies
5. 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
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
lpc(8) System Manager's Manual lpc(8)
NAME
lpc - Line printer control program
SYNOPSIS
lpc [command [argument ...] ]
DESCRIPTION
The lpc command is used by the system administrator to control the operation of the line printer system. For each line printer configured
in the /etc/printcap file, the lpc command may be used for disabling or enabling a printer; disabling or enabling the printer spooling
queue; rearranging the order of jobs in a spooling queue or finding the status of printers, their associated spooling queues, and the
printer daemons.
Without arguments, lpc prompts for commands from the standard input. When arguments are supplied, lpc interprets the first argument as a
command and any remaining arguments as command parameters. The standard input may be redirected so that lpc reads commands from a file.
The following is the list of recognized lpc commands: Prints a short description of each command specified in the argument list or, when no
arguments are supplied, a list of the recognized commands. Prints a short description of each command specified in the argument list or,
when no arguments are supplied, a list of the recognized commands. Terminates an active spooling daemon running on the local host, and
then disables printing. This prevents new daemons from being started by lpr or lp for the specified printers. Removes any temporary files,
data files, and control files that cannot be printed (files that do not form a complete printer job) from the specified printer queue(s) on
the local machine. Turns the specified printer queues off. This prevents new printer jobs from being entered into the queue by lpr or lp.
Turns the specified printer queue off, disables printing, and puts a message in the printer status file. The message does not need to be
quoted because remaining arguments are treated the same as echo. The down command is normally used to take a printer down and let others
know why. (The lpq command indicates that the printer is down and prints a status message.) Enables spooling on the local queue for the
listed printers. This allows lpr or lp to put new jobs in the spool queue. Exit from lpc. Exit from lpc. Attempts to start a new
printer daemon. This is useful when some abnormal condition causes the daemon to terminate unexpectedly and leave jobs in the queue. lpq
reports that there is no daemon present when this condition occurs. When a daemon is stuck, you must first kill it and then restart.
Enables printing and starts a spooling daemon for the listed printers. Displays the status of daemons and queues on the local machine.
When printer name parameters are not supplied, information about all printers is provided. Stops a spooling daemon after the current job
has completed and disables printing. Places jobs in the order listed at the top of the printer queue. Enables all printing and starts a
new printer daemon. Cancels the effect of the down command.
RESTRICTIONS
Normally, the clean subcommand allows you to remove all print jobs on the system or all jobs on a specified printer. However, clean does
not remove the jobs in the spooling queues. Therefore, you should use the lprm command on a printer-by-printer basis to remove the jobs
you want to eliminate.
ERRORS
The following diagnostic messages are possible. Abbreviation matches more than one command. No match was found. Command may be executed
by the superuser only.
FILES
Specifies the command path. Specifies the printer description file. Specifies print spool directories. Specifies the lock file for queue
control.
RELATED INFORMATION
Commands: cancel(1), lp(1), lpd(8), lpr(1), lpq(1), lprm(1), lpstat(1).
Files: printcap(4). delim off
lpc(8)