|
|
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
01-17-2006
SQL Spool equivalent command in DOS
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
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
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
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
how do we create aliases to commands in dos?
thanks (9 Replies)
Discussion started by: milhan
9 Replies
5. Windows & DOS: Issues & Discussions
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
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
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
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
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
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
LEARN ABOUT ULTRIX
uumkspool
uuaids(8c) uuaids(8c) Name uucompact, uumkspool, uurespool, uupoll - uucp utilities Syntax uucompact -ssystem uumkspool system ... uurespool [ -t# ] uupoll system ... Description All of the commands are located in The command compacts uucp system spool directories and associated subdirectories. If system is ALL, then all existing uucp system spool directories are compacted. Otherwise, only the specified system spool directory is compacted. If no system is specified, is compacted. If is stopped before it is finished, it can be restarted without reprocessing directories. The command continues processing where it left off during it's previous instantiation. The command makes a per system spool directory and associated subdirectories for each of the specified systems. For example, if system is mk3 and if the local system name is penny, the following directories are created: /usr/spool/uucp/sys/mk3 /usr/spool/uucp/sys/mk3/C. /usr/spool/uucp/sys/mk3/X. /usr/spool/uucp/sys/mk3/D. /usr/spool/uucp/sys/mk3/D.penny /usr/spool/uucp/sys/mk3/D.penny The command moves files from old spool directories to new spool directories. Because the structure of the spool directories has changed from older versions of it is necessary to respool old spooled files to new spool directories in at least two instances: o When installing the current version of o When creating a new system spool directory for each system. In the latter case, it is necessary to move files from to the new spool directories. To ease this task, moves files that have been spooled in one of 4 formats and respools them under the new spooling structure. The format is specified by the -t# option, where the number sign (#) can be any one of the following: o Original spool - All files are in o Split spool - Contains the subdirectories o Modified split spool - Contains all subdirectories listed in split spool, and o Used when a new system directory has been created and spool files must be moved from the DEFAULT directory to the new system directory. The command forces a connect attempt to the named systems even if recent attempts have failed, but not if the file prohibits the call. For example, the file will prohibit the call if it is the wrong time of day. Thus, the should be monitored for messages about the connection. Files Spool directory Logfile See Also mail(1), uucp(1c), uux(1c) uuaids(8c)