- 1751. Practical SQL: SQLCOD and SQLSTT
- (SQL)
- ... item by 15 percent. Instead, the most often used construct in the embedded SQL toolkit is the cursor, which essentially provides a dynamically built logical file to your RPG program. And like any logical ...
- Created on 03 November 2010
- 1752. IBM Announces Rational Business Developer V8.0.1
- (Development Tools)
- ... in EGL ran two, three, four times as fast as those written natively in RPG or COBOL, or even Java, wouldn't programmers be just a little more interested in trying EGL for their next development project? ...
- Created on 29 October 2010
- 1753. The API Corner: More on Message Handling
- (APIs)
- ... system APIs. As part of that discussion, we've explored some of the ways your RPG program can remove error-related messages from the job log. Due to several notes that I have received on the topic of message ...
- Created on 20 October 2010
- 1754. TechTip: Creating PDF Files with PHP, Part II
- (Web Languages)
- ... ol' days of the RPG cycle with 1P and LR. Add more tricks to your FPDF toolbox and learn how to control "overflow" printing. In my last TechTip, I introduced you to FPDF. This time, I will dig ...
- Created on 15 October 2010
- 1755. LANSA Announces aXes Mobile for Wireless Access to 5250 Applications
- (Analysis of News Events)
- The tool allows easy access to existing RPG and COBOL applications while providing RPG and COBOL programmers a way to employ existing skills to build entirely new mobile solutions. Written by Chris Smith ...
- Created on 15 October 2010
- 1756. Renaissance Framework Gets a GUI Designer
- (Development Tools / Utilities)
- CoralTree Systems has announced the forthcoming availability of a new graphical designer component for the Renaissance Framework, the most popular Open Source RPG developer's tool-kit for the creation and ...
- Created on 13 October 2010
- 1757. ASNA Introduces New Wings Modernization Tool
- (Development Tools / Utilities)
- A member of the Monarch family of modernization products, Wings will use IBM's Open Access for RPG to create new user interfaces on existing green-screen applications. ASNA announced ASNA Wings ...
- Created on 07 October 2010
- 1758. Sometimes Programs and Procedures Want to Know: Who Am I?
- (RPG)
- ... here was implemented as an ILE RPG procedure called who_am_i. The basic goals are the following: To retrieve information about the program or procedure currently being called—including program, library, ...
- Created on 06 October 2010
- 1759. TechTip: Do You Know How to Use PHP Functions?
- (Web Languages)
- Before OO came along, functions were all we had! Written by Jeff Olen We RPG developers are still relatively new to the concept of functions. I say "relatively" because some of my readers are still ...
- Created on 01 October 2010
- 1760. Partner TechTip: You Want a Greener Approach to System i Reports and Printed Output
- (Document Management)
- ... they execute commands, like ESNDFILE, at the end of their RPG, COBOL, or CL process. Report Archiving You don't need an expensive System i solution to archive reports to media. ESEND provides a reliable, ...
- Created on 01 October 2010
- 1761. CODA Financials Released on IBM i 7.1
- (Enterprise Resource Planning / Financial)
- ... This means organizations with applications written in RPG, COBOL, and/or Java-based applications can create real time interaction between those applications and CODA Financials using CODA web services, ...
- Created on 28 September 2010
- 1762. mrc Offers Users a Crash Course in Modernization
- (Development Tools)
- ... even business users can create new applications, while seasoned RPG developers can create Java apps without suffering the steep learning curve some experienced a few years back when trying to acquire Java ...
- Created on 24 September 2010
- 1763. TechTip: Chat with IM Clients from your i Apps
- (Java)
- ... CL command Instantiating a Java object from within an ILE RPG program using the Java Native Interface (JNI) Wrapping the Java program as an SQL routine (stored procedure or user-defined function) ...
- Created on 17 September 2010
- 1764. The Most Lightweight Mutually Exclusive Synchronization Mechanism
- (RPG)
- ... mutually exclusive synchronization between two or more threads. The following ILE RPG prototypes of the system built-ins of these instructions are extracted from mih54.rpgleinc of open-source project i5/OS ...
- Created on 15 September 2010
- 1765. The API Corner: Automating Recovery, Part III
- (APIs)
- ... to determining what went wrong when a CL command fails in the middle of our RPG application and attempting to recover from the error situation. Detect errors when using the API system. In last ...
- Created on 15 September 2010
- 1766. TechTip: 7.1 Offers Encrypted Debug Views
- (Security - Other)
- ... the problem. Wouldn't it be nice to just ship a debuggable version of your code and have it secure? In 7.1, the ILE compilers (RPG, COBOL, CL, C, and C++) and precompilers have a new parameter that allows ...
- Created on 10 September 2010
- 1767. Discounts and Freebies Abound as Technology Gets Ever Better
- (Analysis of News Events)
- ... the RPG & DB2 Summit, have announced they will provide training grants totaling 15 days of education to six deserving IBM i developers to attend this fall's RPG & DB2 Summit or the related Headstart Seminars. ...
- Created on 27 August 2010
- 1768. TechTip: Creating PDF Files with PHP, Part I
- (Web Languages)
- ... I read the documentation (or enough to get me started), and off I went. One new thing I had to learn was how to work with classes, which is something an old RPG programmer is not used to. I am not ...
- Created on 20 August 2010
- 1769. The API Corner: Automating Recovery, Part II
- (APIs)
- ... saw in the second article of this series, "Running CL Commands from RPG," the error code parameter enables you to control whether or not escape messages are returned to the RPG program in error situations. ...
- Created on 18 August 2010
- 1770. Easy400.net Releases New Open-source email Command
- (Business Integration)
- ... what you have, provides for sorting, scanning, etc., the received messages, much better than any RPG program would perhaps do. It's no cost, it's already there. "This could solve another issue. As you ...
- Created on 16 August 2010
- 1771. Seminars and Training Key to Embracing Change in IT
- (General)
- ... and data with the Web. Yet there are other emerging technologies to which RPG developers are quickly becoming exposed, technologies that allow taking data that resides in DB2 for i and presenting it not ...
- Created on 16 August 2010
- 1772. Technology Focus: You Don't Need a PhD to Deploy on PDA
- (Development Tools / Utilities)
- ... as rich-client single- or multi-tier applications. LegacyWeb Genesis V LegacyWeb automatically rewrites existing RPG, ILE RPG, and COBOL applications in HTML, enabling those apps to run in a ...
- Created on 16 August 2010
- 1773. Getting Started with Zend Framework on IBM i
- (Web Languages)
- You don't have to learn MVC to start using Zend Framework. Written by Jeff Olen Recently, at the COMMON conference, I presented several PHP sessions. Two sessions were aimed toward attendees that are ...
- Created on 11 August 2010
- 1774. Paris Presents Developers with Great Fast, Free Apps at OCEAN
- (General)
- ... available under the open-source MPL license V1.1, Renaissance is a framework of RPG ILE programs, service programs, JavaScript code, and HTML designed to enable developers to quickly and easily build high-quality ...
- Created on 06 August 2010
- 1775. A Fresh Approach to SCM
- (General)
- ... STMFSEU For many green-screen programmers, the Source Entry Utility (SEU) is the preferred tool to edit source in i5/OS native languages such as RPG, CL, or DDS. But unfortunately, SEU does not support ...
- Created on 04 August 2010
- 1776. Should You Upgrade to V7?
- (IBM i (OS/400, i5/OS))
- ... of the system and encourage deeper participation by software vendors. Another example of this approach is Rational's Open Access for RPG (more on that in a minute or two). There have also been significant ...
- Created on 26 July 2010
- 1777. ASNA Announces 10th Stateside ASNApalooza Oct. 7-8
- (Certification / Training)
- ... RPG (AVR), there will be others that show in detail how to use open source software effectively with AVR. You can read more about ASNApalooza 10’s technical agenda by clicking here. Roger Pence is ASNA’s ...
- Created on 21 July 2010
- 1778. The API Corner: Automating Recovery (or Keeping the Help Desk Out of the Loop)
- (APIs)
- Recover from, and remove, error messages when using the QCMDEXC API to run CL commands. Written by Bruce Vining In last month's column, "The API Corner: Running CL Commands from RPG," you saw that an ...
- Created on 21 July 2010
- 1779. Technology Focus: Facing the Strain: Web-Enablement Tools for System i
- (Development Tools)
- ... for System i Applications ASNA Visual RPG (AVR) for Microsoft Visual Studio .NET Monarch ASNA—A Blue Phoenix Company AVR for .NET is an RPG compiler that integrates with Microsoft Visual Studio ...
- Created on 19 July 2010
- 1780. Annual OCEAN Technical Conference Kicks Off this Friday
- (Certification / Training)
- ... including, "Top 10 Things RPGers Must Know," "Open Up with Special Files," and "MySQL-DB2 Connections," while Jon will conduct sessions on "Application Modernization," "PHP Intro for RPGers," and Re-thinking ...
- Created on 12 July 2010
- 1781. aXes e-Business Modernization Suite from LANSA Provides Cross-Browser Support
- (Development Tools)
- ... now includes "eXtensions" to allow developers to write new RPG or COBOL applications capable of running on just about any device up through the iPhone and Android-powered smartphones. aXes resides exclusively ...
- Created on 09 July 2010
- 1782. Practical RDPi: Filters for Fun (and Productivity)
- (RPG)
- ... tool to replace all instances of the field name CUSNAM with CUSNME and it will dutifully do exactly that, and thanks to the cryptic nature of field names in RPG, the chances are that the execution will ...
- Created on 07 July 2010
- 1783. Are You Taking Full Advantage of the System Entry Point Table Object?
- (RPG)
- ... a system pointer to an MI object? Let's find out. The following two ILE RPG programs, jan23b.rpgle and jan25b.rpgle, call the Send Data Queue (QSNDDTAQ) API to enqueue a queue entry to a data queue ...
- Created on 07 July 2010
- 1784. COMMON Offers Big Discount on Fall Conference
- (Certification / Training)
- ... such as AIX, Linux, PHP, RPG, DB2 Web Query, IBM Rational Software, and Upgrading to IBM i 7.1. View the available sessions in the Online Session Guide at http://www.common.org/fallconference/sessions.html ...
- Created on 06 July 2010
- 1785. TechTip: The i Side of Real-Time Integration Between Your PC Application and Your System i
- (RPG)
- We continue our quest to create an RPG program that "talks" to your PC application. Written by Rafael Victoria-Pereira In a previous tip in this series, I described how to use ADO to call an RPG program ...
- Created on 02 July 2010
- 1786. Choosing a Web Language? Choose Wisely.
- (Web Languages)
- ... few lines of code, I accessed an RPG-CGI server on my i. I took a very simple example (that I got from the Internet) and added a few lines of my own code. public void onClick(View v) { ...
- Created on 28 June 2010
- 1787. A Good Application Generator May Be Your Guiding Compass out of Today's Modernization Wood
- (Development Tools)
- ... the engineering of applications. Large-scale translation of existing RPG code into Java or other contemporary language is unrealistic in most cases and generally results in programs that are foreign to ...
- Created on 28 June 2010
- 1788. CIOs and Other C-Level Execs Gather in Santa Barbara to Discuss Changing Technologies
- (Analysis of News Events)
- ... the AS/400 and acknowledged having in-house RPG programmers doing maintenance work on various IBM i mission-critical applications that they confided they wished they could find a way to replace. The problem ...
- Created on 21 June 2010
- 1789. Create, Format, and Export SQL Dates and Times Using DB2
- (SQL)
- After reading this article, you'll never worry about date formats again. Written by Tom Snyder My recent articles on exporting data have generated a number of questions on formatting dates with SQL. ...
- Created on 16 June 2010
- 1790. Today's Economy Encourages a Second Look at Low-Cost Modernization Tools ...
- (Development Tools)
- ... The crescendo has risen with the introduction of Rational Open Access, RPG Edition (not a tool but software that provides the runtime enablement for the I/O handlers) and the repulsion by several vendors ...
- Created on 11 June 2010
- 1791. AS2 and Syslog Features Added to GoAnywhere Director
- (Development Tools / Utilities)
- ... from any Web browser or Internet-enabled phone. Processes in GoAnywhere Director can be launched from a variety of third-party applications, schedulers and languages including CL, RPG, Java, C, .NET and ...
- Created on 09 June 2010
- 1792. Easily Transform Legacy Printouts into Excel Files
- (Java)
- ... Java APIs to create Excel spreadsheets directly from an RPG program. Don't be scared about the "Java APIs" part; they will be hidden "under the hood," and you won't even notice them. For those of you ...
- Created on 09 June 2010
- 1793. Utilities 400 Boosts Business Intelligence Offering with ShowMe+
- (Business Intelligence)
- ... engine is written in ILE RPG. Resource requirements are low; most customers run the Web serving from a server that is shared with other applications. About Utilities 400 Limited Utilities 400 is the ...
- Created on 07 June 2010
- 1794. TechTip: Do You Understand the DB2 for i Environment Settings?
- (DB2)
- ... will scan for required unqualified objects while a job is running. For instance, if a COBOL or RPG program requests access to a database table, under the covers i5/OS will search sequentially through ...
- Created on 04 June 2010
- 1795. A Close Study of i5/OS Machine Interface (MI) Pointers
- (RPG)
- ... the attributes of a space object or the associated space of an MI object. Example ILE RPG program T057 (below) manipulates an independent index object (object type code of an index object is hex ...
- Created on 02 June 2010
- 1796. The CL Corner: Cut, Snip, Trim with TRMLFTCHR
- (CL)
- By adding new keywords to the command, you can trim any leading character. Written by Bruce Vining In the previous article, "Going Where No Substring (%SST) Operation Can Go," we saw what the Trim ...
- Created on 28 May 2010
- 1797. OCEAN User Group of Southern California Announces the 17th Annual Technical Conference and Expo
- (Channel News)
- ... technology There will be five free vendor presentations in addition to the 25 fee-based classes Audience: RPG programmers, application development managers, operations/systems administration—tech support, ...
- Created on 24 May 2010
- 1798. Krengel Technology Releases DB2 Web Service Enabler
- (Development Tools / Utilities)
- ... RPG-XML Suite development toolset for IBM i (AS400) shops. While RPG-XML Suite delivered a customizable RPG-based toolset to facilitate the composition, transmission, and parsing of XML from RPG, DB2 ...
- Created on 20 May 2010
- 1799. The API Corner: Do I Really Need to Call a CL Program to Perform This Function?
- (APIs)
- Run CL commands from within your RPG application program. Written by Bruce Vining Related to my article "V7R1 CL: Something for Everyone," published last month in an MC Special Issue, Avrohom N. sent ...
- Created on 18 May 2010
- 1800. MC Press Online Wins Maggie Award
- (Channel News)
- ... born from the now-defunct Midrange Computing, publishes four high-tech online publications in addition to MC Systems Insight, including MC iApplication Designer, MC RPG Developer, MC iTechnology Manager, ...
- Created on 18 May 2010