[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: SQL statement issue
- Subject: Re: SQL statement issue
- From: David Donnelly <Dave@ISISBIO.COM>
- Date: Wed, 4 Apr 2001 10:33:10 -0700
- In-Reply-To: <7C5BAA47EC04D51181AD0000C110C4B04627AD@S0-OTT-X13.css.NRCa n.gc.ca>
In some earlier versions of SQR (I don't remember how early, maybe v3), under
Oracle,
using the COMMIT command within BEGIN-SQL would blow up. You had to use the
separate SQR COMMIT command outside BEGIN-SQL. If you are having a problem
with commit within begin-sql, try SQR command instead.
At 10:20 AM 4/4/2001 -0400, you wrote:
>Can anyone tell me if it is OK to end a SQL statement with a ;(semi-colon).
>
>We have following code...
>
>BEGIN-SQL
> COMMIT;
>END-SQL
>
>Is this OK to do in SQR?
>
>Thanks..
>
> .Bruce
>
>Bruce Weinstein
>E-Mail: bruceweinstein@canada.com
Dave Donnelly <dave@isisbio.com>
ISIS BioComp phone (909) 677-2446 fax (781) 207-5533