06-22-2017
If you use OPTPARMS for passing the info, you need to use it in the case statement as well...
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I had a file with 150k records in it and I ran a tr on it to remove all new lines/CR which created one large record(whoops). Is there a way to add a \n after every 39th character without using 'dd' to turn it back into the original format?
dd is way to slow.
shell is ksh. (1 Reply)
Discussion started by: bthomas
1 Replies
2. Shell Programming and Scripting
hi,
I have a string "satabeltodounixscriptingpleasecheckfortheerros"
in the above line if it contains "unix" , i need to take 5 characters after that word.
please help
thanks in advance
Satya (2 Replies)
Discussion started by: Satyak
2 Replies
3. Shell Programming and Scripting
Hi,
how can I join given arguments (not starting from the first one) to form one string, each argument separated by a space. For example, out of 5 given arguments, I'll like to start joining from the 3rd to the last. In python there exists something like ' '.join(sys.argv) and it starts joining... (5 Replies)
Discussion started by: plhelpme
5 Replies
4. Shell Programming and Scripting
Please delete it (0 Replies)
Discussion started by: animesharma
0 Replies
5. Shell Programming and Scripting
Hi all, I have a requirement where I am taking the first argument as argument name and storing the second argument in argument name as value.
Thanks to ppl here, i learnt to do it.:p
while ( $1 != "" )
set arg = $1
shift
set val = "$1"
echo "set... (2 Replies)
Discussion started by: animesharma
2 Replies
6. Shell Programming and Scripting
I am passing a list of strings $list and want to remove all entries with --shift=number, --sort=number/number/..., --group=number/number/... Also are removed whether upper or lower case letters are used
For example the following will all be deleted from the list
--shift=12
--shift=2324... (7 Replies)
Discussion started by: kristinu
7 Replies
7. Programming
I have a makefile and want to allow passing -01 -02 -03 for the user to define
the level of optimization he wants. Doing this gets make to send an error.
make -03
make: invalid option -- '0'
make: invalid option -- '3'
Usage: make ... (5 Replies)
Discussion started by: kristinu
5 Replies
8. Shell Programming and Scripting
Hi All,
I am new to scripting. Could you please assist me .
Here is my requirement. I have written a script that has 2 option flags defined.
-l) calls some function with the arguments passed in front of -l
-r) calls second function with the arguments passed in front of -r
*) calls the... (7 Replies)
Discussion started by: Jay Deshpande
7 Replies
9. Shell Programming and Scripting
Hello Community!
Let's say that we have some script which counts its arguments number:
arguments_count.sh:
#!/bin/sh
echo "Number of arguments="$#and some test script:
test.sh:
#!/bin/sh
my_args="1 2 3 '4 5' 6"
echo "Count of arguments when using my_args:"
./arguments_count.sh $my_args... (12 Replies)
Discussion started by: break_da_funk
12 Replies
10. Shell Programming and Scripting
Hi. I have a piece of code that reads and parses command line options. I'd like to alter it slightly to read from a string (that's set elsewhere in the script) rather than directly from the command line (arg). Can somebody show me how to do this? Many thanks.
My code is as follows:
typeset... (6 Replies)
Discussion started by: user052009
6 Replies
LEARN ABOUT LINUX
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)