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
-1
votes
1 answer
Is it possible to set a setting to show how many pages a spool queue print job has with a raw postscript print file in windows
Currently it will show N/A as number of pages in the windows spool queue, is this possible to show the number of pages and what page is printing with bi-directional support on? with this file format? surely the printer itself must know what page is…
user3725395
- 145
- 2
- 13
-1
votes
1 answer
Retrieve user from spool file with regex
I need to retrieve the field user from this spool file
(********* TOP SEPARATOR ***************************************\
*****************) 48 Tj
0 -1.1 Td
(* REPORT = COURR QRCODE MOB \
USER = BINM3 *) 48 Tj
0…
Bilna0
- 1
- 2
-1
votes
1 answer
how to save the data of a query in a spool file in oracle
I have created a script which is containing one query and , that query output should print in a spool file.
spool D:\sqlpractice\abcd
it creates the abcd file but that output data is not printing on that file. that output of query is printing on the…
srikanth peddini
- 1
- 4
-1
votes
1 answer
Hi, i'm using spool for exporting 6 millions records, is query executes once or till end of last record
A view returns 6 millions records.
Earlier i used to export with sql developer(right click and export, it takes more than 2hr), but my senior said that, if do like this query will get executes every 500 rows. so we are getting warnings from DBA(long…
Ajit Pattar
- 1
- 1
-1
votes
3 answers
Export DDL to place on server
I want to write SQL procedure which writes file with DDL commands from certain schema to directorium on server. I done that using spool command and save it locally but I need it on server every time I ran it.
I am using Oracle RDBMS.
Luka Krstev
- 1
- 4
-1
votes
1 answer
Oracle11g Spooling issue
When I enter SPOOL c:\filename I am getting error:
SP2-0606: Cannot create SPOOL file.
I have searched but nothing works. I am trying to output the file to the c drive. The disk is not full and it does have write permission.
code_bash
- 701
- 1
- 5
- 16
-1
votes
2 answers
Linux non-su script indirectly triggering su script?
I'd like to create an auto-testing/grading script for students on a Linux system such that:
Any student user can initiate the script at any time.
A separate script (with root privileges) copies student code to a non-student-accessible file space,…
ProfPlum
- 129
- 1
- 8
-1
votes
1 answer
remove sql from spool file
I have a SQL script that I am running in a shell. The problem is I am unable to get rid of the SQL in the spool file.
SQL file :
set termout off
set echo off
set pagesize 0
set linesize 18
set heading off
set feedback off
set tab off
set space…
vivek ashodha
- 117
- 1
- 2
- 10
-1
votes
1 answer
How to process EMR_FORCEUFIMAPPING and EMR_GDICOMMENT?
I am converting EMF to PDF, but I went into a problematic field. I have some EMF spool files, which contain some undocumented EMR structures such as EMR_FORCEUFIMAPPING and EMR_GDICOMMENT.
The MSDN is not so descriptive about these records, so…
Robert
- 53
- 1
- 6
-3
votes
1 answer
How can I send pdf file to spool in SAP?
I have a program that programmatically creates XFT template for PDF and XFD template for data. I can download PDF file and it all works just fine, except spool request. How can create a spool request, then pass my custom PDF file to that request?
user9695260
- 347
- 3
- 17