case statements Post: 302079093

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

lower case to upper case string conversion in shell script

How can convert a Lower case variable value to an upper case in the kron shell script.

2. Shell Programming and Scripting

Script needed to select and delete lower case and mixed case records

HELLO ALL, URGENTLY NEEDED A SCRIPT TO SELECT AND DELETE LOWER AND MIXED CASE RECORDS FROM A COLUMN IN A TABLE. FOR EXAMPLE : Table name is EMPLOYEE and the column name is CITY and the CITY column records will be: Newyork washington ...

3. Shell Programming and Scripting

Problem with my case statements

Hi there, Im having some problems with this function, I pass two arguments to the function $1 $2 (Arguments are month and date inputted by the user) for some reason the case always fails... however in the cases defined below where it shouldnt fail the result is: if it fails with input...

4. UNIX for Dummies Questions & Answers

How to combine case statements

Hi, I need to change military time to regular time. I know to use case to indicate whether a.m. or p.m. as follows: case "$hour" in 0? | 1 ) echo a.m.;; 1 ) echo p.m.;; * ) echo p.m.;; esac My question is how do I add the hour and minute...

5. Shell Programming and Scripting

Not able to exit from case statements

Hi all, I wrote the following simple shell script to perform addition, subtraction, multiplication and division. In the below program, i am not able to exit from the script Shell Script ----------- #!/bin/sh bgcal() { cal="" echo "Enter the Option Number: \c" read cal if then...

6. Shell Programming and Scripting

sed ignoring case for search but respecting case for subtitute

Hi I want to make string substitution ignoring case for search but respecting case for subtitute. Ex changing all occurences of "original" in a file to "substitute": original becomes substitute Origninal becomes Substitute ORIGINAL becomes SUBSTITUTE I know this a little special but it's not...

7. Homework & Coursework Questions

Case statements and creating a file database

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: The assignment is posted below: Maintain automobile records in a database Write a shell script to create,...

8. Shell Programming and Scripting

Convert to case statements from if/elif

Hello, I wrote the case on code but it mistakes. I am not sure. If/elif code: #!/bin/ksh you=$LOGNAME hour=`date | awk '{print substr($4, 1, 2)}'` print "The time is: $(date)" if (( hour > 0 && $hour < 12 )) then print "Good morning, $you!" elif (( hour == 12 )) then

9. Shell Programming and Scripting

Searching for pattern in variable using case statements

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...

LEARN ABOUT SUSE

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)