We help IT Professionals succeed at work.

Guide to DB2 SQL pl programming

sam_2012
sam_2012 asked
on
Hi ,

Iam new to Db2 , i have been asked to work on the development of stored procedures , functions in Db2 database 9.
Can any one share me the study material for DB2 SQL and PL programming.

Any help is really appreciated.
Comment
Watch Question

Data Warehouse / Database Architect
Commented:
HI Sam,

Are you familiar with Oracle, SQL Server, MySQL, or any other database engine?

If so, you'll find that DB2 SQL is very similar.  The biggest 3 differences are:

- Concatenation is with the double pipe (||) not plus (+) as SQL Server does.
- The SQL syntax for date handling is a lot friendlier in DB2.
- The UPDATE statement, particularly for complex (join) queries is not intuitive.

What version are you running?  Below is the link to the LUW version 9 online documentation. There are similar links for all of the versions.

  http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp


Good Luck!
Kent
Dave FordSoftware Developer / Database Administrator

Commented:
You don't state what "flavor" of DB2 you're using, but if you're using DB2 for i (a.k.a. AS/400 or iSeries), then this redbook is a good start:

http://www.redbooks.ibm.com/abstracts/sg246503.html

HTH,
DaveSlash

Author

Commented:
awesome .