03-27-2013
Thanks sir...
I have verified and executed the script once again.. but no luck.. As you said.. second END_SCRIPT here statement started exactly at the beginning of the file and not sure that it executed for you..
Are there any other possibilities ??
Regards,
J
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello everyone,
Have a question which I'm not entirely sure about, but will ask anyway.
We have three servers (A/B/C), 'A' being the local host, 'B' being a SFTP server on the DMZ, and 'C' being the intended remote host. The task is to transfer file/s from server 'A' to server 'C' via server... (0 Replies)
Discussion started by: Cameron
0 Replies
2. UNIX for Advanced & Expert Users
hi,
I need to sftp a file from one unix system to another unix system.
eg: filename is test.txt
servername : abc@xyz
please give me the sftp command for that.
thanks in advance..
mohan.p (2 Replies)
Discussion started by: mohanpadamata
2 Replies
3. Shell Programming and Scripting
hi
i am trying to login to remote server using SFTP Protocol and trying to upload a file butit is asking for the password.
Note: I am trying to connect to FrontEnd server
sftp SFTREGUP1@14.71.26.6
Connecting to 14.71.26.6...
Password Authentication
Password:
Please help (14 Replies)
Discussion started by: Satyak
14 Replies
4. Shell Programming and Scripting
Hello -
I have text file and need to load the data in Oracle through sqlloader.
I need to move this file to unix server and load into oracle. When i SFTP(unfortunately i do not have FTP)
to unix box, each line is appended with ControlM character...
since it is transferring in BINARY... (4 Replies)
Discussion started by: govindts
4 Replies
5. UNIX for Dummies Questions & Answers
I am able to connect to a site and start a file transfer via SFTP, but when the file reaches "100%" -- the file does not complete and "stop". The 100% transfer status does not change (obviously), but the timer for SFTP keeps going and will not complete. This also happens when I try to get a file.... (2 Replies)
Discussion started by: loganban
2 Replies
6. Shell Programming and Scripting
Hello all,
I have a requirement, in which we need to stage a package to Unix remote server in an automation (we cant use ssh key generation) , do u have any idea how we can transfer the package to remote server using sftp .if you have any script plz share it to me (4 Replies)
Discussion started by: Ramji Sundaram
4 Replies
7. Shell Programming and Scripting
Hi,
I want to a transfer file from remote machine to a local machine using SFTP where both my local and remote machines are Ubuntu machines.So i wanted to write a unix bash script which uses SFTP command to transfer the file from remote to local machine.
My remote server is 178.28.30.106. ... (14 Replies)
Discussion started by: shree11
14 Replies
8. UNIX for Dummies Questions & Answers
Hi guys,
Need a quick and urgent help on below issue.
One of our application is try to transfer the file to another host thru sftp process
My file is about 1 GB.
Job is getting hung while transferring the file. So when I login as sftp and check the file system space is only in MB... (2 Replies)
Discussion started by: Vinoth Kumar G
2 Replies
9. UNIX for Dummies Questions & Answers
Hi All,
I have a file in windows when I transfer it using sftp it is getting as single line. I tried to do both ascii and binary
File:
is transfered as
Can you please let me know how can do the transfer as same as XML file
Thanks,
Arun (1 Reply)
Discussion started by: arunkumar_mca
1 Replies
10. UNIX for Beginners Questions & Answers
Hi All,
I am having an issue with the script execution. I am having a SFTP process that send files to a location . I want to execute a script once it transfer the file to that location. Right now I am leveraging autosys file watcher to do that. Is there any way like MFT PPA that can execute... (2 Replies)
Discussion started by: arunkumar_mca
2 Replies
LEARN ABOUT PHP
sqlsrv_free_stmt
SQLSRV_FREE_STMT(3) SQLSRV_FREE_STMT(3)
sqlsrv_free_stmt - Frees all resources for the specified statement
SYNOPSIS
bool sqlsrv_free_stmt (resource $stmt)
DESCRIPTION
Frees all resources for the specified statement. The statement cannot be used after sqlsrv_free_stmt(3) has been called on it. If sql-
srv_free_stmt(3) is called on an in-progress statement that alters server state, statement execution is terminated and the statement is
rolled back.
PARAMETERS
o $stmt
- The statment for which resources are freed. Note that NULL is a valid parameter value. This allows the function to be called
multiple times in a script.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
sqlsrv_free_stmt(3) example
<?php
$serverName = "serverNamesqlexpress";
$connectionInfo = array( "Database"=>"dbName", "UID"=>"username", "PWD"=>"password");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn === false ) {
die( print_r( sqlsrv_errors(), true));
}
$stmt = sqlsrv_query( $conn, "SELECT * FROM Table_1");
if( $stmt === false ) {
die( print_r( sqlsrv_errors(), true));
}
/*-------------------------------
Process query results here.
-------------------------------*/
/* Free the statement resources. */
sqlsrv_free_stmt( $stmt);
?>
NOTES
The main difference between sqlsrv_free_stmt(3) and sqlsrv_cancel(3) is that a statement resource cancelled with sqlsrv_cancel(3) can be
re-executed if it was created with sqlsrv_prepare(3). A statement resource cancelled with sqlsrv_free_statement(3) cannot be re-executed.
SEE ALSO
sqlsrv_cancel(3).
PHP Documentation Group SQLSRV_FREE_STMT(3)