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
5
votes
3 answers

Additional mailer service to use the spool and send instant emails in Symfony2 - strange headers

by default I use spool mailing solution for sending newsletter in my web page. But I also need to send email immediately. So I have used this solution If I send newsletter with Spool everything is fine. But when I use $mailer =…
Tom
  • 1,203
  • 3
  • 15
  • 35
5
votes
2 answers

Can I reprint a spool file?

Is there a way to reprint a spool file? I can't find any example or article to say if there is a way or not. edit: when i say reprint it, i mean to the same printer
sgkin
  • 113
  • 2
  • 7
4
votes
0 answers

beeline spool Hive puts special character instead of quote

I am exporting query results form hive using beeline, here is my command : beeline -u 'jdbc:hive2://myhost.com:10000/mydb;principal=hive/myhost.COM' --incremental=true --silent=true --outputformat=dsv --disableQuotingForSV=true…
Thelight
  • 359
  • 1
  • 5
  • 15
4
votes
6 answers

C# winspool.drv call to WritePrinter not printing

I'm using some code I found online which was a solution to someone else's similar printing problem. The code appears to run fine, and even errors out when I would expect it to (for example, when I purposefully enter in a bad printer name). The…
spoof3r
  • 607
  • 8
  • 23
4
votes
1 answer

mutt sort by score and date

I'd like to have messages in the mutt spool sorted by reverse-score and if the score is the same then by reverse-date. Is it possible? If I set sort=reverse-score then the secondary sort seems to be only "date".
hasan
  • 638
  • 4
  • 14
3
votes
1 answer

Oracle query output is incomplete when spooled to file

Recently I've had to increase the volume of an data extraction script and I've found the output to be missing some data that is present in the source tables. Can anyone suggest some ideas for what might be causing this issue? Background The…
stevenl
  • 6,736
  • 26
  • 33
3
votes
1 answer

sqlplus spool file with parameter

I have an sql file which is executed from command line, it works fine. sqlplus username/password@DBInstance @filename.sql My filename.sql looks about this: set colsep ';' set echo off set feedback off set sqlprompt '' set trimspool on set headsep…
Denis Babichev
  • 61
  • 1
  • 7
3
votes
1 answer

How to use spool command in sql developer oracle

Dears, I cannot use spool command. It is not working or i am not doing something right. I am trying to save query result in txt file (tried also csv saving with select /*csv*/ * from table but it also did not work). So what i wrote is: set echo…
orangutangas
  • 391
  • 2
  • 7
  • 20
3
votes
3 answers

"Unknown set option" in SQL developer which creating Spool script

My code is as below- set define on; set spool on; set SQLFORMAT csv; set fpath = &folderpath; spool @fpath/mycsvfile1.csv select * from I_PTY; spool off; spool @fpath/mycsvfile2.csv select * from I_LEG; spool off; I want to pass folderpath value as…
Mannu
  • 33
  • 1
  • 4
3
votes
1 answer

Java print service API: send job to printer spool?

I am using Java print service API to select PrintService and then pass it to JasperReport's JRPrintServiceExporter. The basic idea is to just send a document to the provided PrintService. It is actually using java.awt.print.PrinterJob.print(). It…
zihaoyu
  • 5,483
  • 11
  • 42
  • 46
3
votes
2 answers

Oracle SQLPlus spool command not working when script is scheduled with crontab?

I have written a bash script as shown below. The script works when I run it using bash exec_proc_daily_20.sh on the commandline. The log files are created successfully with records inside as a result of the spool $logfile command.…
Fokwa Best
  • 3,322
  • 6
  • 36
  • 51
3
votes
1 answer

Executing sql file from another sql file

I have a .sql file with name Alter_table.sql which have the following code. alter table mytable add newcolumn VARCHAR2(1); I don't want to edit this file and add a spool command. However I need to execute Alter_table.sql by writing spool in another…
Sarath Subramanian
  • 20,027
  • 11
  • 82
  • 86
3
votes
3 answers

Spooling in Oracle adds spaces to columns... how can I avoid it?

I'm saving the results of a query in a csv file but unwanted spaces are added to some of the fields, when the original data in the database does not contain them. For example, if one of the rows in the DB has the values "how", "are" and "you", what…
toofast
  • 33
  • 1
  • 1
  • 5
3
votes
2 answers

How do I execute oracle query using shell scripting and send the results in the email

I am new to Unix scripting. I have an oracle DB which has a username, password, hostname, port and servicename. I want to connect the database and run the query and in the end the result should be email to me or other people. Result should be…
sachin bhandari
  • 31
  • 1
  • 1
  • 2
3
votes
1 answer

Can Spool Dir of flume be in remote machine?

I was trying to fetch files from a remote machine to my hdfs whenever a new file has arrived into a particular folder. I came across the concept of spool dir in flume, and it was working fine if the spool dir is in the same machine where the flume…
jintocvg
  • 158
  • 3
  • 14
1
2
3
…
20 21