
DB2 beginner quiestion regarding ';'
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