03-15-2013
Well, fuser will tell you if it is still open for output.
If you have ssh, you can pipe it up in real time to a temp name and decide later if it completed.
You could write a magic string on the file end, perhaps in SQL, and use sed -i or the like to remove it later.
You could run the query up there over tcp/ip and save the copying. The term tlisten comes to mind. Excel data import odbc is nice, too, and Access odbc link.
Often, you can see errors or success in the log if you divert non-data lines there.
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi,
i m working on a perl cgi script which uploads a file to the server. i m stuck. i hav written the errors.
plz help.
Sachin Kaw
______________________________________________________________________
#!/usr/bin/perl -w
use CGI;
use CGI qw(:standard);
use strict;
use POSIX... (4 Replies)
Discussion started by: sachin_kaw
4 Replies
2. Shell Programming and Scripting
Hi
I have an excel file with only 5 rows .I want to uplaod those 5 rows to a database using a shell script.Is this possible.If so where do i start.
Thnks (1 Reply)
Discussion started by: magikminox
1 Replies
3. Shell Programming and Scripting
Hi All,
I am trying to upload a text file from HP unix to Windows tectia server using sftp, the text file shows with new line character after upload.
For EG : abc.txt file contains
123
456
aftre upload it shows as
123 456
i am using sftp version 2.0
TQ, (4 Replies)
Discussion started by: phani1312
4 Replies
4. Shell Programming and Scripting
Hi all
i have a such question this is my shell script my script must upload file to webdav server
//////////////////////////////////////////////////////////////////////////////////////////////////////////////
#!/bin/sh
###... (1 Reply)
Discussion started by: knut
1 Replies
5. Shell Programming and Scripting
Hi Experts ,
I am new to unix programming please tell me how to write expect and hoe to call it for automated file upload process.
help me really ! (0 Replies)
Discussion started by: kulbhushan
0 Replies
6. Ubuntu
Hi All,
I want to upload file through SFTP in non interactive mode
on remote server. please tell me what will have to do in oreder to do SFTP . (1 Reply)
Discussion started by: kulbhushan
1 Replies
7. Shell Programming and Scripting
Hello,
I have a script that finds the latest version of a file in a folder on my Minecraft server. I'm trying to come up with something that will then FTP that file over to my fileserver.
Here's what I have that finds the newest file:
find /home/mc/archive/sbhouse -type f -mtime +45 -exec... (7 Replies)
Discussion started by: nbsparks
7 Replies
8. Proxy Server
I have a requirement of following -
1. Transfer excel spreadsheet from desktop to unix server
2. Open the spreadsheet and read the sql row by row at a time
3. Run each sql on database using unix and then send output back to spreadsheet that was uploaded earlier and then transfer file back to... (12 Replies)
Discussion started by: Analabhatla
12 Replies
9. Shell Programming and Scripting
Hi,
Below script is running on AIX 7.1 ( 7100-04-05-1720 version ) server. Recently OpenSSH version installed on server got updated from OpenSSH_6.0p1 to OpenSSH_7.5p1 version. After this update we do not receive any file upload message after put/mput command in SFTP.
sftp -b - user@server... (1 Reply)
Discussion started by: Juggernaut
1 Replies
LEARN ABOUT DEBIAN
odbcinst
odbcinst(1) UnixODBC Reference odbcinst(1)
NAME
odbcinst - command line tool for batch ODBC configuration
SYNOPSIS
odbcinst action object options
action is one of
-i install a driver or data source
-u uninstall a driver or data source
-q query a list of drivers or data sources present on the system
--version
shows the version number of the program
object is one of
-d an ODBC driver in /etc/odbcinst.ini
-s an ODBC Data Source Name (DSN) in an odbc.ini file.
options are zero or more of
-f template file
Used with -i, this option specifies a template file containing the driver or DSN to be installed.
-r Read the template from standard input.
-n Driver/Data Source Name
Used with -u to specify a driver or DSN to remove.
-v Contrary to standard practice, this turns off verbose output; there is no output, even for errors.
-l The specified Data Source object is a System DSN, in /etc/odbc.ini.
-h The specified Data Source object is a User DSN, in the current user's $HOME/.odbc.ini. This is the default with -s.
DESCRIPTION
odbcinst updates the configuration files that control ODBC access to database servers on the current host. It also maintains in
/etc/odbcinst.ini a count of the number of references to a particular driver, which can be used to determine whether it should be removed
from the file (only when the reference count drops to 0).
Installing
Drivers and DSNs are installed using the -i option.
If the object to be installed is a driver (-d), the specified driver is added to /etc/odbcinst.ini or its reference count is incremented if
it is already there.
If the object is a data source (-s), the data source is added either to /etc/odbc.ini (if -l is used) or to $HOME/.odbc.ini (the default,
which can also be specified with -h).
Uninstalling
Uninstalling a driver is done with the command odbcinst -u -d -n driver name. Uninstalling a DSN is done with the command odbcinst -u -s
-n data source name. Uninstalling causes the reference count on the object to be decremented. If nothing else has requested this driver
or DSN (i.e., the reference count drops to zero), it is removed from the config file.
The options -l and -h are used with -s to specify which odbc.ini file to configure.
Queries
The command odbcinst -q -d returns a list of all drivers present in /etc/odbcinst.ini. The command odbcinst -q -s returns a list of all
system and user DSNs available.
EXIT STATUS
0 Success
non-zero
Failure
TEMPLATE FILES
A typical driver template looks like this:
[MySQL]
Description = MySQL driver
Driver = /usr/lib/odbc/libmyodbc.so
Setup = /usr/lib/odbc/libodbcmyS.so
A DSN template looks like this:
[Sample DSN]
Description = Test MySQL connection
Driver = MySQL
Trace = Yes
TraceFile = /tmp/odbc.log
Database = junk
Server = localhost
Port = 3306
Socket =
The Description and Driver fields should be present in all DSN configurations. Other options are driver-specific; consult your ODBC
driver's documentation for a list of allowed options, or see ODBCConfig(1) for a graphical tool that can be used to interactively set up a
DSN or driver the first time.
FILES
/etc/odbcinst.ini, /etc/odbc.ini, $HOME/.odbc.ini
AUTHOR
This manual page was written by Oliver Elphick <olly@lfix.co.uk> and Steve Langasek <vorlon@debian.org> for the Debian package of unixODBC.
SEE ALSO
ODBCConfig(1), gODBCConfig(1)
UnixODBC 2nd Mar 2002 odbcinst(1)