Help fixing my database script Post: 302867197

Sponsored Content

Homework and Emergencies Homework & Coursework Questions Help fixing my database script Post 302867197 by Don Cragun on Wednesday 23rd of October 2013 04:01:36 PM

10-23-2013

Registered User

In addition to what RudiC said, comments can't be used as selections in a case statement.

Your 1st if statement syntax looks OK (except that the if in the then clause is missing both then and fi. All of your other if statements are also missing required bits of the grammar of if statements.

In addition to what Corona688 said, saying that you're getting syntax errors and showing us those syntax errors are two VERY different things. If you want our help, you are much more likely to get it if you help us help you. Show us exactly the diagnostic messages you're getting instead of leaving it to our imaginations.

Since there are so many syntax errors in this relatively short script; try just putting an if statement (and the variable assignments needed to make it work) in a file and debug that script until you figure out how if statements work. Then do the same thing with a case statement. For both if and case statements, print the bash man page on your system and look closely at the syntax for if statements and for case statements. If you have trouble figuring out how to make if statements work or how to make case statements work, we'll be glad to help; but don't expect us to do your homework for you.

Don Cragun

View Public Profile for Don Cragun

Find all posts by Don Cragun

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell Script: want to insert values in database when update script runs

Hi , I am new to linux and also also to shell scripting. I have one shell script which unpacks .tgz file and install software on machine. When this script runs I want to insert id,filename,description(which will be in readme file),log(which will be in log file) and name of unpacked folder...

2. Linux

fixing with sed

I am trying to replace the value of $f3 but its not working . I don't know what I am missing here . cat dim_copy.20080516.sql | grep -i "create view" | grep -v OPSDM002 | while read f1 f2 f3 f4 f5 f6 f7 f8 f9 do echo " $f3 " sed -e...

3. Shell Programming and Scripting

Fixing corrupted vcard files.

KDE's Kontact PIM breaks quoted-printable vcard files because it linebreaks in the middle of a word. Take this text for example: NOTE;CHARSET=UTF-8;ENCODING=QUOTED-PRINTABLE:=D7=A9=D7=95=D7=A8=D7=94 =D7=A 8=D7=90=D7=A9=D7=95=D7=A0=D7=94.\n=D7=94=D7=A9=D7=95=D7=A8=D7=94 =D7=94=D7= ...

4. Shell Programming and Scripting

Fixing the width of a word

Is there a way to fix the width of the word being printed to a file? I am trying to create an output to a file with columns , like a spread sheet. I have used "\t" to adjust the columns but still it does not show well in the file, mainly due to the variable length values in the column so \t does...

5. Shell Programming and Scripting

help fixing awk statement

awk "BEGIN {if($MessageREAD<$ThresholdW) {print \"OK\" ; exit 0} else if(($MessageREAD>=$ThresholdW) && ($MessageREAD<$ThresholdC)) {print \"WARNING\" ; exit 1}" else if($MessageREAD<=$ThresholdC) {print \"CRITICAL\" ;...

6. AIX

Fixing security problem

Hi I use Rapid 7 to check some servers ( AIX 5.3 ) for security problems. There are 2 problems I don't know to deal with 1. Problem : TCP Sequence Number Approximation Vulnerability Solution : _Enable TCP MD5 Signature 2. Problem : HTTP Basic Authentication Enable Solution : _ Use...

7. Shell Programming and Scripting

Fixing a shell script

I have this shell script that I wrote to check an input file to see if it is empty or not, and then clean the file from any line that starts with the sign "<" (without quotation marks" and then spell the number of line of the file, and the empty lines, too. The script then will create two output...

8. UNIX for Advanced & Expert Users

Help with fixing screen position

Hey guys, I am trying to make print a pattern with * on a 10*10 two dimensional array in a for loop and I want the incoming 10*10 to overlap the previous 10*10 so that the * look like it is moving. is there a way to fix the screen position? ever time it prints a 10*10 the screen moves. ...

9. Shell Programming and Scripting

Help fixing awk code

can someone please help me spot and fix the issue with the following code: awk -F, -v SEARCHPATT="(Wed|Tue)" -v ADDISTR="Mon|Tue|Wed|Thu|Fri|Sat|Sun" -vVF="$VALFOUND" "BEGIN{ {D = D = 1 D = D = 2 } $0 ~ "," VF "," {L = 1 ...

LEARN ABOUT DEBIAN

defncopy

defncopy(1)							 FreeTDS Utilities						       defncopy(1)

NAME

       defncopy - extract procedures and views from a Microsoft server.

SYNOPSIS

       defncopy [-U username] [-P password] [-S server] [-D database]
	      [-i input_file] [-o output_file] [-v]
	     [owner.]object_name [[owner.]object_name...]

DESCRIPTION

       defncopy is a utility program distributed with FreeTDS. It replaces a similar program of the same name distributed by Sybase.

       defncopy  reads	the  text of a stored procedure or view, and writes a script suitable for recreating the procedure or view. For tables, it
       reads the output of sp_help and constructs a CREATE TABLE statement, complete with CREATE INDEX, too.

OBJECTS

       owner  is optional if you or the database owner is the owner of the procedure/view being copied.

       object_name
	      is the name of the system object you wish to extract.

OPTIONS

       -U username
	      database server login name.

       -P password
	      database server password.

       -S server
	      database server to which to connect.

       -D database
	      database to use. Optional if the procedure/view being extracted is in your default database.

       -i input_file
	      a script to apply to the database. Not currently implemented.

       -o output_file
	      a file to hold the script, defaults to standard output.

       -v     Show version information and copyright notice.

NOTES

       defncopy is a filter; it reads from standard input, writes to standard output, and writes errors to standard error. The -i and  -o  options
       override these, of course.

       defncopy makes use of the db-lib API provided by FreeTDS. This API is of course also available to application developers.

EXIT STATUS

       defncopy exits 0 on success, and >0 if the server cannot process the query.

       defncopy will report any errors returned by the server, but will continue processing.

HISTORY

       defncopy first appeared in FreeTDS 0.63.

AUTHORS

       The defncopy utility was written by James K. Lowden <jklowden@schemamania.org>

BUGS

       Works only with Microsoft servers and ancient Sybase servers.

       Does not create primary keys.

       Many options are defined by Sybase that this version does not implement. Feel free to correct this situation.

       In theory, defncopy could apply/produce DDL for any system object, but at present only tables, procedures and views are supported, and only
       for extraction.

doc								 13 November 2011						       defncopy(1)