Stack Overflow
Stack Overflow

Questions tagged [spool]

SPOOL is an acronym for simultaneous peripheral operations on-line. It is a type of buffering. The most common spooling application is print spooling, which places a task (or 'print job') into a queue for extended or later processing.

310 questions
41
votes
1 answer

Ways to avoid eager spool operations on SQL Server

I have an ETL process that involves a stored procedure that makes heavy use of SELECT INTO statements (minimally logged and therefore faster as they generate less log traffic). Of the batch of work that takes place in one particular stored the…
ConcernedOfTunbridgeWells
  • 64,444
  • 15
  • 143
  • 197
39
votes
3 answers

Remove Column Header into the Output Text file

I want to create a flat file (text file) of my query from Oracle SQL Developer. I have successfully created the text file using SPOOL, thru a script text file, but i want to remove the header of each column into my output. I am getting this…
Marvin Wong
  • 479
  • 2
  • 8
  • 11
23
votes
3 answers

sqlplus spooling: How to get rid of first, empty line?

I'm doing the following spooling statement: SET VERIFY OFF SET FEEDBACK OFF SET HEADING OFF SET TRIMSPOOL ON SET TERM OFF SPOOL &pathRelations START scripts/relations.sql &parent SPOOL OFF SET TERM ON The scripts/relations.sql file contains a…
user321068
9
votes
2 answers

Clear the heading in Oracle spool

I have spooled a file before running the below command and got the output like this, I have set heading off, feedback off SET HEADING OFF SET FEEDBACK OFF SPOOL D:\TEST.TXT SELECT SYSDATE FROM DUAL; SPOOL OFF OUTPUT in TEST.TXT: SQL> SELECT SYSDATE…
Srinivasan Thirunavukkarasu
  • 103
  • 2
  • 2
  • 4
8
votes
2 answers

Append to spool file Oracle

I have one script file called Test.sql in D:\Scripts folder and the content of the file is given below SET SERVEROUTPUT ON SET DEFINE OFF SPOOL Test.log; SELECT USER_NAME FROM TUP_USER WHERE USER_ID=1432; SPOOL OFF; SET DEFINE ON SET…
Sarath Subramanian
  • 20,027
  • 11
  • 82
  • 86
8
votes
2 answers

How to send spool from swiftmailer without using command

How to send spool from swiftmailer without using command? php app/console swiftmailer:spool:send --env=prod I need to put this somehow into php file so that Server admin can add this to Schedule.
Tom
  • 1,203
  • 3
  • 15
  • 35
8
votes
3 answers

PostgreSQL query/error logging for .sql scripts

Here is the problem: I need to know how to get all PostgreSQL output from an executed .sql script to log to a file, including errors and query results. I have already surrounded my script with \o and \o opening and closing tags, but this only logs…
Adam
  • 3,668
  • 6
  • 30
  • 55
7
votes
4 answers

How to create a oracle sql script spool file

I have a question about spooling the the results of my program. My sample sql script looks like this. whenever sqlerror exit failure rollback set heading off set arraysize 1 set newpage 0 set pages 0 set feedback off set echo off set…
user987900
  • 105
  • 1
  • 3
  • 11
7
votes
6 answers

Coldfusion 9, How do you Empty an "Undelivered Mail Queue"

I have roughly 9,000 undelivered messages in my mail spool in Coldfusion 9. As far as I can tell the only way to manage these messages is to manipulate them 10 at a time through the CF Admin GUI. I'm looking for a way to expedite this process. I'd…
Dave Ostrander
  • 226
  • 2
  • 5
7
votes
4 answers

Header formatting while spooling a csv file in sqlplus

I am required to spool a csv from a table in Oracle, using sqlplus. Following is the format required: "HOST_SITE_TX_ID","SITE_ID","SITETX_TX_ID","SITETX_HELP_ID" "664436565","16","2195301","0" "664700792","52","1099970","0" Following is the…
Tech_Coder
  • 185
  • 1
  • 2
  • 8
7
votes
1 answer

How to define an additional mailer service to use the spool and send instant emails in Symfony2

In my Symfony2 web app I'm supposed to send two kind of emails: instant and bulk. The instant emails should be send right away while the bulk emails should be send using the spool. With the default configuration of the Swiftmailer in Symfony2 it is…
David Barreto
  • 8,887
  • 7
  • 32
  • 46
6
votes
4 answers

Prevent output of SPOOL from being wrapped

I'm trying to generate all DDLs for objects in a Database using the SPOOL command in SQLPLUS: SET trimspool ON SET wrap off SET heading off SET linesize 300 SET echo off SET pages 999 SET long 90000 Col object_type format a10000 Col object_name…
Filippo
  • 361
  • 1
  • 5
  • 16
5
votes
1 answer

Counting the number of printed pages in C#

I am developing a print spool monitor to count the number of pages that are printed by a certain printer. I am new to this area, so I am using the following article as my reference. Print Monitor Now I have a requirement of counting the double sided…
Chathuranga Chandrasekara
  • 20,548
  • 30
  • 97
  • 138
5
votes
6 answers

SQLPlus - spooling to multiple files from PL/SQL blocks

I have a query that returns a lot of data into a CSV file. So much, in fact, that Excel can't open it - there are too many rows. Is there a way to control spool to spool to a new file everytime 65000 rows have been processed? Ideally, I'd like to…
FrustratedWithFormsDesigner
  • 26,726
  • 31
  • 139
  • 202
5
votes
6 answers

spool with column headers in pipe delimited sqlplus

I currently am spooling a pipe file via this sqlplus script: set feedback off set echo off set verify off set pagesize 0 set heading off set termout off set trim on set wrap on set trimspool on set linesize…
lightweight
  • 3,227
  • 14
  • 79
  • 142
1
2 3
…
20 21