Hi

I see a lot of you use ';' to end you SQL statements. When I do this I get
an error [SQL0104N]. From my days working with Oracle I remember getting an
error if I didn't enter a semicolon so is it correct to leave out the
semicolon or can this be configured?

regards
Lee Francis

Hi Lee,

This is configurable.

For the commandline you can use

db2 (no semicolon)
db2 -t (semicolon)
db2 -td<characater> (use <character> as delimiter)
The -td option is used when doing SQL PL (CREATE PROCEDURE< FUCNTION, TRIGGER,
dynamic compound) since the SQL standard requires ';' to separate statements
within a compound

For the script or command center pick the delimiter in tools->settings.

Cheers
Serge
--
Serge Rielau
DB2 UDB SQL Compiler Development
IBM Software Lab, Canada

Can be configured in the Command Center (under TOOLS - Tools Settings) and in
the CLP with the option -t (db2 ? options).