• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 304
  • Last Modified:

Guide to DB2 SQL pl programming

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.
1 Solution
Kent OlsenData Warehouse Architect / DBACommented:
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.


Good Luck!
Dave FordSoftware Developer / Database AdministratorCommented:
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:


sam_2012Author Commented:
awesome .
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now