manish_saraswat
asked on
SQL Reports - spool command
Hi there !!!
I am using the reporting feature of SQL. I am giving the following commands for printing my report :
SET LINESIZE 47
TTITLE CENTER "Employee Report"
COLUMN empno FORMAT 9999 HEADING "Empno"
COLUMN ename FORMAT A15 HEADING "Emp. Name"
SPOOL emp_rep
SELECT empno, ename FROM emp WHERE deptno = 20;
SPOOL OFF
Now when I print the file EMP_REP.LST from DOS prompt or Notepad, the following select command is printed in the beginning of report :
"SQL> SELECT EMPNO, ENAME FROM EMP WHERE DEPTNO = 20"
and the following line is printed at the end of the report :
"51 ROWS SELECTED"
I dont want these lines at the beginning and the end of my output file. So please tell me what should I do to avoid these lines in the output file.
Thanking you,
Manish.
I am using the reporting feature of SQL. I am giving the following commands for printing my report :
SET LINESIZE 47
TTITLE CENTER "Employee Report"
COLUMN empno FORMAT 9999 HEADING "Empno"
COLUMN ename FORMAT A15 HEADING "Emp. Name"
SPOOL emp_rep
SELECT empno, ename FROM emp WHERE deptno = 20;
SPOOL OFF
Now when I print the file EMP_REP.LST from DOS prompt or Notepad, the following select command is printed in the beginning of report :
"SQL> SELECT EMPNO, ENAME FROM EMP WHERE DEPTNO = 20"
and the following line is printed at the end of the report :
"51 ROWS SELECTED"
I dont want these lines at the beginning and the end of my output file. So please tell me what should I do to avoid these lines in the output file.
Thanking you,
Manish.
The last line which gives the count can be avoided by
SET FEEDBACK OFF before the spool.
SET FEEDBACK OFF before the spool.
ASKER
I have tried that option but by giving SET FEEDBACK OFF only the line "51 ROWS SELECTED" is removed. Still the line
"SQL> SELECT EMPNO, ENAME FROM EMP WHERE DEPTNO = 20"
is there at the beginning of the output file and
"SPOOL OFF"
at then end of the output file remains. What should I do to remove them ?
Please give a complete answer.
Manish.
"SQL> SELECT EMPNO, ENAME FROM EMP WHERE DEPTNO = 20"
is there at the beginning of the output file and
"SPOOL OFF"
at then end of the output file remains. What should I do to remove them ?
Please give a complete answer.
Manish.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Best wishes.