Skip to content

DBAzine.com

Sections
Personal tools
You are here: Home » Resources » User Groups » HOTDUG » Events » July 7th, 1998
Seeking new owner for this high-traffic DBAzine.com site.
Tap into the potential of this DBA community to expand your business! Interested? Contact us today.
Who Are You?
I am a:
Mainframe True Believer
Distributed Fast-tracker

[ Results | Polls ]
Votes : 3357
 

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
Transaction Management
Reduce downtime and increase repeat sales by improving end-user experience.
Free White Paper
Database Recovery
Feeling the increased demands on data protection and storage requirements?
Download Free Report!
 
 

Powered by Plone