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]

Re: Documentation help SQL procedures DB2 v8 linux

"Robert Stearns" <rstearns1241@c harter.net> wrote in message
news:403E89EE.1 040909@charter. net...[color=blue]
> 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.
>[/color]
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/data/db2/udb/winos2unix/support/v8pubs.d2w/en_main

Scroll down to the manual you want.

[Eric Herber]

Re: Documentation help SQL procedures DB2 v8 linux

Robert Stearns wrote:
[color=blue]
> 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.[/color]

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/developerworks/db2/library/books/sqlplbook/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]

Re: Documentation help SQL procedures DB2 v8 linux

Eric Herber wrote:[color=blue]
> Robert Stearns wrote:
>
>[color=green]
>>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.[/color]
>
>
> 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[/color]

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.