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)
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)
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)
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)
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)
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)
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)
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 DEBIAN
pscp
pscp(1) PuTTY tool suite pscp(1)NAME
pscp - command-line SCP (secure copy) / SFTP client
SYNOPSIS
pscp [options] [user@]host:source target
pscp [options] source [source...] [user@]host:target
pscp [options] -ls [user@]host:filespec
DESCRIPTION
pscp is a command-line client for the SSH-based SCP (secure copy) and SFTP (secure file transfer protocol) protocols.
OPTIONS
The command-line options supported by pscp are:
-V Show version information and exit.
-pgpfp Display the fingerprints of the PuTTY PGP Master Keys and exit, to aid in verifying new files released by the PuTTY team.
-ls Remote directory listing.
-p Preserve file attributes.
-q Quiet, don't show statistics.
-r Copy directories recursively.
-unsafe
Allow server-side wildcards (DANGEROUS).
-v Show verbose messages.
-load session
Load settings from saved session.
-P port
Connect to port port.
-l user
Set remote username to user.
-batch Disable interactive prompts.
-pw password
Set remote password to password. CAUTION: this will likely make the password visible to other users of the local machine (via com-
mands such as `w').
-1 Force use of SSH protocol version 1.
-2 Force use of SSH protocol version 2.
-C Enable SSH compression.
-i path
Private key file for authentication.
-scp Force use of SCP protocol.
-sftp Force use of SFTP protocol.
MORE INFORMATION
For more information on pscp it's probably best to go and look at the manual on the PuTTY web page:
http://www.chiark.greenend.org.uk/~sgtatham/putty/
BUGS
This man page isn't terribly complete. See the above web link for better documentation.
PuTTY tool suite 2004-03-24 pscp(1)