Hello
#!bin/ksh
sqlplus -s system/manager < |grep '^ORA' |uniq
select * from kk;
set echo on
show spool on
end;
/
EOF
save test.sh
sh test.sh
results
ORA-00942: table or view does not exist (3 Replies)
Hi
I'm hoping I could get some help on the following. I'm writing a script which will in turn create an ftp script then excecute it. eg
echo "user $user $pass" > $script
echo "cd $remote_dir" >> $script
echo "bi" >> $script
echo "mput $file" >> $script
echo "bye" >> $script
ftp -n -i $ip... (1 Reply)
I have written a UNIX script that will automatically ftp a file to a server. The problem is when I missed enter information w/in the .txt file that contains the userid/password and what file to transfer, I had no way of capturing the failuer of the file transfer. I verified w/in the script that the... (1 Reply)
Hi,
Can anybody tell me how to error trap an empty line. If i am asked for a password and I hit enter without entering any text, how do i display an error?
Thanks
Kev (6 Replies)
I am writing a program which is something like below:
rsh host1 "rcp file dest:directory"
I am running this script from a machine host2.
host1 has rlogin configuration for host2.
but, dest machine has no rlogin configuration for host1 and fails on remote calls.
Could anyone tell me how... (2 Replies)
Greets all. I'm using Slackware 12.0 with the bash shell. Calling my scripts with /bin/sh...
I'm building gnome-2.18.3 and I have all my build scripts ready and working but I'm calling them from a parent script which executes each child/build script in a certain order (for loop).
I have "set... (6 Replies)
This is gonna sound dumb but...
1 It seems that I cannot use the search function here properly.
In researching to find a solution to an FTP error trapping issue, I go to the search option in the forum and use FTP as a search term and ask it to select all forums to search in..... I get no... (2 Replies)
How can I trap and print "cannot find the pattern" when the grep is unable to find the specified pattern in the file using the for loop below ?
Any help would be appreciated.
bash3.4> cat test_file
apple
orange
pineapple
blackberry
script:
for x in `grep -n "mango" test_file... (4 Replies)
I hope that I can trap curl errors, and have my shell script error out and quit if curl has any sort of problem.
For example, I have the following command in my shell script:
curl --trace -n -v --ftp-ssl ftp://xxx.xxx.xxx.xxx:2122 --user user:password -o /tmp/file.txt
Works great, except... (2 Replies)
I have a requirement:
During copy command for example:
cp -rf <sourceDir> <destinationDir>
this command may fails for many reasons like:
1. source or destination directory does not exist
2. destination directory does not have sufficient space
3. directories are not mounted
... Or may... (3 Replies)
Discussion started by: ambarginni
3 Replies
LEARN ABOUT PHP
sqlsrv_free_stmt
SQLSRV_FREE_STMT(3)SQLSRV_FREE_STMT(3)sqlsrv_free_stmt - Frees all resources for the specified statementSYNOPSIS
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)