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.
Questions tagged [spool]
310 questions
2
votes
1 answer
Adding a newline in a spool file
Is there a way to add a newline in an sql spool file?
I need the file to be structured in a specific way.
'\n' doesn't seem to work and gets printed literally
thanks,
Update: my SQL file
-- Prepare blank file
SET NEWPAGE 0
SET SPACE 0
SET LINESIZE…
Andreas
- 2,007
- 5
- 26
- 37
2
votes
2 answers
Oracle Unicode Spooling
How can I spool data from a table to a file which contains Unicode characters?
I have a sql file which I execute from SQL*Plus screen and its content is:
SET ECHO OFF
SET FEEDBACK OFF
SET HEADING OFF
SET PAGESIZE 0
SPOOL STREET_POINT_THR.BQSV
SELECT…
Kaveh Shahbazian
- 13,088
- 13
- 80
- 139
2
votes
1 answer
Coldfusion 9 - respool mail
I had a bunch of mail to be sent out that was not. I realized that my mail settings in Coldfusion Administrator were incorrect and have since corrected them. I tested the new settings with new mail and they work. I am now trying to re-send out the…
Lauren Robinson
- 443
- 2
- 9
- 26
2
votes
0 answers
Long Column not spooling properly
Possible Duplicate:
Max column width in Oracle spool to file
I have a LONG column in a table. I want to spool the contents of this column into a spool file. I have written the below file and am running it. The problem is that only the first 81…
Orangecrush
- 1,970
- 2
- 15
- 26
2
votes
0 answers
What does spooling mean in the context of JCache?
From the JCP page of JCache :
The JCACHE specification standardizes in process caching of Java
objects in a way that allows an efficient implementation, and removes
from the programmer the burden of implementing cache expiration,
mutual…
Geek
- 26,489
- 43
- 149
- 227
2
votes
1 answer
Spool Space Error. Please help optimize
I am trying to generate the below query in Teradata SQL Assistant. Unfortunately I am running into a spool space error. Any tips on how to make this query execute using less resources?
SELECT TOP 10
A.USER_ID,
C.SUPER_NM_LVL2,
…
ciw916
- 53
- 2
- 8
1
vote
0 answers
sqlplus spool to csv will contain multiple header rows
I want to use sqlplus with spool to export about 14 million rows into '.csv' file.
I'm running the script on windows platform.
The script file looks like the following:
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
alter session set…
Xie Steven
- 8,544
- 1
- 9
- 23
1
vote
1 answer
VARCHAR2 column formatting in spool file
I'm working on an assignment and the spool output is getting some weird formatting for VARCHAR2 function returns. The class uses Oracle SQL 11g.
I have this PL/SQL script:
SET echo on
SET wrap off
SET trimspool on
SET linesize 80
SET colsep '|'
SET…
Gethe
- 23
- 1
- 5
1
vote
1 answer
Spool - Microsoft Print to PDF, Microsoft XPS Document Writer - Error in converting SPL file to Images
I'm trying to convert the spool files to pdf? Do we have any options for this process to do?
I have a answer from forum as well. Do we have any work around?
Forum link:…
Elanchezhiyan P
- 86
- 9
1
vote
0 answers
Automatic Spool Sending
in FMS system I need to automatically send the spool of a given background job let say job 'B'.
Job B is generated by a different background job, let say job 'A'. SM36 has the possibility to send only A job spool. Any suggestions?
Already tried SM36…
DNASCI
- 11
- 2
1
vote
1 answer
WMI to get current printer job (including number of copies)
I tried to follow the example of WMI scripting (VBScript) to obtain several info from the current Windows OS, including the print job. Both are working successfully.
' My SampleCapturingPrinter.vbs
' ———————————————–‘
Option Explicit
Dim…
gumuruh
- 2,544
- 4
- 33
- 56
1
vote
1 answer
Adding extra data/information to filename using spool in sqlplus
I'm trying to achieve the below requirements in the filename being exported as csv
FILENAME: filename_yyyymmdd_nnnnnn_xxxxxx.csv
where
yyyymmdd = Datestamp on when the Account file was generated
nnnnnn = 6-byte random generated batch ID
xxxxxx =…
Aabhish
- 21
- 3
1
vote
2 answers
oracle spool have any settings to remove default lst extension?
In oracle spool, if we not specify the spool file extension, we get "file.lst", any settings to get file?
jie
- 95
- 1
- 8
1
vote
1 answer
with sqlplus how to spool data into csv where column contains newline
With sqlplus how to spool data into csv from table where some column contains newline?
resulting row in csv should be in one line.
zorropele
- 13
- 2
1
vote
1 answer
SQLPLUS : set sqlformat insert : SP2-0158
I want to export all my datas as insert statement.
In Sql Developer, the command "set sqlformat insert" work very well... but when I want to use it on sqlplus, I have this error message : SP2-0158 unknown SET option "sqlformat"
This command work…
Julien BARBE
- 23
- 1
- 5