- 1551. Planning for Legacy Transformation
- (General)
- ... enough to delete them (Continue the banter on Twitter with #mightbelegacyif.) On a more serious note, MC Press ran a survey of RPG development shops a couple of years ago. Some of the findings ...
- Created on 09 April 2012
- 1552. How Much Do You Know About Job Switches?
- (RPG)
- ... SWS(1XXXXXXX) Built-in Support for Accessing Job Switches in RPG At the language level, OPM RPG and ILE RPG support job switches via external indicators—in other words, indicator U1 through ...
- Created on 04 April 2012
- 1553. Power i Forecast: Top 10 Development Tools
- (Development Tools)
- ... output the build in different languages, including Java, Java EE, C/C++, RPG, and COBOL. Now, if you just want a tool for building new Web apps, then try Websphere Application Server - Express, which ...
- Created on 02 April 2012
- 1554. The CL Corner: Introducing the New Run SQL Command
- (CL)
- ... Some possible implementations would be creating a DFU application program, writing a program using a high-level language such as RPG, or using interactive SQL. Using the RUNSQL command, we now also have ...
- Created on 30 March 2012
- 1555. Get Your Free Zip and Security Monitoring Tools
- (IBM i (OS/400, i5/OS))
- ... However, it has all the parameters built into it and, since it's CL-based, provides users with a natural command-line interface rather than a more complicated RPG program using IBM APIs. For those individuals ...
- Created on 30 March 2012
- 1556. CNX Announces Release of Valence 3.1
- (Development Tools / Utilities)
- Valence Nitro App Builder brings a new array of features supporting rapid Web application development on IBM i. CNX will announce today at the RPG/DB2 Summit the release of V3.1 of the Valence ...
- Created on 26 March 2012
- 1557. Update Your Data with Peace of Mind Using Commitment Control
- (RPG)
- Learn how to use commitment control in your RPG programs to ensure a complete transaction and how to roll back the changes when unable to complete. Written by Tom Snyder I'm usually talking about powerful ...
- Created on 21 March 2012
- 1558. The API Corner: More on UNIX-Type Time Values
- (APIs)
- ... answer the specific question, "Does anyone know how to convert the time values that are returned from the stat() IFS api for an IFS file?" Two possible solutions were reviewed: using RPG timestamp support ...
- Created on 21 March 2012
- 1559. Cluster Domino on IBM i Servers on the Same Box!
- (Collaboration & Messaging)
- ... out of the water. Personally, we run our RPG-based business applications, Domino for email/applications, IBM Quickr for document management, IBM Sametime Standard for instant messaging and Web meetings, ...
- Created on 14 March 2012
- 1560. TechTip: GPS Mode of the Geo Map Chart: Generate Professional-Grade Charts in Your Programs
- (APIs)
- ... GenMapGPSChart in QRPGLESRC/GENCHRT source member of the downloadable source code) follows the same line of GenMapChart, but only has a simple string as column title instead of a data structure and, quite ...
- Created on 08 March 2012
- 1561. Practical SQL: Using Old World Tools with New World Data
- (SQL)
- ... I/O or embedded SQL. What RPG does works, but it always seems a little unnatural to me. The best example of how to implement null indicators in embedded SQL was written several years ago by one of my longtime ...
- Created on 06 March 2012
- 1562. Cool Things: A Simple Utility for Sending HTML Emails on the IBM i
- (APIs)
- ... on the IFS to be used as the message body along with the list of recipient email addresses and the sender's name and email address. To simplify this process, I've created an ILE RPG program that handles ...
- Created on 01 March 2012
- 1563. ASNA Releases New Version of Wings
- (Development Tools / Utilities)
- V5.2 includes a feature for bulk modernization, additional RPG/DDS fidelity, and new features in the ASNA Emulator. ASNA has announced ASNA Wings 5.2, a new version of the modernization solution that ...
- Created on 29 February 2012
- 1564. Are Web and Mobile Apps Becoming a Challenge? Try a Modern Wireframe Tool
- (Development Tools)
- ... that RPG programmers generally could claim on their resumes. With the advent of Web services and mobile applications, as well as the increasing acceptance of Rational Open Access RPG Edition to help facilitate ...
- Created on 23 February 2012
- 1565. Lotus Domino Designer Now Supports Mobile Apps
- (Development Tools)
- ... tend to want developers with knowledge of several languages in addition to RPG. They typically want some exposure to, if not competency in, Java, HTML, and JavaScript. Designer employs an IBM technology ...
- Created on 16 February 2012
- 1566. Use Qshell Tools to Clean Up Your IFS Automatically
- (RPG)
- Create a useful RPG program to purge unnecessary files from your IFS. Written by Tom Snyder The year-end stuff is over, you've captured all your yearly snapshot data in their own files, and you're feeling ...
- Created on 14 February 2012
- 1567. The API Corner: Understanding and Using UNIX-Type Time Values
- (APIs)
- Learn how to format a returned value such as 1,329,293,701 to a fixed definition of days, months, years, etc. Written by Bruce Vining Earlier this month, over on the RPG Programming section of the ...
- Created on 14 February 2012
- 1568. Upgrading to 7.1: Nightmare or Dream Come True?
- (IBM i (OS/400, i5/OS))
- ... diverse i system, and one that is much harder to replace than an i that is just used to compile and run RPG programs. The Bottom Line The next thing they wonder is whether going to 7.1 (don't bother ...
- Created on 12 February 2012
- 1569. TechTip: The Geo Map Chart: Generate Professional-Grade Charts in Your Programs in Real Time, Part 3
- (General)
- ... implemented here in the OptionsBegin, Option, and OptionsEnd sections. As for the procedure itself, check the QRPGLESRC/GENCHRT source member of the downloadable code for GenMapChart. The first thing ...
- Created on 09 February 2012
- 1570. IBM DB2 Express-C Available Free in the Cloud
- (DB2)
- ... set of management tools and no limits on the size of the database. DB2 Express-C runs on Linux, Windows, Solaris, and Mac OS X. RPG developers who have been honing their skills learning PHP can effectively ...
- Created on 09 February 2012
- 1571. TechTip: Analyze Your Programs and Applications, Part II
- (System Administration)
- ... are counted by compiler type. There are two OPM programs in the libraries analyzed: one CLP and one RPG. But this analysis doesn't show whether the ILE programs use the ILE default activation group ...
- Created on 02 February 2012
- 1572. A Visual Guide to Cost-Effective Testing on the iSeries
- (Development Tools)
- ... an extract from the white paper "A Visual Guide to Cost-Effective Testing on the iSeries," available for download free from the MC White Paper Center. Managers and developers working with legacy RPG ...
- Created on 02 February 2012
- 1573. ASNA Announces First Two Cities in Spring Wings Education Tour
- (Certification / Training)
- Users will get hands-on Wings training using PCs and an actual RPG application. The first two U.S. cities in ASNA's free hands-on 2012 Wings workshops—"No Stinkin' Screen Scrapers Here" tour will be ...
- Created on 02 February 2012
- 1574. Prompted SQL DDL Creation
- (SQL)
- ... it doesn't matter what tool you use to add the data—SQL, RPG, Java, .NET, PHP, DFU, or your favorite file editor. You won't be able to put in bad data. This is a powerful way to ensure data validity at the ...
- Created on 31 January 2012
- 1575. The API Corner: Renaming and Moving Objects Doesn't Have to Be Difficul
- (APIs)
- ... CL command from your RPG application program under the covers. The Rename Object API offers flexibility above and beyond just renaming. In last month's article, Deleting Objects, we reviewed a ...
- Created on 17 January 2012
- 1576. TechTip: Bar Charts: Generate Professional-Grade Charts in Your Programs in Real Time, Part 2
- (General)
- ... to the percentages of each cell phone use throughout the "cell phone eras"). In order to accommodate these structural changes, the procedure GenBarChart (see QRPGLESRC/GENCHRT in the downloadable ...
- Created on 12 January 2012
- 1577. What Are the Differences Between DB2 for i and SQL Server SQL Syntax?
- (SQL)
- ... functions, procedures, and triggers (but not aggregates and data types) using languages such as COBOL, C, RPG, or Java. See, for example, the CREATE PROCEDURE (external) statement. Clustered Index Views ...
- Created on 10 January 2012
- 1578. Skip Marchesani Retires from System i Developer
- (Certification / Training)
- ... and producers of the RPG & DB2 Summit, has announced the retirement of founding member Skip Marchesani effective January 1. Marchesani earned his reputation as a leading authority in database best practices ...
- Created on 05 January 2012
- 1579. Practical CL: Extracting a Bit
- (CL)
- ... normally do in RPG Developer. Sometimes, you need to do things in CL without calling an RPG program. The situation is rare, but it happens. One case may be where you have to provide the source to the program ...
- Created on 03 January 2012
- 1580. Maximize the Abilities of the LDA
- (RPG)
- ... or built-in support of high-level languages (the IN and OUT opcodes of RPG, and the ACCEPT and DISPLAY statements of COBOL). Store pointers in a job's Local Data Area. The Local Data Area (LDA) ...
- Created on 03 January 2012
- 1581. TechTip: Pie Charts: Generate Professional-Grade Charts in Your Programs in Real Time, Part 1
- (General)
- ... ends with %/ is a variable name. The lines starting with /$ mark the beginning of a new section. In order to dynamically generate the proper HTML page with my data in real time, I created an RPG ...
- Created on 22 December 2011
- 1582. Zend Announces GA Release of Zend Server for IBM i 5.6
- (Programming Languages)
- ... The new XML Toolkit is based on standard technologies such as DB2, RPG, XML and PHP, and takes advantage of IBM i mechanisms such as standard DB2 connections, stored procedures, and RPG ILE. Fully PHP-based ...
- Created on 21 December 2011
- 1583. Using Binding Directories with Your Service Programs
- (RPG)
- ... contain a list of service programs or modules to bind to your program. Your RPG program can use this directory so that you don't have to specify all of this information when you compile your program. ...
- Created on 20 December 2011
- 1584. The API Corner: Deleting Objects
- (APIs)
- ... activity might include deleting those objects that have been created over the last 12 months and are no longer needed. In the past, if you wanted to automate such cleanup activities from, say, an RPG application ...
- Created on 20 December 2011
- 1585. Technology Focus: Keeping Tabs on Your Database Maintenance Tasks
- (IT Infrastructure - Other)
- ... processes needed to apply field changes to database files and RPG applications. By globally applying changes to DDS members and source files, this tool streamlines and shortens database maintenance projects. ...
- Created on 18 December 2011
- 1586. First Version of Eclipse-based Open Source EGL Development Tools Released
- (Development Tools / Utilities)
- ... because the EGL compiler and generator framework is open source, anybody (with the right skills) could build an RPG or COBOL generator. In the very near future (possibly V0.8), support for calling RPG ...
- Created on 13 December 2011
- 1587. TechTip: Analyze Your Programs and Applications, Part I
- (System Administration)
- ... How much lost or forgotten old RPG or CL do we have? What is the status of the "general review of all the ILE programs" project? He added, "I don't want a bullet-point listing. If you can ...
- Created on 08 December 2011
- 1588. IBM i Growth Up, Escape the Family with New Redbook on IBM i 7.1
- (General)
- ... to 7.1 relating to C/C++, ILE RPG, ILE COBOL, and CL. It also goes into OS enhancements for PHP on IBM i, including a discussion of Zend Server Community Edition for IBM i as well as the full Zend Server ...
- Created on 08 December 2011
- 1589. Practical SQL: UDFs and Service Programs, Part II
- (SQL)
- With a little creativity, SQL allows you to add a form of overloading to RPG that can really extend your toolkit. Written by Joe Pluta In the previous article in this series in this series, I created ...
- Created on 06 December 2011
- 1590. Want to Know All the MI Object Types Supported by Your IBM i?
- (RPG)
- ... pointer. Example ILE RPG program t175.rpgle below, which is provided by the open-source project i5toolkit, achieves the above-mentioned steps: /** * @file t175.rpgle ...
- Created on 06 December 2011
- 1591. TechTip: Let IBM i Apps Access Microsoft Access with Jackcess
- (Java)
- ... that the Java code is running on the IBM i and so uses a local JDBC connection. For i developers, the exportQueryResultToAccDB method can be revised so that it can be made available to RPG programs ...
- Created on 01 December 2011
- 1592. Technology Focus: Multiple Software Types Support Worker Collaboration on IBM i
- (Collaboration & Messaging)
- ... and deployment based on LANSA's multiple software-building products, as well as IBM i development languages such as COBOL, Java, and RPG. IBM Corporation Domino Designer Domino Designer is a development ...
- Created on 20 November 2011
- 1593. MC Press Online Launches New eBookstore
- (Channel News)
- ... RPG Business Intelligence Strategy Complete CL, 5th Edition Free-Format RPG IV Fundamentals of Technology Project Management IBM Business Analytics and Cloud Computing The IBM Data Governance ...
- Created on 20 November 2011
- 1594. TechTip: Exploring GeoNames Web Services, Part IV: Find Nearby Wikipedia Entries
- (APIs)
- ... to know what EndIf; (Note: You can find a fully working example in the QRPGLESRC/TST_FNWADD source member.) P_Latitude and P_Longitude are the input parameters, while P_WE_DS, P_NbrElems, ...
- Created on 17 November 2011
- 1595. Profound Logic Integrates Visual Designer with IBM Rational Developer Toolset
- (Development Tools / Utilities)
- ... graphical user interface platform based on IBM's RPG Open Access, the recent enhancement to RPG that opens it up to Web interfaces. The platform offers developers an easy, natural method to create connected ...
- Created on 17 November 2011
- 1596. New Manta Training Delivery System Available
- (Certification / Training)
- Manta's EasyTutor now offers support for all major browsers. The latest version of Manta Technologies’ presentation system, EasyTutor 7.0, is now available. The major enhancement provided by the new ...
- Created on 16 November 2011
- 1597. Features and Cautions of the Binding Language
- (RPG)
- ... The Code I will be reusing the code from a previous article, "How to Create, Compile, and Use Service Programs," that translates special HTML characters within a string. Here's the RPG code for the main ...
- Created on 15 November 2011
- 1598. Cool Things: Java Prototypes Made Easy
- (Java)
- Take the fast path to calling Java methods from RPGLE programs. Written by Mike Faust The ability to use Java classes from an RPGLE program can open up a whole new world of capabilities. One big reason ...
- Created on 10 November 2011
- 1599. Subfiles and Data Queues: A Perfect Combination
- (RPG)
- Provide your users with everything they've ever wanted in a subfile program. Written by Kevin Vandever Editor's Note: This article is an excerpt from the book Subfiles in Free-Format RPG published by ...
- Created on 08 November 2011
- 1600. Case Study: ASNA Wings: Re-imagining Modernization at INFOCON, Both Ways
- (RPG)
- Modernizing for a GUI doesn't mean you have to give up the power of RPG. Written by Thomas M. Stockwell Fueled by the talent of more than a dozen IBM RPG programmers, and an overall staff of 50, INFOCON ...
- Created on 06 November 2011