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.
AUDIENCE:
Programmer
Database Administrator
System Analyst
System Designer
IT Professional
DATES:
CONTENT AND OBJECTIVES:
Stored Procedure Featureset
Identify the performance advantages of using stored procedures.
IBM Db2 Data Studio
Install and utilize the Data Studio.
Use Db2 Data Studio for creating new stored procedures with multiple arguments and parameters.
Use the Data Studio to specify a query for the stored procedure.
Programming Environment
List the privileges associated with a stored procedure.
Developing Stored Procedures
Debug a stored procedure.
Execute a stored procedure.
Identify and resolve the issues and errors in stored procedures.
COBOL Stored Procedures
Define and code a COBOL stored procedure to access another table and confirm that the passed values are acceptable.
Defining SQL Procedures
Create a stored procedure using SQL/PL.
Write a simple stored procedure which receives values and return resultsets.
SQL Procedures Language
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.
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.
Virtual Classroom
Blended Learning
↓
Synchronous Instruction
Asynchronous Instruction
Effective February 27, 2012, the course dates listed on the CETi 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. CETi makes no representation regarding ownership in any of the software products that we train on.
CETi 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 CETi course and that the employer has a licensed version of the software.
Certain courses only should be taught by the source software company training company and open source purveyor.
