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 PHP
maxdb_real_escape_string
MAXDB_REAL_ESCAPE_STRING(3) 1 MAXDB_REAL_ESCAPE_STRING(3)
maxdb_real_escape_string - Escapes special characters in a string for use in an SQL statement, taking into account the current charset of the con-
nection
Procedural style
SYNOPSIS
string maxdb_real_escape_string (resource $link, string $escapestr)
DESCRIPTION
Object oriented style
string maxdb::real_escape_string (string $escapestr)
This function is used to create a legal SQL string that you can use in an SQL statement. The string escapestr is encoded to an escaped SQL
string, taking into account the current character set of the connection.
Characters encoded are ', ".
RETURN VALUES
Returns an escaped string.
EXAMPLES
Example #1
Object oriented style
<?php
$maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");
/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s
", maxdb_connect_error());
exit();
}
$maxdb->query("CREATE TABLE temp.mycity LIKE hotel.city");
$city = "'s Hertogenbosch";
/* this query will fail, cause we didn't escape $city */
if (!$maxdb->query("INSERT into temp.mycity VALUES ('11111','$city','NY')")) {
printf("Error: %s
", $maxdb->sqlstate);
}
$city = $maxdb->real_escape_string($city);
/* this query with escaped $city will work */
if ($maxdb->query("INSERT into temp.mycity VALUES ('22222','$city','NY')")) {
printf("%d Row inserted.
", $maxdb->affected_rows);
}
$maxdb->close();
?>
Example #2
Procedural style
<?php
$link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");
/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s
", maxdb_connect_error());
exit();
}
maxdb_query($link, "CREATE TABLE temp.mycity LIKE hotel.city");
$city = "'s Hertogenbosch";
/* this query will fail, cause we didn't escape $city */
if (!maxdb_query($link, "INSERT into temp.mycity VALUES ('11111','$city','NY')")) {
printf("Error: %s
", maxdb_sqlstate($link));
}
$city = maxdb_real_escape_string($link, $city);
/* this query with escaped $city will work */
if (maxdb_query($link, "INSERT into temp.mycity VALUES ('22222','$city','NY')")) {
printf("%d Row inserted.
", maxdb_affected_rows($link));
}
maxdb_close($link);
?>
The above example will output something similar to:
Warning: maxdb_query(): -5016 POS(43) Missing delimiter: ) <...>
Error: 42000
1 Row inserted.
SEE ALSO
maxdb_character_set_name(3).
PHP Documentation Group MAXDB_REAL_ESCAPE_STRING(3)