05-19-2010
I'm to hedge and say you've only resolved an immediate concern...you might not have resolved your real concern. You never responded on the 'huge data' question, so I'm guessing you might still see the issue in another spot. In fact, your sample if..then statement appears to be a mock-up instead of a real-life condition. What is it you're trying to accomplish? Are you trying to capture SQL return codes or something...?
You're only going to see a variable work if you've piped something into it; $? is the same concept, but on the shell's level instead of the process. Whatever allows you to redirect into tempfile.txt should also allow you to simply pipe this same result into your egrep statement, and thereby get $return to match your goal.
HTH
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I'm writing a small script thats purpose is to validate a single command line argument to make sure it is an integer. Also acceptable are a leading "+" or "-", but no more than one.
Example: "5" "-2" "+4" are all valid
If its invalid I simply print out a message saying so, otherwise I... (2 Replies)
Discussion started by: FuzzyNips
2 Replies
2. UNIX for Dummies Questions & Answers
Hi I've been searching google and have not found what egrep -c means. Does anyone know where I can get a cheat sheet or what that -c means?
thanks,
Linda (2 Replies)
Discussion started by: leelm
2 Replies
3. Shell Programming and Scripting
Hi,
I don't understand what is the correct way of writing:
egrep -l '{$min,$max} $pattern' $filename
I tryed to search on google how to wtrite {$min, $max}, but I don't have success (7 Replies)
Discussion started by: DNAx86
7 Replies
4. UNIX for Dummies Questions & Answers
what does "egrep """ do ?? Can anyone explain this with an example .. please .. (2 Replies)
Discussion started by: risshanth
2 Replies
5. UNIX for Dummies Questions & Answers
Hi Guys,
we have a shell script which basically query the Database which retrieves huge data and use the data with "egrep" .
Now there is some data which contains characters like "abc)" and the same is used like below :
"egrep (.+\|GDPRAB16\|GDPR/11702 96 abc)\|$ temp.txt"
now while... (7 Replies)
Discussion started by: sagarjani
7 Replies
6. UNIX for Dummies Questions & Answers
HI,
I have two files filea, fileeb
filea
z283110z67
xx65686377
xx654681zz
xx652836xx
xx653881zz
xx65480z11
xx654z5466
xx65510000
xx65670000
xx656z0000
xx656z1822
fileb (3 Replies)
Discussion started by: krao
3 Replies
7. Shell Programming and Scripting
My data is something like shown below.
date1 date2 aaa bbbb ccccc
date3 date4 dddd eeeeeee ffffffffff ggggg hh
I want the output like this
date1date2 aaa eeeeee
I serached in the forum but didn't find the exact matching solution. Please help. (7 Replies)
Discussion started by: rdhanek
7 Replies
8. Shell Programming and Scripting
i am new to bash or scripting period and had a question about how I could use the egrep command (or if there should be another command to use) to accomplish the following goal. Need to look through the ndm files labeled as S20090709.999 and if I cannot find a specific date then search the archived... (5 Replies)
Discussion started by: freddie999
5 Replies
9. Shell Programming and Scripting
Hi All,
Can some one please help me how to grep the comments from "oracle" & "sybase" code. I would like to grep below type of pattern.
--
/* */
Please help. (6 Replies)
Discussion started by: gr8_usk
6 Replies
10. Shell Programming and Scripting
Hi
I am trying to run CMD that combining EGREP and PERL in multiple files
cat *07:00.22-12-13.txt | egrep" NAME| perl -ne 'print if /^sid9/ .. /^!/' "
I need the see the NAME and the text from sid9 to !
how can I use the EGERP in parallel to the PERL ?
This is one file
Qqq... (2 Replies)
Discussion started by: sharong
2 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)