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
1
vote
2 answers

spool sql log with the date on name

I have the sql script at the beginning I put: column dt new_value mydate noprint select to_char(sysdate. 'YYYYMMDD') dt from dual; spool &mydate.test.log try to spool the log with the timestamp. However, when I do this, the spool out file name like…
TJY
  • 11
  • 1
  • 4
1
vote
2 answers

Mautic is not processing the queue. Messages are in the spool/default folder

Mautic will not send my queued emails. I have set up the cron jobs and they are running as expected. The cron job email report for the ":messages:send" cron job that runs every minute is always this... Processing message queue Messages sent:…
Steve Hall
  • 113
  • 1
  • 7
1
vote
1 answer

SQL*Plus using a variable for a subselect (keeping spool working)

I got the following script that does actually the following, it uses an email-address to search for that user search for messages from that user search for Entries of that user puts the findings to a file currently that is working but now I…
m.weiloa
  • 155
  • 1
  • 11
1
vote
1 answer

how to get as400 spool files to text in c#

I'm trying to code a console application to get the spool file from as400 to a different destination as a text file. I have been looking around but I haven't found a small code to start from there, I been searching around and haven't found anything…
Raframi
  • 23
  • 5
1
vote
1 answer

SqlPlus (Oracle) Spool Formatting Issue

I have scheduled a shell script which is outputting the following email. I want to remove the unwanted/additional duplicated text which is being printed using the dual table below to give a heading to my SQL select output. How can I do it? Following…
khalidmehmoodawan
  • 598
  • 1
  • 5
  • 22
1
vote
1 answer

Get changes done by a script

I need to write a script in order to delete specific records in the database that need to be re-entered for the user because they are corrupted. The script is very simple. I first need to identify the records to be deleted and their dependencies and…
Mario
  • 73
  • 8
1
vote
2 answers

Spooling large amount of date from Oracle to csv discrepencies

I need to export data from a table containing around 3 million data. The table has 9 columns and is in the following format: Source | Num | User | Offer | Simul | Start_Date | End_Date | Label | Value coms p | 0012| plin | synth | null |…
refresh
  • 1,319
  • 2
  • 20
  • 71
1
vote
0 answers

Remove blank line from Spool file

I am creating a .tab file using Spool simply by doing a select statement. The select statement returns Y However when running the below script the output files has a blank line after the Y. Can you please assist me in removing the line as I have…
Dylan Davids
  • 19
  • 3
1
vote
4 answers

spool for insert in sql developer not working

I have below select query for which the result of this query i want to create insert scripts and saved it in files. I have used spool. set long 10000 set lines 100000 set sqlformat insert spool c:\temp\Insert_TEST_GRP.sql select…
Andrew
  • 3,632
  • 24
  • 64
  • 113
1
vote
0 answers

Reprinting spool file, job disappears from queue but does not print

I have researched how to reprint spool files in C# for a few days now and I ran into an immediate issue. I have found decent examples and explanations for HOW to print the jobs, but the print job keeps disappearing from the queue and the printer…
Ando
  • 11
  • 3
1
vote
1 answer

Pass parameter to spool file

Say I have a sql file which is executed from command prompt (SQL Plus), which is working fine. sqlplus dbusername/dbpassword@DBInstance @sqlfilename.sql Now I need to pass a parameter to this sql spool file and according to the value of parameter I…
Sarath Subramanian
  • 20,027
  • 11
  • 82
  • 86
1
vote
2 answers

How to record all outputs of Linux terminal to a file

For SQL Editors there is a spool command to record all outputs and activities. I would want the same functionality for linux terminal. All the command inputs and outputs typed on the terminal should be recorded into a file, while the output provided…
Guru
  • 2,739
  • 1
  • 25
  • 27
1
vote
1 answer

Oracle sqlplus export using spool vs sql developer export

I'm running a query which results 100 000 records/rows of data. Using Spool command in sqlplus I generate a csv which stores all the output of the query. The csv file with 100 000 records gives me a size of 2.5 GB approximately. The same export…
user1830049
  • 109
  • 1
  • 6
1
vote
1 answer

How to spool a number in oracle in correct format

I am trying to spool the records by executing script in SqlDeveloper, everything is working fine except printing the record of columns which are NUMBER(38,0) data type. All numbers record are printing in below format: 1.5E+18 I tried many…
prashant thakre
  • 5,061
  • 3
  • 26
  • 39
1
vote
1 answer

Oracle spool UTF-8 without BOM at beginning of file

I spool data from Oracle to a csv-file. When I open the csv in editor all signs are shown correctly. But in Excel or Kofax the file special characters (e.g. ß or ö) are not displayed correct. Could it be an option to select the missing BOM…
PatrickOschwald
  • 15
  • 1
  • 6
1 2 3
…
20 21