Sponsored Content
Special Forums Windows & DOS: Issues & Discussions SQL Spool equivalent command in DOS Post 96009 by stevefox on Tuesday 17th of January 2006 04:14:56 AM
Old 01-17-2006
Question SQL Spool equivalent command in DOS

This question maybe in the wrong category but I'm posting here due to urgency.
In DOS is there a command to perform a similar function to spool command in SQL or Script command in UNIX?
I want to print all command line output to a file but I don't want to use the echo command for each line.

Any help will be appreciated.

Steve
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Command equivalent to DOS mode for SCO 5.0.6

I need to set the serial port attributes to 9600,7,E,1 in order to read and write data to it from within a Foxpro program. Unfortunately there is no function in Foxpro to set the line attributes, only open. close read and write. Stty only works on the stdout and stdin in this release, and the... (3 Replies)
Discussion started by: jgt
3 Replies

2. UNIX for Dummies Questions & Answers

Unix equivalent of DOS set

Hi all, what is the equivalent command of the DOS set that lists all the environment variable and their values? Xavier. (3 Replies)
Discussion started by: xxavier
3 Replies

3. Programming

Single sql query to spool to multiple files

Is there anyway to spool my select statement into spool files of max 10000 records each? eg I have a select statement that will return 45000 records. A normal spool command will output the 45000 into just one spool file. How can I make sqlplus do this? 00001 - 10000 records --- spool... (3 Replies)
Discussion started by: Leion
3 Replies

4. Windows & DOS: Issues & Discussions

what is the DOS equivalent of alias command?

how do we create aliases to commands in dos? thanks (9 Replies)
Discussion started by: milhan
9 Replies

5. Windows & DOS: Issues & Discussions

dos/intel unix command equivalent

In Unix I can use command line to do a find for files older than so many days and remove them. I can also capture the date to see if its a saturday and do something different. Are there any dos/intel command line equivalent commands to do this on a windows 2003 server? This is from an... (6 Replies)
Discussion started by: MizzGail
6 Replies

6. Shell Programming and Scripting

Passing filename dynamically in SPOOL of SQL*PLUS in shell script

Hi all, I am executing shell script in which I am using SQLLDR In this SQLLDR I am passing text file having PL/SQL script. This script will produce some formated output, this output I have to spool in another text file. Currently I have given this in script file as following Spool... (2 Replies)
Discussion started by: shekharjchandra
2 Replies

7. Shell Programming and Scripting

UNIX/SQL loop to spool files!!

I want to spool files from unix using a sql script that would take values from another sql query within the KSH script.. unix loop select order_date from date_tbl for each order_Date i need to call this spool script with the value sqlplus scott/tiger@order_db @/ordspool/order_date.sql... (2 Replies)
Discussion started by: vr23
2 Replies

8. Shell Programming and Scripting

SQL*PLUS Spool Output

Hi, Im writing a script to run a bit of sql(via sqlplus) that pulls back some data and spools it to a file, I want the spool file to only display the data, with no sql command at the top and no reports at the bottom ie(# of records recieved). I am currently doing it via a grep command but... (1 Reply)
Discussion started by: Magezy
1 Replies

9. Windows & DOS: Issues & Discussions

DOS Equivalent of UNIX Command

Hi, The title of this post is a little vague but I couldn't think of what to call it. In Unix you can perform the following command ftp -v IPADDRESS <<END put FILE END In a DOS command prompt, is it possible to do the same kind of thing that the "<<END" does? So for example, ... (4 Replies)
Discussion started by: Ste_Moore01
4 Replies

10. Shell Programming and Scripting

Append date to sql*plus spool (log) file in shell script

SQL*Plus version : 11.2.0.4 OS : Oracle Linux 6.5 SQL*Plus is a client application to connect to oracle database. The log file for this tool is generated via spool command as shown below. I am trying to append date ( $dateString ) to spool file as shown below. $ cat test2.sh #!/bin/bash... (4 Replies)
Discussion started by: kraljic
4 Replies
snntpd,v0.3.8(8)					      System Manager's Manual						  snntpd,v0.3.8(8)

NAME
snntpd - small news server SYNOPSIS
snntpd [-t timeout] [-P] [-S] [logger...] DESCRIPTION
snntpd is a small news server. It needs to be run under inetd or tcpserver, as root or as the owner of /var/spool/sn. snntpd does not fork into the background. It expects to read and write from and to the network on descriptors 0 and 1. ARGUMENTS
logger... (usually /usr/bin/logger) is taken to be a logging program, and all log output is piped to it. If logger... is not specified, log messages are directed to descriptor 2. OPTIONS
-t timeout specifies how long snntpd should wait for input before it gives up and exits. timeout is in seconds and defaults to 600. -P snntpd includes it's pid in log output. -S Suppress NNTP greeting on startup. This is useful if you want to perform authentication before running snntpd, or want to provide your own greeting, from a wrapper. POSTING AND POSTING PERMISSIONS
Posts are usually handled externally by the /usr/sbin/SNPOST script, which is responsible for fine-grain posting control; handling of con- trol messages; and the ultimate distribution of the posted article. snntpd permits or denies posting in a very simple manner: If /var/spool/sn/.nopost exists, posting is not allowed. Otherwise, if the environment variable POSTING_OK is not set, posting is not allowed. Otherwise if POSTING_OK is set (to the empty string), posting is generally allowed, and all POSTed articles are piped to the SNPOST script, which has the final say in the matter. The value of $POSTING_OK is not currently used, but is reserved. FILES
/var/spool/sn/.fifo If this file exists, and is a fifo, snntpd will write the name of a newsgroup into it as that newsgroup becomes the current one. If the fifo does not exist snntpd will not create it. /var/spool/sn/.noservice If this file exists, snntpd will display its first line and exit. If the file can't be read or is empty, a default message is dis- played. This is useful for temporarily disabling the news server while you perform any maintenance. /var/spool/sn/.nopost See POSTING PERMISSIONS above. /var/spool/sn/.SNPOST If this script or program exists, it is invoked instead of SNPOST to accept a posted article. /var/spool/sn/news.group.name/.nopost These files really belong to SNPOST, and it is unfortunate that snntpd has to check for their existence to determine the posting flag for the LIST command. See /usr/sbin/SNPOST. /var/spool/sn/news.group.name/.info If this file exists, its first line is taken as the description of that group for use with the LIST NEWSGROUPS command. /var/spool/sn/news.group.name/.times is a binary file containing entry times, to support the NEWNEWS command. /var/spool/sn/news.group.name/.created is an empty file retained for it's timestamp, to support the NEWGROUPS command. SIGNALS
If snntpd catches SIGHUP, the files /var/spool/sn/{.fifo,.noservice,.nopost} (see below) are checked again, as they are during startup. Other signals have default behaviour. ENVIRONMENT VARIABLES
See also /usr/sbin/SNPOST for a list of environment variables exported by snntpd. PATH The PATH must be set such that snntpd can find SNPOST in order to accept postings. If PATH does not include /usr/sbin, /usr/sbin will be appended to it. POSTING_OK This variable helps determine the site-wide posting policy. See POSTING PERMISSIONS above. TCPREMOTEIP If this value is set, it is taken to be the dotted-quad IP address of the connecting client. If it is not set, snntpd attempts to derive it for itself, and then set its value. TCPLOCALIP as above, but for the server's dotted-quad IP. SNROOT If this is set and is not empty, the value is used everywhere in place of /var/spool/sn, the default news spool directory. SEE ALSO
snsend(8), /usr/sbin/SNPOST N.B. Harold Tay snntpd,v0.3.8(8)
All times are GMT -4. The time now is 01:32 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy