Case statements and creating a file database Post: 302515129

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

creating a script using the case conditional

hello, i am a newbie who is just starting to use liunx, and I need to accept a string from the terminal and use case to echo a suitable message if the string doesn't have at least 10 characters. Also, how would I do the same thing using expr?

2. Shell Programming and Scripting

case statements

i need to use a case statement to do something when the user enters nothing at the prompt. i know about the if statement and that isnt' what i'm interested in using for this. i want to use case. heres the scenerio. a program asks a user for an input. i want to use a case statement to...

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

Creating a dynamic case statement

I'm using the korn shell and trying to create a case statement from the contents of a file that is changed regularly, each line of the file has three fields, eg track1 202.111.111.111 99 room7 222.111.222.333 76 I'm using awk to select each variable. I've been unable to figure out how to...

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

7. Shell Programming and Scripting

Parse through ~21,000 Database DDL statements -- Fastest way to perform search, replace and insert

Hello All: We are looking to search through 2000 files with around 21,000 statements where we have to search, replace and insert a pattern based on the following: 1) Parse through the file and check for CREATE MULTISET TABLE or CREATE SET TABLE statements.....and they always end with ON...

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

10. UNIX for Beginners Questions & Answers

Creating script to read many files and load into database via single control file

Hi, I have many files but with only 2 names , I want to load the data of that file into database through sqlldr with single control file. how can i do that ????? Example: switch_file switch_file billing_file billing_file now these files should be loaded into same database but different...

LEARN ABOUT SUSE

drop_text_search_template

DROP TEXT SEARCH 
TEMPLATE(7)					   SQL Commands 				      DROP TEXT SEARCH TEMPLATE(7)

NAME

       DROP TEXT SEARCH TEMPLATE - remove a text search template

SYNOPSIS

       DROP TEXT SEARCH TEMPLATE [ IF EXISTS ] name [ CASCADE | RESTRICT ]

DESCRIPTION

       DROP TEXT SEARCH TEMPLATE drops an existing text search template. You must be a superuser to use this command.

PARAMETERS

       IF EXISTS
	      Do not throw an error if the text search template does not exist.  A notice is issued in this case.

       name   The name (optionally schema-qualified) of an existing text search template.

       CASCADE
	      Automatically drop objects that depend on the text search template.

       RESTRICT
	      Refuse to drop the text search template if any objects depend on it.  This is the default.

EXAMPLES

       Remove the text search template thesaurus:

       DROP TEXT SEARCH TEMPLATE thesaurus;

       This command will not succeed if there are any existing text search dictionaries that use the template. Add CASCADE to drop such dictionar-
       ies along with the template.

COMPATIBILITY

       There is no DROP TEXT SEARCH TEMPLATE statement in the SQL standard.

SEE ALSO

       ALTER TEXT SEARCH TEMPLATE [alter_text_search_template(7)], CREATE TEXT SEARCH TEMPLATE [create_text_search_template(7)]

SQL - Language Statements					    2010-05-14					      DROP TEXT SEARCH TEMPLATE(7)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

creating a script using the case conditional

Discussion started by: soccerstr1

2. Shell Programming and Scripting

case statements

Discussion started by: Terrible

3. Shell Programming and Scripting

Problem with my case statements

Discussion started by: Darklight

4. UNIX for Dummies Questions & Answers

How to combine case statements

Discussion started by: karp3158