Documentation help SQL procedures DB2 v8 linux

[Robert Stearns]

Where in the documentation can I find a syntax summary of the language
supported by SQL procedures? I have found documentation of several
statement types, but I have no idea whether that is the whole language
or not.

[Mark A]

"Robert Stearns" <rs**********@charter.net> wrote in message
news:40**************@charter.net...

Where in the documentation can I find a syntax summary of the language
supported by SQL procedures? I have found documentation of several
statement types, but I have no idea whether that is the whole language
or not.

I would look at the SQL Reference vol 1 and 2 (especially the control
statements) and the Application Development Guide: Programming Server
Applications. All manuals can be downloaded in PDF format from:

http://www-3.ibm.com/cgi-bin/db2www/...bs.d2w/en_main

Scroll down to the manual you want.

[Eric Herber]

Robert Stearns wrote:

Where in the documentation can I find a syntax summary of the language
supported by SQL procedures? I have found documentation of several
statement types, but I have no idea whether that is the whole language
or not.

Beside the manuals that Mark already mentioned I would
recommend to buy the following book 'DB2 SQL Procedural
Language for Linux, UNIX, and Windows':

http://www-106.ibm.com/developerwork...ook/index.html

The DB2 manuals are not very well structured and you might
have problems finding the necessary information for writing
SQL stored procedures.

This book is a really good overview about SQL stored procedures
and is worth the money.

HTH.

Best regards

Eric
--
IT-Consulting Herber
***********************************************
Download the IFMX Database-Monitor for free at:
http://www.herber-consulting.de/BusyBee
***********************************************

[Robert Stearns]

Eric Herber wrote:

Robert Stearns wrote:

Where in the documentation can I find a syntax summary of the language
supported by SQL procedures? I have found documentation of several
statement types, but I have no idea whether that is the whole language
or not.

Beside the manuals that Mark already mentioned I would
recommend to buy the following book 'DB2 SQL Procedural
Language for Linux, UNIX, and Windows':

http://www-106.ibm.com/developerwork...ook/index.html

The DB2 manuals are not very well structured and you might
have problems finding the necessary information for writing
SQL stored procedures.

This book is a really good overview about SQL stored procedures
and is worth the money.

HTH.

Best regards

Eric

Thank you both very much. The online documentation is very good (but
then I think k&r 1st is sufficient [or maybe a little too verbose] to
completely describe C and its standard libraries). Unfortunately I only
have one monitor at home, so I'll probably but the book.