Programmer Tip: Generate reports using stored procedures

[Search400.com]

Title: Programmer Tips

December 29, 2004 Published by  Search400.com    Programmer Tips Issue Sponsored By:   > Aldon IN THIS ISSUE:   >  How to generate reports using stored procedures   >  Schedule stored procedures in DB2 UDB   >  What ports are needed to issue a stored procedure?   >  Stored procedures provide way to reuse RPG apps on the Web   >  Fast guide to redbooks on stored procedures   >  Tip contest: Win an iSeries.mySeries prize pack   >  Celebrate the festivities IT-style How to generate reports using stored procedures [Search400.com] When you want to generate reports from multiple types of databases, third-party tools in the open-system environment are much more flexible than reporting features found on the iSeries. But the better way is to use external stored procedures.   The Natural Selection for Enterprise Change Management In the new climate of regulatory compliance, enterprise change management has become an increasingly complex animal. If you're not taking steps to comply with the Sarbanes-Oxley Act, you might soon find it's a real jungle out there. The survivors are those who rely on Aldon software to automate complex compliance and development process control procedures. Click for our free Sarbanes-Oxley White Paper.   Schedule stored procedures in DB2 UDB [Search400.com] Search400.com expert John Brandt shares a resource he uses to schedule stored procedures. What ports are needed to issue a stored procedure? [Search400.com] According to DB2 UDB expert Kent Milligan, the ASP page will need to use an ODBC driver (most likely the iSeries Access ODBC driver) to perform the Stored Procedure call to a DB2 UDB for iSeries server. He suggests looking at the redbook "Stored Procedures & Triggers on DB2 UDB for iSeries." Stored procedures provide way to reuse RPG apps on the Web [Search400.com] Learn what stored procedures are used for, why they're preferred over other options, the benefits of the various types of stored procedures and how to create Java and RPG procedures. Fast guide to redbooks on stored procedures [Search400.com] Need information fast about using stored procedures on the iSeries? You've come to the right place. We've found redbooks for novices as well as experienced pros. Plus we've thrown in some example code and how-tos. SHOW YOUR DEVOTION:  Tip contest: Win an iSeries.mySeries prize pack Show off your love for your iSeries with this month's awesome prize package. Submit a tip for a chance to win an iSeries.mySeries shirt, bumper sticker and temporary tattoo. Don't forget to go in and rate our recent tips: Find your system security settings Security journal receiver management Tips for i5 eServer Hardware Management Console (HMC) Send message to users at a remote site HOLIDAY TRIVIA:  Celebrate the festivities IT-style 'Tis the holiday season! We've made a list and checked it each week. Now we're gonna find out who's naughty, who's nice... and who's a real holiday geek! Here's a festive sample of holiday IT terms with tantalizing clues. If you're a holiday-oriented geek, why not give it a try. IT'S FREE!:  iSeries freeware and shareware guide Here you'll find a number of useful tools that can be used as is or customized to create your own tools. We've saved you the time of searching the Web and have gathered some really good links for you to check out. Who says there's no such thing as free? Check out this great resource today. Have you come across freeware that we don't have listed here? Shoot us an e-mail and we'll add it to the library. Don't forget to bookmark this page as it will be updated frequently.   Contact Us Sales For sales inquiries, please contact us at: [EMAIL PROTECTED] Editorial For feedback about any of our articles or to send us your article ideas, please contact us at: [EMAIL PROTECTED]     Free E-Newsletters! Select e-newsletters you would like to receive via e-mail!  Search400: Administrator Tips  Search400: Security Tip  Search400: Today's News Not a Member? We'll activate your membership with your subscription.   This e-newsletter is published by Search400.com, a targeted Web site from TechTarget, the most targeted IT media and events company. To unsubscribe from "Programmer Tips": Go to unsubscribe: http://search400.techtarget.com/unsubscribe?cid=499986&lid=430677&track=NL-17&ad=499986 Please note, unsubscribe requests may take up to 24 hours to process; you may receive additional mailings during that time. A confirmation e-mail will be sent when your request has been successfully processed. Contact Us: Search400 Member Services 117 Kendrick Street, Suite 800 Needham, MA 02494