| Report [message #77371] |
Fri, 07 June 2002 10:26  |
Thode
Messages: 1
Registered: June 2002
|
Junior Member |
|
|
Hi all,
I am really new to sql programming. I need to create an error report. I am just using straight sql to select the data and "spool" it to a file (in Unix). Now how do I get the report to print? I tried "Spool out" but it's not printing. How do I set the printer?
Thanks-
|
|
|
|
| Re: Report [message #77378 is a reply to message #77371] |
Mon, 01 July 2002 13:01  |
Dhiren
Messages: 43
Registered: July 2002
|
Member |
|
|
u need to do:
sql>spool a
sql>select * from emp;
sql> spool off
$lp a.lst
This will print to the default printer.
To have ur printer setup u need to run
lpadmin and have it set.
Dhiren
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
