October 11 SIRDUG Educational Seminars Featuring Linda Claussen
WHEN? October 11 (Friday)
IBM Harris Blvd facility (Charlotte, NC) - See directions below
COST? $175 cash or check, per day, at the door.
We do not accept credit cards.
Featured Speaker - Linda Claussen
8:00 - 9:00 - Registration - Coffee, Danish, and Networking
9:00 - 12:15 - Linda Claussen "DB2 Stored Procedures"
12:15 - 12:55 - Lunch
1:00 - 1:15 - SIRDUG business meeting
1:15 - 4:00 - Linda Claussen "DB2 Stored Procedures (continued)"
To pre-register please email email@example.com and give us your name and
company. If you are not already on our distribution list and wish to be,
include your email address and phone number.
Pre-registration must be completed by Midnight, Monday, October 7th. Please
feel free to invite others from your company (just make sure
they pre-register as well). If you know others in your company who are
interested in attending future SIRDUG events, please encourage them to
become members of our distribution list (we just need their names, email
addresses and phone numbers).
SIRDUG will be calling or emailing a confirmation for each person who
pre-registers by the deadline. If you have pre-registered and have not
received a confirmation by the day after the deadline, please notify us as
your registration may not have been received.
If you have not pre-registered by the deadline, you may pre-register after
the deadline or register at the door, but the availability of presentation
handouts and lunch can not be guaranteed and confirmations will not be sent.
The meeting is in the IBM Harris Blvd facility
North bound on I-77 (from the Rock Hill direction): Turn right onto I-85
North and follow next directions.
On I-85 (coming from either direction): Take exit 45B onto Harris Blvd.
West Turn Left at 2nd stop light onto IBM Drive and follow directions below.
South bound on I-77 (from the Statesville direction)
Turn left onto Harris Blvd. East (exit 18)
Go approximately 6.3 miles to
the 10th stop light (counting the one at top of I-77 ramp)
Turn Right onto IBM Drive (Don't turn onto the IBM Drive at the 7th stop light).
Once on IBM Drive, Turn Right at 2nd drive. Go through gate (tell them
that you are here for a SIRDUG meeting) Find a parking place and enter the
Visitors Lobby. Follow the SIRDUG signs to the Cafeteria Conference Room.
A frequent speaker at conferences and user groups, Linda's 30+ years
of experience spans the various roles of application developer,
project manager, Data Base Administration and Systems Programmer.
Linda's first exposure to DB2 started with DB2 1.1 and during the late
80ís and throughout the 90ís she has been actively engaged in
consulting and training assignments to large DB2 MVS and OS/390
environments. She has frequently worked with
new DB2 sites performing the initial DB2 install, providing training
and consulting to the Project Leader, DBAs and Application staff
responsible for the initial DB2 pilot project and conducting design
reviews to insure successful project implementation. Linda is
currently a principle of Claussen & Associates, a member of the IBM
DB2 GOLD Consultants program and technical advisor to CBI Inc.
Educational Seminar Details
This 1 day seminar is a composite of the Stored Procedures Part 1 & 2
seminars, developed for the 2002 IDUG North American conference.
Stored procedures are becoming one of the hottest topics in the development of client/server applications. Stored
procedures are the easiest way to perform a remote call and to distribute the logic of an application program. Your
programming productivity and performance can be improved by using stored procedures when you develop client/server
The main goal of the stored procedure is the reduction of network message flow between the requester (the application) and
the data server (DB2) in a distributed environment. Another important usage of stored procedures is to have functions
callable from any application on any platform.
This 1 day seminar presents the coding and administration requirements to implement, develop and test Stored Procedures
for the DB2 UDB for z/OS and OS/390 for use in both a distributed and non-distributed environment as well as
cross-platform stored procedures development.
∑ Stored Procedures Environment
∑ Coding and Testing Stored Procedures
∑ Calling Stored Procedures from Remote Clients
∑ SQL Procedures Language
∑ Stored Procedures Builder
1. Stored Procedures Environment
∑ What are Stored Procedures?
∑ Software Prerequisites
∑ Stored Procedures Architecture
∑ Environment set-up requirements
∑ DB2 private Stored Procedures vs WLM Stored Procedures
∑ Implementation and Administration
2. Stored Procedures
∑ Developing the Stored Procedure
∑ Preparation Procedures
Defining the Stored Procedure
∑ Calling the Stored Procedure
∑ Result Set Stored Procedures
∑ Accessing Non-DB2 Resources from Stored Procedures
∑ Software Prerequisites
∑ RRSAF interface
∑ Accessing non-DB2 resources
∑ Using Global Temporary Table
∑ Coding Examples
3. Calling Stored Procedures from Remote Clients
∑ Distributed SQL Procedures Environment
∑ Calling Stored Procedures
CLI & ODBC Applications
WebSphere Application Server Java
∑ DRDA support for 3-part Names
∑ Performance Considerations
∑ Application Considerations
4. Stored Procedures Builder
∑ What are SQL Stored Procedures
∑ Procedures Body
Basic Control Statements
∑ SQL Allowed
∑ Stored Procedures Builder
Working with Existing Stored Procedures Guidelines
Note: There will be additional cost for Educational Seminars.
February 15 - User Speakers, Robert Catterall, Dan Alion, Paul Turpin
IDUG NA 2002 Comes To You
April 11 - Joel Goldstein & Scott Hayes
Monitoring, Tuning, & Bufferpools
June 28 - Let's Look Into the Futures
August 22,23 - Bonnie Baker - Educational Seminars: "Explain Explained" (Aug 22)
"The Best of Things I Wish for Developers" (Aug 23)
September 26 - Database Vendor fair - Greensboro, NC
October 11 - Linda Claussen - Education Seminar - Stored Procedures
If you have any links that you would like to see on our pages,
send SIRDUG an EMAIL using our mail box below.
SIRDUG Home Page
Last Update: September 27, 2002
Copyright © 2002 SIRDUG Inc. All rights reserved.