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



Tue, 10 Aug 2004 20:50:58 GMT
 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



Wed, 11 Aug 2004 00:05:47 GMT
 DB2 beginner quiestion regarding ';'
Can be configured in the Command Center (under TOOLS - Tools Settings) and in
the CLP with the option -t (db2 ? options).
Quote:

> 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



Wed, 11 Aug 2004 01:41:07 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Beginner's questions regarding Delphi

2. DB2 beginner question regarding commit/rollback

3. Performance regarding the 'IN' keyword

4. Can't getConnection() - beginner's error?

5. **************!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!Help me !!!!!!!!!!!!!!!!!!!!!!!!'''''''''''''''''''''''*************

6. DTS from 'DB2 on NT'

7. Using DB2's API's from JAVA

8. Equivalent of Oracle 'MONTHS_BETWEEN' in DB2

9. Idiot's Guide To Installing DB2 Personal Developer's Edition for Windows 2000

10. *** IDMS-DB2 CONVERSION DBA's - TESTERS - SYSTEM ADMIN's NEEDED ***

11. What is the DB2's analog of Oracle's PL/SQL

12. DB2 V7.1 questions about Jobs'launching and results'mailing


 
Powered by phpBB® Forum Software