SQL Spool equivalent command in DOS Post: 96009

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...

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. 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...

4. Windows & DOS: Issues & Discussions

what is the DOS equivalent of alias command?

how do we create aliases to commands in dos? thanks

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. 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...

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...

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...

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, ...

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...

LEARN ABOUT OSF1

mrd

mrd(1)							      General Commands Manual							    mrd(1)

NAME

       mrd - mtools utility to remove a DOS directory

SYNOPSIS

       mrd msdosdirectory [msdosdirectories...]

DESCRIPTION

       The  mrd command removes a directory from a DOS file system.  If the directory is not empty, an error occurs.  Unlike DOS conventions, this
       command allows multiple arguments.

       DOS subdirectory names that contain the '/' or '' separator are supported.  If you use the '' separator or wildcards,	you  must  enclose
       file names in quotes to protect them from the shell.

       The mcd command can be used to establish the device and the current working directory (relative to DOS), otherwise the default is A:.

EXIT STATUS

       The following exit values are returned: Success.  Failure.

ENVIRONMENT VARIABLES

       The following environment variables affect the execution of mrd: If set, this variable names the file that contains the name of the current
       mtools working directory as established by the mcd command.  If this variable is not set, the file $HOME/.mcwd is used.

FILES

       Contains the name of the current mtools working directory as established by the mcd command.  If this file  does  not  exist,  the  default
       mtools working directory is A:.  Executable file

SEE ALSO

       Commands:  mcd(1), mmd(1), mtools(1)

																	    mrd(1)

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Command equivalent to DOS mode for SCO 5.0.6

Discussion started by: jgt

2. UNIX for Dummies Questions & Answers

Unix equivalent of DOS set

Discussion started by: xxavier

3. Programming

Single sql query to spool to multiple files

Discussion started by: Leion

4. Windows & DOS: Issues & Discussions

what is the DOS equivalent of alias command?

Discussion started by: milhan

5. Windows & DOS: Issues & Discussions

dos/intel unix command equivalent

Discussion started by: MizzGail

6. Shell Programming and Scripting

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

Discussion started by: shekharjchandra

7. Shell Programming and Scripting

UNIX/SQL loop to spool files!!

Discussion started by: vr23