10-28-2009
thats perfect, thankyou .... I had to put a few curlies around the if statement to get it working but thank you very much for your help
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
How can I switch the port which SSH listens on? (1 Reply)
Discussion started by: Spetnik
1 Replies
2. AIX
I would like to implement the secure shell environment in order for me to close all telnet and ftp ports.
1) Anyone can assist to give me a steps of what to do so that I can implement the ssh on my AIX5.3 server.
2) Currently I have installed putty in my PC to replace telnet directly into the... (11 Replies)
Discussion started by: kwliew999
11 Replies
3. Shell Programming and Scripting
I have a file named Atoms that has a list of atoms listed vertically, like:
O
C
Na
etc. There is a variable number of them.
I want to count their occurences in another file. I want to do this by saving each atom as a variable, preferabbly in an associative array, then counting how... (3 Replies)
Discussion started by: RisingSun
3 Replies
4. Solaris
Good day to you all.
I have a server (running on SunOS 5.8) that i always got into via telnet. I have eventually decided to block telnet access to it and instead look toward using SSH. The problem is, whne i establish the SSH connection via PuTTy, i get the "Log in as" prompt, but upon... (5 Replies)
Discussion started by: de049
5 Replies
5. UNIX for Dummies Questions & Answers
Dear all,
I have a data sample...
Dose: Summed
ROI: Bladder
**************************
Bin Dose Volume
001 0.700 100.000
002 0.715 99.998
168 3.142 0.368
169 3.157 0.338
170 3.171 0.292
Dose: Summed
ROI:... (2 Replies)
Discussion started by: tintin72
2 Replies
6. Shell Programming and Scripting
flat file looks like
ooss-pfgg-1234,vol_name_1, mail-list
decoded =
hostname,volum_name,mail_list
each line has diff info
am trying to ssh into each fist field, check vol usage for second field, and if greater than 90% send mail to mail-list
got the second and third part working,
... (1 Reply)
Discussion started by: riegersteve
1 Replies
7. Shell Programming and Scripting
Hi,
I have a large flat file from host without delimiter. I'm transforming this file to a csv file using statements like
# Row 03: Customer / field position 3059 +20
WOFABNAM=substr( $0, 3059, 20 );
and deleting the trailing whitespaces before and after with that
sub( /^ +/, "",... (4 Replies)
Discussion started by: Celald
4 Replies
8. Shell Programming and Scripting
Hi all,
Hope someone can help me out here.
I have this BASH script (see below)
My problem lies with the variable path.
The output of the command find will give me several fields. The 9th field is the path. I want to captured that and the I want to filter this to a specific level.
The... (6 Replies)
Discussion started by: Cowardly
6 Replies
9. Shell Programming and Scripting
The following is part of a larger shell script
grep -v "Col1" my_test.log | grep -v "-" | awk '$5 == "Y" {print $1}'
instead of printing, can I set set $1 to a variable that the rest of the shell script can read?
if $5 == Y, I want to call another shell script and pass $1 as a... (2 Replies)
Discussion started by: guessingo
2 Replies
10. Shell Programming and Scripting
I have a data file d0 that looks like this:
$cat d0
server1 running -n-cv- 8G 3.1% 1435d 15h
server2 running -n---- 8G 39% 660d 22h
server3 running -n--v- 8G 2.5% 1173d 6h
server4 running -n---- 8G 1.1% 1048d 20h... (2 Replies)
Discussion started by: jake0391S
2 Replies
LEARN ABOUT DEBIAN
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)