NADBUG CLASS on 3/11/2003 - If anybody is interested, please let me know.

Steve Bobo

NADBUG CLASS on 3/11/2003 - If anybody is interested, please let me know.
On March 11, the Nashville Tennessee DB2 User Group will be hosting a one
day class on DB2 for OS/390 V7 Stored Procedures. The class will be taught
by Daniel Luksetich from YL&A, Inc.

You are invited to attend the one day class on stored procedures, the cost
of the class for NADBUG members will be $200 & the cost for non NADBUG
members will be $250.

Pre Registration is necessary, we need at least 10 students to have the
class, please contact me for further details.

The class will be held at the ICP Auditorium at Ingram Book Company, 14
Ingram Blvd, Lavergne, TN 37027.


DB2 FOR OS/390 V7 STORED PROCEDURES

This class will detail the creation, coding, and administration of DB2 for
OS/390 V7 stored procedures. This includes a review of the DDL that creates
a stored procedure, monitoring, and administering the stored procedure
security. Also included with be a detailed overview of the DB2 stored
procedure parameter styles, and how to effectively call a stored procedure,
pass parameters, and return result sets. Examples will include COBOL, C, and
Java stored procedures and local clients, as well as ODBC/CLI and JDBC
clients.

The stored procedure class goes into great detail on the following topics:
-Procedure definition
-Workload managed application environments
-Parameters and parameter styles
-Coding stored procedures
-Processing result sets
-Stored procedure security
-Stored Procedure Builder
-Java stored procedures and clients
-REXX stored procedures and clients

AGENDA

8:30- 9:00 Introduction
9:00-10:00 Class Starts
10:00-10:15 Break
10:15-11:15 Class
11:15-11:30 Break
11:30-12:30 Class
12:30- 1:30 Lunch
1:30- 2:30 Class
2:30- 3:15 Break
3:15- 5:00 Class
5:00PM is dismissal, but ends a little earlier if there are not
many questions and issues.

What is covered in the class?

-Introduction
-Administration (including WLM information, and operations)
-Security
-Programming
-Result Sets
-ODBC access
-Java access
-SQL/PSM
-REXX
-Java stored procedures
-Stored Procedure Builder
-Examples
-Live demo

If you have any questions, please contact me at you convenience.

Thanks!!

Steve Bobo
ACS, Inc.
800 Crescent Centre Drive
Suite 600
Franklin, TN 37067
615-503-9249
[login to unmask email]