If you've been avoiding this technique, maybe you shouldn't be.

Written by Junlei Li

With the introduction of the ILE programming model, high-level languages (HLLs), including RPG, are enabled to make bound calls (procedure calls). This makes it possible for programs written in ILE RPG to cooperate with all the other HLLs available on the i5/OS, including Java, and to reuse all existing algorithms and functionalities that have been implemented in other HLLs. This fact is often regarded as proof of the RPG language's openness and modernization.

SQL Cancel support has been greatly enhanced and simplified.

Written by Kent Milligan

Occasionally, a programmer or user issues an SQL-based report that runs much longer than anticipated. The long-running query may be caused by the user underestimating the complexity of the query or by the size of the data sets being searched. In these situations, it's nice to be able to cancel the SQL request midstream and free up the system resources that the long-running request is consuming. Cancelling the query also gives the submitter an immediate opportunity to review the SQL request instead of waiting for the request to complete.

There are different approaches to integrating labeling and RFID tags with your System i database, and some are easier to manage than others.

Written by Thomas M. Stockwell

Editor's Note: This article is an extraction of the white paper "Bar Code/RFID Label Printing, Avoiding the Integration Traps," which is available free from the MC Press White Paper Center.

Automated Data Collection (ADC) technologies that use bar code and radio frequency identification (RFID) labels have revolutionized how our products are packaged and transported through our supply chains. Bar code labels are now so common on products that they are considered to be the status quo for identifying and routing packages in transit. RFID tag technologies are also making tremendous headway in managing inventory at receiving docks and warehouses for many of the largest retail and government supply chains. How can we assure that these systems give us the best return on investment?

Featured White Paper:

Bar Code / RFID Label Printing, Avoiding the Integration Traps

T.L. Ashford & Associates, the leader in bar code labeling software for the IBM i is sponsoring a FREE WHITE PAPER by Thomas M. Stockwell. This white paper examines three approaches to ADC integration with IBM i. It identifies the integration traps commonly experienced by business and then examines a better approach using native IBM i labeling software specifically designed for the IBM i architecture.
Download this NEW White Paper Today!

Don't miss these great offerings in the MC Press White Paper Center:

• Aberdeen Group White Paper: The Importance of High Availability; Continuous Applications and Data Recovery
• iSeries-AS/400 MICR Check Printing
• Executive Overview: Simplifying the Management of IBM i Environments
• Replacing IBM Query/400: Understanding Your Options
• Research Study: The State of Resilience and Optimization on IBM Power Systems
• SYSTEM i MODERNIZATION SURVIVAL GUIDE
• What Every Healthcare IT Manager Needs to Know - How to Solve Downtime Challenges to Patient Care, Operations and HIPAA Compliance
• Compliance without the Complexities
• Managing Changes to Critical Data
• The Data Protection Benchmark Report- The Road to Recovery
• Bringing Mashups to Your Enterprise Business Applications
• Executive Overview: System Migrations without Business Downtime
• Paperless Customer Service - Streamlining Customer Service Processes
• Get the Facts: Real-Time, On-Demand Information for Business Intelligence and Data Integration
• Beyond the Security Breach: Protect Sensitive Data Using Encryption & Key Management (USA and CANADA only!)
• Best Practices: The Fundamentals of Document Automation
• Journaling and High Availability - Understanding IBM i Data Protection
• SOA What? Why SOA is Critical for iSeries RPG Shops
• High Stakes of Data Availability: An Executive Guide to IBM iSeries Recovery Options (USA only!)
• Case study on Sperian Protection’s Paperless Transition
• Keeping your System i Applications Relevant in a Service-Oriented World
• Best Bets for iSeries Rapid Recovery with Virtualization: An Executive's Guide to Affordable IBM iSeries Recovery in 12 Hours or Less (USA only!)
• Please send me a link to the free white paper "ARCAD and the ITIL Framework."
• Supply Chain Synchronization: Recession-proof Strategies for Improving Efficiencies
• Revolutionizing System i Application Modernization
• THE EIGHT PILLARS OF AN ENTERPRISE APPLICATION ARCHITECTURE
• Get the Facts on Information Availability: How to Solve Downtime Challenges to Manufacturing and Supply Chain Operations
• Product case studies and registration details for a FREE product demo (USA and CANADA only!)
• Converging Voice and Business Applications: A Practical Approach (USA and CANADA only!)
• 51 Things you can Automate on your System i (iSeries) – and prove Return on Investment

Let the MC Webcast, Whitepaper, and Software Centers help you make a New Start in the New Year and you might just win a New Netbook by Dell. Visit today to find an amazing variety of IBM Power Systems solutions to make your job easier and more productive. While there enter to win a Dell Netbook…a $300 value! One lucky winner will receive one of their very own.

Have a White Paper you would like to list? Click here or call (208) 726-6822 for information.