Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Unmatched 'then'
Top Forums UNIX for Dummies Questions & Answers Unmatched 'then' Post 6410 by Optimus_P on Tuesday 4th of September 2001 05:45:29 PM
Old 09-04-2001
Quote:
Originally posted by akpopa
Smilie Smilie Smilie Smilie

Now I am getting the 'then' unmatched again.

Here is exactly what the statement looks like:

if [ "$all_recs" = "NEW" ]
then

# Flush the staging table
echo "=== Cleaning the staging table..."
sqlplus -s $connect_string > /dev/null << EOF
begin
iws_clean_staging_pkg.iws_clean_staging_prc;
end;
/
EOF
fi;
Code:
#! /bin/ksh
all_recs=&ltenter your patern here&gt
connect_string=&ltenter your patern here&gt

if [[ $all_recs -eq "NEW" ]]; then

# Flush the staging table
echo "=== Cleaning the staging table..."
sqlplus -s $connect_string > /dev/null << EOF
begin
iws_clean_staging_pkg.iws_clean_staging_prc
end
EOF

fi

this is the way i would write it. i dont know why u had ";" after staging_prc or end and a continue to next line where EOF was. my suggestion one to many ";" not enuff "[]"; invalid if compairson operator.

also you can man test for more info. I would suggest that you get a copy of Learning the Korn Shell by oreilly as a great start to ksh shell scripting and for genearl knowledge about ksh. makes a great referance book.
Last edited by Optimus_P; 09-04-2001 at 11:17 PM..
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to subtract 2 hours from 'date' in shell ( /bin/sh ) script ?

I write a sh script that zip and copy to tape all files that older then 2 hours. 1. The way I choose is - touch a file with "now - 2 hours", then use fine with '! -newer' 2. Do you have any other idea to do it ? tnx. (1 Reply)
Discussion started by: yairon
1 Replies

2. Programming

i can't use 'make' in my computer?

I need to compile a file,but 'make' does not work.please tell me how to use it or need which tools? (3 Replies)
Discussion started by: dsun5
3 Replies

3. Shell Programming and Scripting

Clearify what it means under 'WHAT' when hit the 'w'-command

I wonder how I shall read the result below, especially 'what' shown below. The result was shown when I entered 'w'. E.g what is TOP? What is gosh ( what does selmgr mean?)? login@ idle JCPU PCPU what 6:15am 7:04 39 39 TOP 6:34am 6:45 45 45 TOP 6:41am ... (1 Reply)
Discussion started by: Aelgen
1 Replies

4. UNIX for Advanced & Expert Users

Terminal 'Local Echo' lost on Modem Dial-out

Can anybody help me? I am developing a utility for automating message paging to a BT alphanumeric pager. I am using a USR 56K Fax-modem connected to /dev/cuab on a Sun Ultra-10. I am using the UNIX 'tip' utility to connect to the modem and I have configured the modem as follows: Baud Rate:... (2 Replies)
Discussion started by: mybeat
2 Replies

5. Filesystems, Disks and Memory

HELP! The '/var/adm/message' file increase every few seconds???

Hi, guys, I have a big problem. I've got a sun solaris 4.1.4 workstation, and the /var/adm/message file will add one row every few seconds. It soon becomes a large file. I wander if there are some mistakes configuring the workstation. the /var/adm/message is as follow: ... (1 Reply)
Discussion started by: cloudsmell
1 Replies

6. UNIX for Dummies Questions & Answers

quoting echo 'it's friday'

echo 'it's friday' why appear the > (3 Replies)
Discussion started by: yls177
3 Replies

7. IP Networking

BELKIN 'F5D5020' 16bit PCMCIA - FreeBSD HOWTO

Hey all, I've bought a few bits from Belkin who seem quite happy to support FreeBSD! Last time I bought a UPS from them and it's still going well :D I saw this on their website that the 16bit PCMCIA card was supported under FreeBSD: http://www.belkin.com/network/F5D5020.html I went to my... (0 Replies)
Discussion started by: WIntellect
0 Replies

8. Email Antispam Techniques and Email Filtering

Procmail recipe: blocking 'unsubscribe and opt-out' messages....

Here is a crude procmail recipe that I quickly created (NOT a procmail recipe expert, btw) that has been catching lots of spam (current second after the charset_spam recipe posted earlier): :0B * .*If.you.do.not.wish.to.receive...* more_spam :0B * You.requested.to.receive.this.mailing... (0 Replies)
Discussion started by: Neo
0 Replies

9. UNIX for Advanced & Expert Users

How to remove a file with a leading dash '-' in it's name?

Somehow someone created a file named '-ov' in the root directory. Given the name, the how was probably the result of some cpio command they bozo'ed. I've tried a number of different ways to get rid of it using * and ? wildcards, '\' escape patterns etc.. They all fail with " illegal option --... (3 Replies)
Discussion started by: GSalisbury
3 Replies

10. Shell Programming and Scripting

What are the differences between 'bash' and 'sh'

Hopefully this doesn't come off as too much of a "newbie" question or a flamebait. But I have recently begun working with a Sun Solaris box after having spent the past five years working with RedHat. From what i can tell, thing look fairly similar and the 'man' command is some help. But I've... (7 Replies)
Discussion started by: deckard
7 Replies

LEARN ABOUT LINUX

ndb_drop_table

NDB_DROP_TABLE(1)					       MySQL Database System						 NDB_DROP_TABLE(1)

NAME

       ndb_drop_table - drop an NDB table

SYNOPSIS

       ndb_drop_table options

DESCRIPTION

       ndb_drop_table drops the specified NDB table. (If you try to use this on a table created with a storage engine other than NDB, the attempt
       fails with the error 723: No such table exists.) This operation is extremely fast; in some cases, it can be an order of magnitude faster
       than using a MySQL DROP TABLE statement on an NDB table.
	       Usage

	   ndb_drop_table -c connect_string tbl_name -d db_name

       The following table includes options that are specific to ndb_drop_table. Additional descriptions follow the table. For options common to
       most MySQL Cluster programs (including ndb_drop_table), see Options Common to MySQL Cluster Programs(1).

       Table 17.19. ndb_drop_table Options and Variables: MySQL Cluster NDB 7.2
       +--------------------------+-----------------------------------+-------------------------------------+
       |Format			  | Description 		      | Added / Removed 		    |
       +--------------------------+-----------------------------------+-------------------------------------+
       |			  | Name of the database in which the | 				    |
       |       --database=dbname, | table is found		      |        All MySQL 5.5 based releases |
       |			  |				      | 				    |
       |       -d		  |				      | 				    |
       +--------------------------+-----------------------------------+-------------------------------------+

COPYRIGHT

       Copyright (C) 1997, 2014, Oracle and/or its affiliates. All rights reserved.

       This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
       published by the Free Software Foundation; version 2 of the License.

       This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
       MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

       You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
       Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.

SEE ALSO

       For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
       at http://dev.mysql.com/doc/.

AUTHOR

       Oracle Corporation (http://dev.mysql.com/).

MySQL 5.5							    01/30/2014							 NDB_DROP_TABLE(1)
All times are GMT -4. The time now is 01:36 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy