Re: SQL statement issue

[Peter Clark <PGCLARK@VAC-ACC.GC.CA>]

Hi Bruce,

>From the manual: "If a single paragraph contains more than one SQL statement, 
>each statement *except the last* must be terminated by a semicolon." (emphasis 
>mine)

This would seem to imply that your single line paragraph does not need a 
semicolon.

According the the last Cluster Departmental Technical Survey, you are an Oracle 
shop, so you could also get away with using a double semicolon ("For Oracle, 
PL/SQL is supported in a BEGIN-SQL paragraph. This requires an additional 
semicolon at the end of each PL/SQL statement.")
e.g.
BEGIN-SQL
  COMMIT; ;
END-SQL

HTH,
Peter

>>> "Weinstein, Bruce" <bweinste@NRCAN.GC.CA> 2001/04/04 11:20:06 am >>>
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