RE: Multiple UPDATE statements in 1 file. How Do I do it?

Place a semi-colon between the statements. or did I miss something in the question? Cheers David -----Original Message----- From: John@not-valid-address.com [mailto:John@not-valid-address.com] Sent: Wednesday, February 07, 2001 9:16 AM To: informix-list@iiug.org Subject: Multiple UPDATE statements in 1 file. How Do I do it? I need to make a single file with multiple updates in it. The following update needs to be run a total of 72 times and in each instance the SET AREA and WHERE AREA parameters will be different. UPDATE gc_main SET area[1,2]="W1" WHERE area[3,4]="10" UPDATE gc_main SET area[1,2]="W2" WHERE area[3,4]="23" What is the syntax for running multiple updates? Thanks, John ************************************************************************This e-mail is intended for the use of the individual or entity named above and may contain information that is confidential and privileged. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify us immediately at helpdesk@lumley.com.au and destroy the original message. While this mail and any attachments have been scanned for common computer viruses and found to be virus free, we recommend you also perform your own virus checking processes before opening any attachments.