The Case statement will already verify if the parameter is valid or not - whether the parameter is int or char. If the parameter is composed of characters, then the Case statement will select the (*) in its options.
If you really want to check the parameter if it's composed of numbers or characters, then use a regular expression.
Last edited by Franklin52; 04-01-2011 at 06:13 AM..
Reason: Please use code tags, thank you
I am using ksh on a HP Ux. I have a simple script but am having problem with the case statement:-
#!/usr/bin/sh
Chl=”SM.APPLE_SWIFT_DV”
LoConfirm=””
case $chl in
)
LoConfirm=”Using channel at Building 1”
echo “test conditon1”
echo $LoConfirm;;
)
LoConfirm=”Using... (2 Replies)
I have a file abc.sh which looks like
qacc1 ----> down
v5c0
check interface v5c1
I want to read this file line by line and perform a certain action if a particular pattern is found in that line. My code so far looks like this:
FileName='abc.sh'
while read LINE
do
echo $LINE
case... (2 Replies)
Hello Experts,
I need to create a case structure, wherein I must chk the input to match 2 values: PSDEV and PSSIT. I would like to do this using a single pattern.
I ve tried:
case
PS)
echo "here"
;;
*)
echo "there"
;;
esac
Idk exactly how... (5 Replies)
Using UNIX tools, but not using GAWK (NAWK is OK), is there a more elegant way to achieve this:
sed '
s/_a/_A/1
s/_b/_B/1
s/_c/_C/1
rest of alpahabet
'
I want to change the case of a single character in each string of a text file. The character will be matched by regex '_' and only... (2 Replies)
HI,
My file contains data something like
034500,5,B5004946544EB185,DEFAULT,0
Now i want to do a pettern match for DEFAULT and remove that particular line from file and transfer the rest contents to temp file.But my req is i want to do case insensitive matching ie DEFAULT / default.
I... (4 Replies)
Hi ,
I have the file where i have to search for the pattern. The pattern may be lower case or upper case or camel case. Basically I want to ignore while searching the pattern in awk.
awk '/error|warning/exception/' filename
Please help me (3 Replies)
We have a configuration file in Unix. In that we have entries like below. if it ends with ":", then it is the end of record. We need to find our if there is any duplicate entries like ABCD irrespective of the case.
ABCD:\
:conn.retry.stwait=00.00.30:\
:sess.pnode.max=255:\
... (9 Replies)
Hi Gurus,
I am trying to convert some lines in a file based on the patter.Below is an example. Text after cn= and uid: should be converted to lower case.
Input:
dn: cn=XXX,ou=111,dc=222,dc=333,dc=444
uid: XXX
userPassword:: aAbVCeDr
dn: cn=XYZ,ou=111,dc=222,dc=333,dc=444
uid: XYZ... (5 Replies)
Hi
I need to do a patten match between files .
I am new to shell scripting and have come up with this so far. It take 50 seconds to process files of 2mb size . I need to tune this code as file size will be around 50mb and need to save time.
Main issue is that I need to search the pattern from... (2 Replies)
i would like to search a variable for a pattern, without having make any calls to external tools.
i have a code like this:
COUNTPRO2="gine is very bad
vine is pretty good"
case "${COUNTPRO2}" in
*vine*)
factor=${COUNTPRO2}
echo $factor
;;
esac
If the variable contains... (7 Replies)
Discussion started by: SkySmart
7 Replies
LEARN ABOUT MOJAVE
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)