Technology Driven IT Training Longstanding IT Technologists Computer Education Techniques
Distance-learning - DB2: Stored Procedures


distance-learning center

Application of Classic Teaching Models Mobile Classrooms

Professional Distance-learning

IT Training Services


DB2: Stored Procedures
DURATION: 3 days

FEE: $1,485

Based upon a class size of six students.

Scheduling can be adjusted to employee work hours and incorporate client assignments.

There is a surcharge associated with training two or fewer students.


  • Programmer
  • Database Administrator
  • System Analyst
  • System Designer
  • IT Professional


    1. IBM DB2 Stored Procedure Builder
      • Install and utilize the Procedure Builder.
      • Use DB2 Procedure Builder for creating new stored procedures with multiple arguments and parameters.
      • Use the SQL Assistant to specify a query for the stored procedure.
    2. SQL Procedures Language
      • Create a stored procedure using SQL/PL.
      • Write a simple stored procedure which receives values and returns resultsets.
      • Create a stored procedure for processing errors.
      • Write a stored procedure to rollback and transmit an error code to the calling program.
      • Receive values and return a resultset.
    3. Z/OS Workload Manager
      • Examine the concepts and features of the Workload Manager and perform a refresh.
      • Examine sample JCL.
      • Perform a refresh of the WLM.
    4. Z/OS Recoverable Resource Manager Service
      • Examine the concepts and facilities of the Recoverable Resource Manager Service.
      • Examine a recovery scenario.
    5. DB2 Stored Procedures and CICS
      • Create a stored procedure that is invoked from CICS.
      • Write a stored procedure which returns a resultset which is displayed in a map under CICS.
    6. Debugging Stored Procedures
      • Debug a stored procedure.
      • Execute a stored procedure.
      • Identify and resolve the issues and errors in stored procedures.
    Web-based Training   Blended Learning    
Value Added Service

Common Questions



Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID.

Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.

SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the SYS-ED course and that the employer has a licensed version of the software.