09-14-2006
i think you should do the check inside your SQL statement instead..like where FAILED_LOGIN_ATTEMPTS = 3 or something...just a suggestion..
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
i'm not looking for anything that deals with "if-then" scripts.
i'd like something simple on how to run a series of processes. for example the following:
1. ftp://ftp.netbsd.org/pub/NetBSD/NetBSD-current/tar_files/
2. lcd /
3. get pkgsrc.tar.gz
4. bye
5. cd /usr
6. rm -rf pkgsrc
7. cd... (3 Replies)
Discussion started by: xyyz
3 Replies
2. Shell Programming and Scripting
I am new to scropting and I am just trying to work on a few simple things....
Using sh I want to do something similar to the follwoing run a simple command like a dig then I want it to get the server that it is authorotative and return it to me saying somehting like xx.xx is authorotative. I am... (3 Replies)
Discussion started by: gennaro
3 Replies
3. Shell Programming and Scripting
can someone pls help me with the script for a files coming from one system to a particular directory and i want to write a script to move those files to another directory on different system by renaming the files...
pls someone help me on this...
thanking in anticipation.... (1 Reply)
Discussion started by: thatiprashant
1 Replies
4. Shell Programming and Scripting
Dear All,
forgive me as i am a complete beginner in shell scripting in UNIX.
I have a file with data similair to the following
8 McDonalds Sandwich 1.99
9 Mcdonalds Fries 1.20
13 McDonalds Milkshake 1.20
7 ... (9 Replies)
Discussion started by: Mary_xxx
9 Replies
5. Shell Programming and Scripting
hi..
I want to customize a user in unix which could have only ftp access and NO TELNET ACCESS! .....
As being a newbie to unix to my understanding the user .profile has to be edited but if someone can explain how to edit it so that i can block telnet access for that user.....Is /etc/profile has... (5 Replies)
Discussion started by: rookie250
5 Replies
6. UNIX for Advanced & Expert Users
i want to write a script that if the time is 8 then it give a message that the time is 8 and if it is 9-10 then it gives a message that time to go to office like that.
can any one help me? (3 Replies)
Discussion started by: lakshmananindia
3 Replies
7. Shell Programming and Scripting
Hi there,
I was trying to add a line of text in the middle line of a file.
I have counted the lines in the file, and then I divide it into 2, after that I am stuck on how am I suppose to append the line on that file? When I tried to use this command 'second line >> filename' it appends it at... (3 Replies)
Discussion started by: felixwhoals
3 Replies
8. Shell Programming and Scripting
Hi All,
I have problem in the following shell script (problem in 2and3 line i guess)
#!/bin/sh
set value1 = 90;
set value2 = 70;
if ; then
echo "$value1 is normal"
else
echo "$value2 is abnormal"
fi
when executed
output:
$ value_test.sh (Enter)
is abnormal
Neither it's printing... (13 Replies)
Discussion started by: user__user3110
13 Replies
9. Shell Programming and Scripting
echo "what is your username?"
read username
echo $username
echo /home/$username
$backup="backup"
$restore="restore"
#
#
if
then
echo "No username provided"
else
echo "hi $username would you like to backup or restore?"
read userrequest
echo $userrequest
if
then
... (4 Replies)
Discussion started by: EwanD
4 Replies
10. Shell Programming and Scripting
I have an input file in this format (shown below). I have to select the lines which doesnt followed by 'miR-" and to save such lines into an output file. For easy identification they are shown here in blue color. They have to be selected. Pls. help me to write a shell script to select those lines... (5 Replies)
Discussion started by: hravisankar
5 Replies
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)