PRIVATE GROUP FEE:
$ Based upon a class size of six students.
Scheduling can be adjusted to employee work hours and incorporate client assignments.
SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.
CONTENT AND OBJECTIVES:
Examine the features and options for running Db2 stored procedures.
Outline the flow of data between the client and the stored procedure.
Examine the environments and clients that are used with Db2 stored procedures.
Examine WLM environments and the nesting of stored procedures.
Db Stored Procedures
Examine Db2 systems and other Db2 components that utilize stored procedures.
Acquire familiarity with Java stored procedures and their advantages.
Interfaces to Application Development
Utilize program procedures and recognize the issues associated when interfacing with the operating system and other programs.
Code stored procedures using FENCED or NOT FENCED and THREADSAFE or NOT THREADSAFE.
Coding Stored Procedures
Acquire proficiency in repairing stored procedures.
Handle common errors that will be encountered in the life cycle when developing or executing a stored procedure.
Code stored procedures to facilitate maintenance, error control, and reporting.
Coding Client Applications
Code a client program for testing a stored procedure.
Code a stored procedure and the client program for invoking the stored procedure.
Transferring Multiple Resultsets
Code a stored procedure for generating multiple resultsets.
Code and test a stored procedure that creates two resultsets from two different tables.
Acquire proficiency with the features and options associated with enhancing the performance of stored procedures.
Use performance monitoring tools.
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.