read readTerminal
terminal_c=$readTerminal
if [$terminal_c == 'B' || $terminal_c == 'K' || $terminal_c == 'T'];
then
{
#Execute the first SQL query
}
else
echo next script
fi
anything wrong here?
[QUOTE=ment0smintz;302708021]
Code:
read readTerminal
terminal_c=$readTerminal
if [ $terminalc = 'B' -o $terminalc = 'K' -o $terminalc = 'T' ]
then
{
#Execute the first SQL query
}
elif [ $terminalc = 'P' -o $terminalc = 'Q' ] then
#Execute the second SQL query
else
echo next script
fi
Last edited by ment0smintz; 10-01-2012 at 05:09 AM..
Reason: solved
Anyone have guide to install samba on solaris 9
I tried couple of times. --How do I go about uninstalling it?
bash-2.05# testparm -s > output.file
Load smb config files from /usr/local/samba/lib/smb.conf
Processing section ""
Processing section ""
Loaded services file OK.
bash-2.05#... (2 Replies)
In my ksh script, if the conditions of a if statement are true, then do nothing; otherwise, execute some commands.
How do I write the "do nothing" statement in the following example?
Example:
if (( "$x"="1" && "$y"="a" && "$z"="happy" ))
then
do nothing
else
command
command
fi... (3 Replies)
Hi All,
I am using Unix ksh script.
I need to insert values to a table using the o/p from a slelect statement.
Can anybody Help!
My script looks like tihs.
---`sqlplus -s username/password@SID << EOF
set heading off
set feedback off
set pages 0
insert into ${TB_NAME}_D... (2 Replies)
Hi,
Does anybody success install GD and apply it in linux?
I got trying to install it recently. Unfortunately, it seems like got a lot of error message shown :(
Thus anybody got success install and use the GD in linux? Can share it with me?
I'm using ia64 linux system.
Thanks a lot for all... (6 Replies)
Hi All,
I am kinda struck at one point :wall: need ur help to move further.
Query:
My inputs files are
Expected output:
I am sure there should be similar tread relating my query ..but as i couldnt find the details i am posting again.
Please direct me to the tread or reply... (1 Reply)
Hi folks,
I have a scenario to convert the update statements into insert statements using shell script (awk, sed...) or in database using regex.
I have a bunch of update statements with all columns in a file which I need to convert into insert statements.
UPDATE TABLE_A SET COL1=1 WHERE... (0 Replies)
Discussion started by: dev123
0 Replies
LEARN ABOUT REDHAT
execute
EXECUTE(7) SQL Commands EXECUTE(7)NAME
EXECUTE - execute a prepared query
SYNOPSIS
EXECUTE plan_name [ (parameter [, ...] ) ]
INPUTS
plan_name
The name of the prepared query to execute.
parameter
The actual value of a parameter to the prepared query. This must be an expression yielding a value of a type compatible with the
data-type specified for this parameter position in the PREPARE statement that created the prepared query.
DESCRIPTION
EXECUTE is used to execute a previously prepared query. Since prepared queries only exist for the duration of a session, the prepared query
must have been created by a PREPARE statement executed earlier in the current session.
If the PREPARE statement that created the query 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 queries are not overloaded based on the type or number of
their parameters: the name of a prepared query must be unique within a database session.
For more information on the creation and usage of prepared queries, see PREPARE [prepare(7)].
COMPATIBILITY
SQL92
SQL92 includes an EXECUTE statement, but it is only for use in embedded SQL clients. The EXECUTE statement implemented by PostgreSQL also
uses a somewhat different syntax.
SQL - Language Statements 2002-11-22 EXECUTE(7)