I have writtern a shell script which has a sql query. I want to send the results of sql query to a shared area over a network.I also want to log the errors in a log file if the text file is not sent to shared area.
The results of sql query are spooled in TEMPFILE.
LOGFILE contains path where the log files will be generated.
I am using following code to send the results of this sql query as a xls file to remote machine and log the error.
But, the text file which contains sql query results is not pushed in shared area and also log file is not getting updated.
Please help on this.
Regards,
Sac
Last edited by zaxxon; 10-29-2009 at 08:21 AM..
Reason: code tags
1)In this script mput command is not working( not transfering multiple files, it is able to send single file)
2)here is the script to automate the ftp process .
3)for transfering files from one machine to other machine using ftp
can anyone can give me the solution in this issue
Script is... (6 Replies)
hi
I have made d below ftp script but the last part of script ie. moving the files after transfer (to a location in the source server only) is not working for me.
Can anybody pls..help.in same..!!!
#######################################################
#!/bin/sh
ftp -n 10.209.13.11... (2 Replies)
Trying to figure out why this works:
printpwd.pl
#!/usr/bin/perl
use CGI::Carp qw( fatalsToBrowser );
print "Content-type: text/html\n\n";
$A = system("pwd");
$A = `pwd`;
print "$A\n";
^^actually that works/breaks if that makes any sense.. i get the working directory twice but when... (5 Replies)
Hi All,
can some one please help me to solve this issue, its urgent:confused:
We need to FTP a file form our Unix server to an external client FTP location.
I am trying to connect to the proxy server first and then use the below USER comment to connect to the external FTP server, and its working... (3 Replies)
Hello everyone,
sorry for the title, most of you must getting sick of reading something like
this, but I haven't found a solution, although I found many threads according
to it.
I'm working on a bash script that connects to a network printer with ftp
where I want to upload a pdf created... (3 Replies)
Hi Gurus,
I prepared a script to process some files and then ftp the output file to mainframe directory. Here is the code snippet for the same.
# Perform FTP
echo "put $TGT_DR/$K.$F.$I.$K1.$RUN_TYPE '$K.$F.$I.$K1.$RUN_TYPE'" >> $LogFile
ftp -i -n <<EOF >> $LogFile
open... (2 Replies)
hi,
Im using the following code for FTP
#!/usr/bin/ksh
ftp -v -n "10.29.45.11" << cmd
user "mahesva" "mahesva123"
get rtl.tar
quit
cmd
Below is the log when i run the above code
**********************************
Connected to 10.29.45.11.
220 (vsFTPd 2.0.1)
530 Please login with USER... (20 Replies)
Dear All,
I have script.
Dest=""
IFS='
'
for translation in $(echo $MY_MAP)
do
t1=$(echo $translation | cut -d"=" -f1)
t2=$(echo $translation | cut -d"=" -f2| cut -d"," -f1)
if
then
Dest=$UNX/$u_product_path/$u_study_path/$UNXTR/$t2
break;
... (4 Replies)
Hi ,
Hi ,
seems in my code '\' is ignoring in user id and considering DB_SVCGPRUAT as a ID and failing to connect to the FTP server. my complete ID 'BD\SVCGPRUAT', how to rectify this error.
#!/bin/bash
myuser='"BD\_SVCGPRUAT" { BD is domain }
mypass='Welcome$123'... (4 Replies)
Hi,
I have one FTP script which simply sends the file to target server via netrc.it used to work as normal for years.recently target server IP got changed , same has been updated in .netrc but unable to connect it via FTP though netwrk guys already opened the port 21,20 and 22 .
NETRC... (7 Replies)
Discussion started by: Riverstone
7 Replies
LEARN ABOUT PHP
cubrid_ping
CUBRID_PING(3) 1 CUBRID_PING(3)cubrid_ping - Ping a server connection or reconnect if there is no connectionSYNOPSIS
bool cubrid_ping ([resource $conn_identifier])
DESCRIPTION
Checks whether or not the connection to the server is working.
PARAMETERS
o $conn_identifier
- The CUBRID connection identifier. If the connection identifier is not specified, the last connection opened by cubrid_connect(3)
is assumed.
RETURN VALUES
Returns TRUE if the connection to the server CUBRID server is working, otherwise FALSE.
EXAMPLES
Example #1
cubrid_ping(3) example
<?php
set_time_limit(0);
$conn = cubrid_connect('localhost', 33000, 'demodb');
/* Assuming this query will take a long time */
$sql = "select * from athlete";
$result = cubrid_query($sql);
if (!$result) {
echo 'Query #1 failed, exiting.';
exit;
}
/* Make sure the connection is still alive, if not, try to reconnect */
if (!cubrid_ping($conn)) {
echo 'Lost connection, exiting after query #1';
exit;
}
cubrid_free_result($result);
/* So the connection is still alive, let's run another query */
$sql2 = "select * from code";
$result2 = cubrid_query($sql2);
?>
PHP Documentation Group CUBRID_PING(3)