Programmer Tip: Name that constraint

[Search400.com]

Title: Programmer Tips

September 08, 2004 Published by  Search400.com    Programmer Tips Issue Sponsored By:   > Aldon   > Profound Logic Software's RPG-Alive IN THIS ISSUE:   >  Name that constraint   >  The truth about indicators   >  Nine skills every RPG programmer should have   >  Exception/error handling in RPG   >  Monitor for a fatal RPG III error Name that constraint [Search400.com] by Paul Tuohy I am a big fan of Referential Integrity -- both Referential Constraints and Check Constraints. They remove a lot of code from my programs and provide the added benefit of ensuring that the constraint rules will be applied to any other applications that "need" to access my database. But there is one annoying detail with using Referential Integrity in RPG programs. A constraint violation is notified as a file I/O error, but it does not identify which constraint caused the problem. So let's review a couple of methods for having your RPG program provide a meaningful message to the user when there is a constraint violation. MORE INFO: > View previous tips by Paul Tuohy   WebSphere and Enterprise Application Management With WebSphere application development products, synchronizing work across multiple enterprise platforms is difficult and time-consuming. Project teams must meet frequently to determine the readiness of independent components. Now, EAM can dramatically improve your WebSphere development teams' productivity by coordinating multi-tier application development across multiple teams. Click here to learn more or call 800.825.5858   The truth about indicators [Search400.com] Frequently you hear programmers say it's better to not use indicators in RPG IV. However, that simply isn't true. In fact, indicators are a lot more powerful in RPG IV, and we should use them more -- not less. Nine skills every RPG programmer should have [Search400.com] Do you get the feeling you are being left behind in the technology race? You know you want to move forward, but you don't know where to begin. Why not begin with simply expanding your current skills? Here are nine skills every RPG programmer should have. Exception/error handling in RPG [Search400.com] Confusion reigns when users sees a CPF error message. They're either unable to help you solve the problem or, worse, they ignore the error. It's impossible to test programs to ensure that they will never fail with a CPF message, but you can handle those errors in a more meaningful way. Monitor for a fatal RPG III error [Search400.com] In a CL program, how do you monitor for a fatal RPG III error? Site expert John Brandt explains. SURVEY:  User poll Which of the following technologies are strategic for you to learn going forward? Java J2EE RPG Eclipse Other   Edit & Analyze RPG code up to 5 times faster Any complex RPG programs at your shop? Let RPG-Alive make sense of them instantly! RPG-Alive, 2004 APEX Award Winner for Best Programming Utility, takes away the mundane & boring tasks associated with RPG development. Within 1 minute, RPG programming can be fun again! Free Download! Effortless 1-Minute Installation!   TIP CONTEST:  Submit your tips to win a hand-held TV Don't miss that big game because you're stuck at the office, or worst yet, a boring family party. You can enjoy the brilliant clarity of a TFT-LCD screen on the world's smallest TV anywhere. If you have a shortcut or time-saving tip that could help out other iSeries users, submit it today and you may be our lucky winner. Don't forget to go in and rate our recent tips: Easy code copying How to do date manipulation in a CL program Create an RPG technical document using existing iSeries utilities EXPERT ANSWER CENTER:  Fast answers for difficult questions With more than 12,000 answers from IT experts, the Expert Answer Center KnowledgeBase may just have your question answered before you ask it. Can't find what you're looking for? Our rotating lineup of featured experts are waiting for your questions (they're writing blog entries instead of twiddling their thumbs); every two weeks, their specific topic changes. So see what's in store this week and what's coming up. If you ask your question early, you'll be among the first to receive a reply.   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?track=NL-17&ad=490899 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