Programmer Tip: Using constraints

[Search400.com]

Title: Programmer Tips

December 15, 2004 Published by  Search400.com    Programmer Tips Issue Sponsored By:   > Aldon   > Profound Logic Software's RPGsp IN THIS ISSUE:   >  The ins and outs of using constraints   >  Name that constraint   >  Disable all constraints in a library   >  The truth about indicators   >  Nine skills every RPG programmer should have   >  iSeries freeware and shareware guide   >  User poll: Should vendors rethink their software pricing programs? The ins and outs of using constraints [Search400.com] by Paul Tuohy A couple of months ago we tackled the subject of identifying the names of constrant violations in RPG programs. Before you can do that, however, you need to understand how constraints work. So, let's take a closer look at constraints, what they are and how you define them. MORE INFO: > View previous tips by Paul Tuohy   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.   Name that constraint [Search400.com] 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. Paul Tuohy discusses how you can fix that. Disable all constraints in a library [Search400.com] When refreshing his development database with "live" production data, Search400.com member David Ford always has to disable all the Referential constraints before copying in the data. To facilitate this process, he created a CL program that changes the status on all constraints in the specified library to *DISABLED. 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. 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.   RPGsp Has Revolutionized iSeries Web Development! - Use numerous Wizards and Over 100 Templates to get started instantly - Create Inquiries, Forms, E-commerce sites, and more - Reuse RPG code and skills - no proprietary languages to learn - Continually evolving: over 250 new enhancements added in the past year alone - Affordably priced Schedule a Live RPGsp Demo or download a FREE Trial today!   SURVEY:  User poll: Should vendors rethink their software pricing programs? Do you believe vendors need to rethink their software pricing programs? Vote now 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.   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=499424&lid=430677&track=NL-17&ad=499424 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