08-25-2011
The value stored in $? at the time of the if-statement's test is the exit status of the echo statement. You need to store $? in another variable, so that you can print it and then test it.
Regards,
Alister
This User Gave Thanks to alister For This Post:
8 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I recently checked the output from one of my backup tapes
# tar -tvf /dev/rmt0
tar: directory checksum error (6 != 24439)
The files wont restore , what does this mean ? on aix.
Thanks (3 Replies)
Discussion started by: cubicle^dweller
3 Replies
2. Shell Programming and Scripting
How would I go about an error check within a script. For example, if I have a script that I know might contain an error with a certain command, is there a way to give an alternate command if the first fails?
The best way I can explain it, is from the Mac world, using Applescript. With AS, I can... (1 Reply)
Discussion started by: TheCrunge
1 Replies
3. Shell Programming and Scripting
I have below script to check the word in the driectory /ora_tmp , there are many files in this directory , if the word "error" is exist in any file within 5 day , then send the mail to ora-usr@mydomain.com about which file have this word and the "error" statement , now , if I want
1. if there... (2 Replies)
Discussion started by: ust
2 Replies
4. Shell Programming and Scripting
If I have a script createdb.sh
...
psql -U postgres -c "create database dbname"
...
I want to write something like
if IsErr(psql -U postgres -c "create database dbname")
ehco "OK"
else
ehco "NOT OK"
Thank for any reply first (3 Replies)
Discussion started by: uativan
3 Replies
5. Shell Programming and Scripting
Hi,
Is there any way to check the error in heredoc?
Code:
/export/opt/SCssh/3.7.1_C0/bin/sftp -B - csi@192.168.1.100 <<FTP
lcd /WEBSERVER_LINK/data_logs/
ls pub/csidata/GeneralAppFields_8_1_Feed.out
get pub/csidata/GeneralAppFields_8_1_Feed.out
quit
FTP
Now I want to check... (1 Reply)
Discussion started by: bheeshmaraja
1 Replies
6. Shell Programming and Scripting
How can I add a check right after the FTP to see if the login id failed or not and echo an error description indicating login failed?
Here is my script:
ftp $HOST1 <<END_SCRIPT>>$TARGETLOGS/$LOGFILE
#ftp $HOST1 <<END_SCRIPT>
cd idx
prompt
mget $PICKUPFILE*.txt
!cp $PICKUPFILE*... (17 Replies)
Discussion started by: mrn6430
17 Replies
7. UNIX for Dummies Questions & Answers
i have several lv (data , data1 , data2) under same volume group,
i just want to test 1 lv for data errors is that possible?
this test all sdc disk , but i just want to test lv_data
smartctl -a /dev/sdc
because lv_data2 is corrupt , but i don't know if this lv uses sdc disk (1 Reply)
Discussion started by: prpkrk
1 Replies
8. Shell Programming and Scripting
I have a script is as below , if the output of the script is 0 , then echo abc .
script1
if ]; then
echo abc
fi
Can advise if I would like to change it , check the output , if the output only have the wold "0" , then echo abc , if the output have other word , then do nothing , can... (3 Replies)
Discussion started by: ust3
3 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)