Date: Thu, 16 Oct 2003 18:02:09 +0000 (CUT) From: IBM DB2 Information Management Software Subject: DB2 Information Management Software Today newsletter DB2 Information Management Software Today newsletter Welcome to the October issue of IBM DB2 Information Management Software Today, the e-Newsletter that delivers exciting offers, product news, events, education and more around the DB2 software portfolio of solutions. Don't forget the 2003 IBM Data Management Technical Conference at the end of the month! This exciting 4.5 day event will provide you a gateway to experiencing IBM DB2 information management software's entire product portfolio. Explore the most in-depth technical content available on the planet in one place at one time! Having brought together the DB2, IBM Informix® and IBM U2 communities into one event, we're offering you the chance to network and gain a complete picture of the DB2 software product portfolio, solutions and services. Don't miss this opportunity to develop skills in numerous DB2 software product technologies and gain new insight, address business issues and enhance your technical knowledge to grow your business opportunities. Determine which sessions you'd like to attend ahead of time by reviewing our detailed session abstracts that are now available on the Web. Come join us in Las Vegas, Nevada on October 27-31, 2003 for the event that's the best of its kind! http://www.ibm.com/training/conf/us/dm Have you updated your profile to receive the newsletter in a convenient HTML format? https://www6.software.ibm.com/reg/dm-db2modify/dm-db2modify-r Do you have colleagues that would find value in this newsletter? New readers can subscribe and customize the newsletter to accommodate their interests in DB2 software by visiting http://www.ibm.com/software/data/db2infonews/ How are we doing? We welcome and encourage your feedback on the information we bring to you monthly. Please send any comments that you may have to imstodayatus.ibm.com. In This Month's Issue: ====================== Events o Cognos ReportNet Global Launch Re-broadcast DB2 Information Mangement Software Product Line o SMB Literature Webpage o Exciting New Features in the Redesigned zSeries Software Catalog Industry Information o IBM DB2 and DiscoveryLink Help Find Genetic Links to Immune System Diseases Technical Corner o User-defined Aggregate Functions in DB2 UDB Article o DB2 Data Bound ASP .NET Form using VS.NET Tutorial o Converting Oracle Pro*C Programs to DB2 UDB Article o Moving from the BDE and dbExpress to ADO.NET and the Borland Data Provider Article o DB2 UDB Server for OS/390 and z/OS Version 7 Presentation Guide o Producing HTML Reports from DB2 Data - the Easy Way o Building Distributed Database Applications in .NET Using BDP and DB2 UDB o Formatting and Using the DB2 UDB History File o Guide for Embedding DB2 Universal Database Express Edition V8.1 o DB2 Basics: Cloning DB2 Databases Using Redirected Restore o DB2 Version 3: The Official Guide Certification o Advanced DBA Certification Guide and Reference for DB2 UDB Training Classes o IBM Advanced Career Education (ACE) Program ------------------------------------------------------------ Events ------------------------------------------------------------ Cognos ReportNet Global Launch Re-broadcast Thousands of people around the world participated in the Cognos ReportNet Global Launch on September 9, in New York, when Cognos launched Cognos ReportNet. People tuned in from around the world to view this unprecedented event. Here is your chance to watch the revolution unfold. A complete archive of the launch event is now available for on-demand viewing It's not too late to witness the revolution, or to view the program again. Check it out.http://www.cognos.com/launch_ibm/ ------------------------------------------------------------ DB2 Information Mangement Software Product Line ------------------------------------------------------------ SMB Literature Webpage IBM's Software Group has announced the launch of the SMB Literature page. All SMB-related collateral has been consolidated on one Web page for easy viewing by customers and business partners. Check it out and let us know what you think. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL103B31 Exciting New Features in the Redesigned zSeries Software Catalog The redesigned and updated zSeries Software Catalog provides complete information on the full suite of mainframe products. Contents cover operating systems, middleware and tools and can be navigated by platform, solution, keywork or products names. Updates over the next few weeks will include a full Linux category and customer stories to demonstrate the value of the mainframe from the point of view of enterprises around the globe. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL103B5 ------------------------------------------------------------ Industry Information ------------------------------------------------------------ IBM DB2 and DiscoveryLink Help Find Genetic Links to Immune System Diseases The Fred Hutchinson Cancer Research Center has announced that its researchers are using IBM technology to help discover why some people are more susceptible than others to infectious and autoimmune diseases, such as leukemia and AIDS. The research also seeks answers to medical mysteries such as why vaccines protect some individuals better than others and why some close donor-recipient transplants fail. Learn more about this exciting research.http://www.ibm.com/isource/cgi-bin/goto?on=IMNL103B9 ------------------------------------------------------------ Technical Corner ------------------------------------------------------------ User-defined Aggregate Functions in DB2 UDB Article DB2 Universal Database supports several built-in aggregate (or column) functions including AVG, COUNT, MIN, MAX, SUM, and others. However, there is currently no direct way to implement your own user-defined aggregate function. This article presents an approach for achieving specific aggregations. The technique employs the built-in aggregate function MAX to perform the actual aggregation, and several features that are available for scalar user-defined functions to provide the special needs required by aggregates. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL103B14 DB2 Data Bound ASP .NET Form using VS.NET Tutorial This tutorial demonstrates how to use the DB2 Development Add-In for Visual Studio .NET to build a rich ASP.NET WebForm in C# using design-time and run-time data binding. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL103B15 Converting Oracle Pro*C Programs to DB2 UDB Article Updates in products often mean changes to your processes. This article explains the steps necessary during Oracle Pro*C program conversion to C with embedded DB2 SQL calls. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL103B16 Moving from the BDE and dbExpress to ADO.NET and the Borland Data Provider Article The streamlined features of the Borland Data Provider give .NET developers who need to access IBM DB2 an efficient and scalable way to create Windows client and Web applications. In this article, Jeremy McGee looks at what ADO.NET classes and interfaces can do, using C#Builder Enterprise, DB2 UDB, and the IBM Managed Data Provider for the Microsoft .NET Framework. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL103B17 DB2 UDB Server for OS/390 and z/OS Version 7 Presentation Guide This IBM Redbook, in the format of a presentation guide, describes the enhancements made available with DB2 V7. These enhancements include a new feature, DB2 Warehouse Manager, which simplifies the design and deployment of a data warehouse within your S/390, as well as performance and availability delivered through new and enhanced utilities, dynamic changes to the value of many of the system parameters without stopping DB2, and the new Restart Light option for data sharing environments. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL103B21 Producing HTML Reports from DB2 Data - the Easy Way You don't necessarily need special tools to get your DB2 data into shape for viewing from a browser. This article tells you how to produce reports with just some SQL and a little HTML. Use the example our author provides to generate a detailed report of your database configuration. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL103B23 Building Distributed Database Applications in .NET Using BDP and DB2 UDB This article uses the Borland Data Provider (BDP) for .NET that ships with Borland C#Builder for data access from IBM DB2 Universal Database (UDB). It introduces the basics of .NET remoting and shows how to remote data from one tier to another; and it shows how to convert the raw data into meaningful information, either by the clients updating the presented data or by running the data through some business rules on various tiers of the distributed application, using ADO.NET Dataset for data manipulation on the client. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL103B24 Formatting and Using the DB2 UDB History File Make use of all that information in the DB2 UDB history file! This article shows how to bring the DB2 UDB history data into a table and use it as the basis for performing administrative tasks such as backups and log management. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL103B25 Guide for Embedding DB2 Universal Database Express Edition V8.1 This guide gives you all the details for successfully embedding IBM DB2 UDB Express Edition V8.1 into your application for a complete customer solution. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL103B28 DB2 Basics: Cloning DB2 Databases Using Redirected Restore This popular article on cloning a DB2 UDB database has just been updated for UNIX. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL103B29 DB2 Version 3: The Official Guide This book shows you how to make the best of DB2 UDB V8 in any environment. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL103B30 ------------------------------------------------------------ Certification ------------------------------------------------------------ Advanced DBA Certification Guide and Reference for DB2 UDB This is the definitive guide to advanced DB2 UDB database administration that also delivers all the depth and insight you need to prepare for the IBM exam. Straight from our DB2 experts, this book offers coverage of every exam objective and will serve as a reference after you have passed the exam. Get your copy today! For more information or to order visit the website. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL103B13 ------------------------------------------------------------ Training Classes ------------------------------------------------------------ IBM Advanced Career Education (ACE) Program This unique certificate training program: IBM Advanced Career Education (ACE) program for e-business Application Development provides IT professionals and graduates a chance to design and develop solutions while preparing them to address present and next generation e-business challenges. Through classroom education, lab exercises, and team programs, participants will log more than 700 hours of real world training simulating an e-business application experience. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL103B8 ============================================================ You received this e-mail because you are subscribed to Data Management as: newsatos2site.com Helpful Web sites: IBM DB2 Information Management Software Home Page: http://www.ibm.com/software/data/ DB2 UDB Product Family: http://www.ibm.com/software/data/db2/udb/ IBM Informix Product Family: http://www.ibm.com/informix/ DB2 Content Manager Portfolio: http://www.ibm.com/software/data/cm IBM U2 Product Family: http://www.ibm.com/software/data/u2 IBM DB2 Information Management Events Calendar: http://www.ibm.com/software/data/events/ IBM DB2 Information Management Training: http://www.ibm.com/software/data/education.html IBM U2 Education: http://www.ibm.com/software/data/u2/education IBM Global Services: http://www.ibm.com/services/learning IBM U2 Support http://www.ibm.com/data/software/u2/support IBM Passport Advantage program http://www.ibm.com/software/passportadvantage IBM U2 Business Partner Solutions: http://www.ibm.com/software/data/u2/partners International Informix Users Group http://www.iiug.org International DB2 Users Group http://www.idug.org We know you're concerned about your privacy, and so is IBM. If you provide IBM with information about yourself, such as name, postal address, or other personal data, we may add it to our records. This data may be used to provide you with information from IBM or selected organizations worldwide about products, services, or activities that may be of interest to you. IBM is a global organization; therefore, we may transfer your personal information to countries in the world, which provide various levels of legal protection. Please realize that when you give us personal information, IBM will handle it according to its internal privacy practices which are designed to provide a high level of protection for your personal data worldwide. If you prefer that IBM no longer send you this newsletter by e-mail, you can UNSUBSCRIBE by completing the form with your name and email address at https://www6.software.ibm.com/reg/dmunsubscribe/dmunsubscribe-r This request will remove your name from future mailings of this newsletter. Thank you. IBM Software, Route 100, Building 1, Somers, NY 10589