| WA1333 DB2 SQL/PL Workshop |
|
This course is designed to review the SQL Procedure Language (SQL/PL) in DB2. SQL and SQL/PL statements will be used to create objects for application design and development. DB2 functions, triggers and stored procedures are objects which use SQL/PL and they will be created in workshop activities. |
|
| Objectives: |
|
After completing this course the student should be able to:
- Develop triggers, stored procedures and user defined functions
- Code SQL/PL statements
- Use the DB2 command tools
|
|
| Target Audience: |
|
DB2 programmers, users and data designers who are responsible for DB2 applications |
|
| Prerequisites |
|
- Relevant Operating Systems experience (AIX/UNIX/LINUX or Windows) along with knowledge of relational database theory and SQL.
- Previous experience of SQL with DB2 or a similar relational database is required.
|
|
| Duration |
|
One days. |
|
| Topics Outline |
|
- SQL Procedure Language
- Defining SQL Procedures
- SQL PL Statements
- COMPOUND Statement
- Declare statement
- Error Handling
- Assignment (SET) Statement
- CASE statement
- IF and GOTO statements
- LOOP, LEAVE and ITERATE Statements
- REPEAT and WHILE Statements
- FOR Statement
- GET DIAGNOSTICS Statement
- RETURN Statement
- SQL Procedure Examples
- Creating SQL PL Objects
- SQL stored Procedures
- Creating SQL Procedures
- Create SQL Procedure Steps
- Effects from CREATE
- SQL FUNCTIONS
- Triggers
|
|
