July 7th, 1998
Quarterly Users Group Meeting
The third HOTDUG meeting of 1998 was held on July 7th at the Texas Guaranteed Student Loan Office.
Hank Robinson - NET.DATA
"State Government Accounting Internet Reporting System (SIRS)" is an application at the Texas Comptroller of Public Accounts that was written using SQL, HTML, and REXX embedded in IBM's "Net.Data" macro language. The data accessed is stored in DB2 for OS/390. SIRS provides users with direct access to accounting data via the Internet. Depending on need, the user can either print the information locally in the form of a hardcopy report, or download the data for manipulation by other application software, such as Excel.
Willie Favero - DB2 Stored Procedures (The Whole Picture)
DB2 Version 4 became generally available in November, 1995. Of the many exciting features being delivered in DB2 Version 4, one of the most anticipated was Stored Procedures. However, Version 4 did not satisfy all of the stored procedure requirements. It took DB2 Version 5 to do that . Now, with DB2’s application of Stored Procedures, workstation and host based programs to take advantage of common code, utilize better security features, and better control enforcement of business rules. Still, the most significant feature of Stored Procedures is the reduction of network traffic and thus improving application performance.
This presentation will take a detailed look at how Stored Procedures are implemented in DB2 Version 4, how they have been enhanced in Version 5, and what you might expect to see in the future. It addresses what is needed in preparation for their implementation, coding and language considerations, how DB2 and the DB2 professional can manage them, and the new SQL introduced in DB2 Version 5 to support stored procedures. The primary focus of this presentation is DB2 Version 4 for MVS/ESA and DB2 for OS/390 Version 5.
This presentation is for the System Administrator, DBA, and Application Programmers. There is a little something here for everyone.
Biography
Willie Favero is a Principal Development Consultant with BMC Software, Inc., with over 24 years experience working with database software, 15 years of that with DB2. The majority of his DB2 experience comes from IBM where he was a DB2 Senior Instructor. Willie is the author of numerous articles, contributed to several of IBM Redbooks and he is a highly sought after presenter at GUIDE, SHARE, IDUG, DB2 Tech Conference, and local area user groups. Willie’s responsibilities at BMC include DB2 product strategy, planning and requirements across BMC’s DB2 product line for all platforms. He also performs consulting services and education for the DB2 family and the BMC products that support DB2
Last modified 2005-06-24 06:35 AM