I'm getting an else unmatched error on the script below..
For info : SYDB is the database name entered as a param on the command line.
#Check the DB name
HBDB=`sql $SYDB <<_END_ | grep '^|' | grep -v dbase | sed 's/|//g' | sed 's/ //g'
set autocommit on;
\p\g
set lockmode... (7 Replies)
Hi,
I would like to create an IF statement where if a variable is equal to at least one of 2 (or more) values then the script proceeds. For example:
TEST_VAR=2
if ; then
echo success!
else
echo failure
fi
I understand that the above syntax is wrong but I feel it must be close. Any... (1 Reply)
:b:Hi guys,
I am getting this error in this piece of code, Any help will be appreciate
rypidoc.shl: syntax error at line 79 : `for' unmatched
##Determine if there is a file to process
ls 3526*.dat > /dev/null 2>&1
if
then
exit
fi
for i in 3526*.dat
do
# Capture just the file... (2 Replies)
#!/usr/bin/perl
$output1 = "/home/log.txt"
$output2 = "/home/grep.txt"
#Statement1 creates an output file called log.txt.
#Statement2 greps a line from log.txt and store the result in grep.txt
I want to create a condition where if the file grep.txt is empty repeat process.
Thanks. (1 Reply)
Hello forum members.
please go through the below mentioned issue and let me know the right solution.
I have to write a script which runs another script .the executable script take input parmeters.so iam writing the the script below .
Sample Code:Begins
#! /bin/ksh
echo " enter... (2 Replies)
Hi All,
I am trying to put multiple conditions in an IF Statement (using $$). the Linux script somehow doesnt like it. The logic I am trying to implement is as follows,
1. I will first search for DateFile.txt
2. If it exists & there is a P_BUS_DATE value in it, then assign the date value... (5 Replies)
Hi,
I am running sinple ksh script .
From some reason it failed on the following error:
./ogg_status.sh: syntax error at line 16 : `<<' unmatched
Please advise.
#!/usr/bin/ksh
export ORACLE_HOME=/software/oracle/DB10gR2
export LD_LIBRARY_PATH=/software/oracle/DB10gR2/lib:/usr/lib... (4 Replies)
Hi,
I tried to go through a lot of online material but could not find concrete solution.
My issues is like this :
I've got a input file like this :
<a>
<startDate>19700101000000</startDate>
<endDate>20300101000000</endDate>
</a>
... (12 Replies)
Hi,
I need to put two condition in if statement, but it is not working. Please suggest.
if
---------- Post updated at 07:05 AM ---------- Previous update was at 06:55 AM ----------
Also when i put below command in script it is not running, but manually it is running
... (4 Replies)
Hi all,
I want to call a plsql package that does not return any value.
I am using the following script to do so:
sqlplus $UserNamePwd <<EOF
set head off
begin
test_pkg.procedure('$DebugFlag');
end;
exit
EOF
if
then
log_message "procedure failed."
exit 1
fi
exit $?
I... (2 Replies)
Discussion started by: reshma15193
2 Replies
LEARN ABOUT PHP
mssql_free_statement
MSSQL_FREE_STATEMENT(3)MSSQL_FREE_STATEMENT(3)mssql_free_statement - Free statement memorySYNOPSIS
bool mssql_free_statement (resource $stmt)
DESCRIPTION mssql_free_statement(3) only needs to be called if you are worried about using too much memory while your script is running. All statement
memory will automatically be freed when the script ends. You may call mssql_free_statement(3) with the statement identifier as an argument
and the associated statement memory will be freed.
PARAMETERS
o $stmt
- Statement resource, obtained with mssql_init(3).
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
mssql_free_statement(3) example
<?php
// Create a new statement
$stmt = mssql_init('test');
// Bind values here and execute the statement
// once we're done, we clear it from the memory
// using mssql_free_statement like so:
mssql_free_statement($stmt);
?>
SEE ALSO mssql_bind(3), mssql_execute(3), mssql_init(3), mssql_free_result(3).
PHP Documentation Group MSSQL_FREE_STATEMENT(3)