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 OSX
execute
EXECUTE(7) SQL Commands EXECUTE(7)NAME
EXECUTE - execute a prepared statement
SYNOPSIS
EXECUTE name [ ( parameter [, ...] ) ]
DESCRIPTION
EXECUTE is used to execute a previously prepared statement. Since prepared statements only exist for the duration of a session, the pre-
pared statement must have been created by a PREPARE statement executed earlier in the current session.
If the PREPARE statement that created the statement specified some parameters, a compatible set of parameters must be passed to the EXECUTE
statement, or else an error is raised. Note that (unlike functions) prepared statements are not overloaded based on the type or number of
their parameters; the name of a prepared statement must be unique within a database session.
For more information on the creation and usage of prepared statements, see PREPARE [prepare(7)].
PARAMETERS
name The name of the prepared statement to execute.
parameter
The actual value of a parameter to the prepared statement. This must be an expression yielding a value that is compatible with the
data type of this parameter, as was determined when the prepared statement was created.
OUTPUTS
The command tag returned by EXECUTE is that of the prepared statement, and not EXECUTE.
EXAMPLES
Examples are given in the Examples [prepare(7)] section of the PREPARE [prepare(7)] documentation.
COMPATIBILITY
The SQL standard includes an EXECUTE statement, but it is only for use in embedded SQL. This version of the EXECUTE statement also uses a
somewhat different syntax.
SEE ALSO
DEALLOCATE [deallocate(7)], PREPARE [prepare(7)]
SQL - Language Statements 2010-05-14 EXECUTE(7)