I have chopped my case statementt out of my .profile and put it in another script called setsid. The case statement works when run from my .profile but not from my setsid file.
All that the script does is set an environmental variable based on user input. The variable is ORACLE_SID.
Here is my script.
Code:
#! /bin/sh
echo
echo "What do you want to set your ORACLE_SID to ?
1: wmsdata
2: wmstest
3: wmsctl"
echo
read RESPONSE DUMMY
case "$RESPONSE" in
1)
ORACLE_SID=wmsdata
export ORACLE_SID
alias pfile='cd $ORACLE_HOME/admin/wmsdata/pfile/'
alias bdump='cd $ORACLE_HOME/admin/wmsdata/bdump/'
alias udump='cd $ORACLE_HOME/admin/wmsdata/udump/'
;;
2)
ORACLE_SID=wmstest
export ORACLE_SID
alias pfile='cd $ORACLE_HOME/admin/wmstest/pfile/'
alias bdump='cd $ORACLE_HOME/admin/wmstest/bdump/'
alias udump='cd $ORACLE_HOME/admin/wmstest/udump/'
;;
3)
ORACLE_SID=wmsctl
export ORACLE_SID
alias pfile='cd $ORACLE_HOME/admin/wmsctl/pfile/'
alias bdump='cd $ORACLE_HOME/admin/wmsctl/bdump/'
alias udump='cd $ORACLE_HOME/admin/wmsctl/udump/'
;;
*)
ORACLE_SID=wmsdata
export ORACLE_SID
alias pfile='cd $ORACLE_HOME/admin/wmsdata/pfile/'
alias bdump='cd $ORACLE_HOME/admin/wmsdata/bdump/'
alias udump='cd $ORACLE_HOME/admin/wmsdata/udump/'
;;
esac
The problem is that when I run this script the ORACLE_SID stays the same and does not change.
when I set -vx I notice that th list of commands associated with the reponse do run, yet the variable does not change.
i keep getting the following error with the code segment below when i try to compile the program.
parse error before '('
parse error before ')'
stray '\' in program
this is the code segment and the error is on the second line of the segment
#define DEBUG(fmt) if(traceflag) {... (1 Reply)
Hello:
I'm trying to run repquota -ag > /home/usersdir/repquota.txt as a daily cronjob at midnight, but the file always ends up blank.
I even tried writing a quick Perl script to e-mail me what running that command outputs, and it's nothing.
Can root run repquota as a cronjob? Do I have... (1 Reply)
I am trying to run the following code from a script file but it complains that syntax of (both instances of) grep is wrong.
When I copy and paste it to the terminal, it is OK. Any idea what the problem might be?
set i = `grep -c #define flags.h`
while ($i>20)
@ i--
my func (`cat... (4 Replies)
Hi guys, I've been trying to unmount a floppy like this:
unmount /mnt/floppy
But then I get a "command not found" message."mount" works,but why not unmount? I've also tried "eject" but all it does is open up my cdrom drive and I tried "eject /mnt/floppy" but I get an error that says Invalid... (2 Replies)
I'm using the case statement in the following script and it always takes the "*" default choice while it should be "3".
I wonder why ???
dt_auj=`date +%d`
NBLOG=`ls -al /users/notes01/LOG/t*|awk '{print $7}'|grep $dt_auj|wc -l`
case $NBLOG in
1) cat ~/LOG/console-notes > $fic_tmp1 ;;
2)... (5 Replies)
Howdie everyone...
I have a shell script RemoveFiles.sh
Inside this file, it only has two commands as below:
rm -f ../../reportToday/temp/*
rm -f ../../report/*
My problem is that when i execute this script, nothing happened. Files remained unremoved. I don't see any error message as it... (2 Replies)
completion-ignore-case option doesn't work in my version:
/home/user $ echo $BASH_VERSION
3.2.48(1)-release
/home/user $ ls -l *
-rw-r--r-- 1 user user 0 2009-10-18 00:09 somefile
-rw-r--r-- 1 user user 0 2009-10-18 00:09 Somefile
/home/user $ set completion-ignore-case on
But when I... (2 Replies)
I have the following and for some reason I can't have two options together.
I mean if I choose -u and -p it won't work... why?
#!/bin/bash
resetTime=1
mytotalTime=0
totalHour=0
totalMin=0
averagemem=0
finalaverage=0
times=0
function usage()
{
cat << EOF
USAGE: $0 file
EOF
} (10 Replies)
greetings,
the following code isn't working as i expect it to. the first dbl brackets do but the second set gets ignored. ie: if i'm on t70c6n229 it echoes "Something" and i expect it not to. what am i missing?
if " ]] || " ]]; then
echo "Something"
fi
thanx! (9 Replies)
Discussion started by: crimso
9 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)