- 1601. 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
- 1602. 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
- 1603. 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
- 1604. 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
- 1605. 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
- 1606. 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
- 1607. 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
- 1608. 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
- 1609. 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
- 1610. 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
- 1611. 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
- 1612. 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
- 1613. Use a Single Framework to Support Mobile Apps on Different Platforms
- (Development Tools / Utilities)
- ... at the conference). The more JT talked about RadPHP XE2, the more I began to see it as a tool that RPG and IBM i developers might find helpful. Before you begin to suspect I might be trying to sell ...
- Created on 04 November 2011
- 1614. ASNA to Celebrate 30 Years Serving the IBM Midrange Community
- (Channel News)
- ... for improved performance, and 400RPG, to provide RPG III-like power to RPG II. The company moved onto the AS/400 in 1988 with Activ8, the performance booster, and Extermin8, the AS/400's first interactive ...
- Created on 02 November 2011
- 1615. Practical SQL: UDFs and Service Programs, Part I
- (SQL)
- ... you with examples of integrating SQL with traditional RPG. In this article, we're going to focus on how we can use a service program to extend SQL and provide an essential feature that SQL is sorely lacking: ...
- Created on 02 November 2011
- 1616. Uncover the Secret of the Changed Object List (COL)
- (RPG)
- ... readable format of the timestamp value associate with the COL shown above, you may call an example RPG program provided by i5toolkit, t173.rpgle like the following: > CALL T173 x'951DF98FBA02E000' ...
- Created on 02 November 2011
- 1617. Move Over DB2, Here Comes Zend DBi
- (DB2)
- ... demand arrives, IBM will be there on the cloud for its IBM i customers, says Devine. Meanwhile, RPG developers-turned-PHP-aficionados stuck pretty close to the room at ZendCon where PHP evangelist ...
- Created on 28 October 2011
- 1618. IBM Releases Major Refresh of IBM i 7.1
- (Operating Systems)
- ... Native archive and un-archive API supports creating and restoring archive files, specifically .zip files. The integrated web services client for ILE is enhanced to enable users to generate RPG code ...
- Created on 24 October 2011
- 1619. Cool Things: WDSC with Context
- (Development Tools)
- Use context-specific prompting in WebSphere Development Studio Client to speed up your programming. Written by Mike Faust Have you ever forgotten the specific parameters required by an RPGLE function ...
- Created on 21 October 2011
- 1620. QuickLook: PlanetJ Web Object Wizard Community Edition (WOW CE) V7.0
- (Development Tools)
- ... by simply selecting a target database file. WOW applications are Web-based and can easily integrate with RPG for data access where desired. WOW CE requires Apache Tomcat or IBM WebSphere and can run on ...
- Created on 21 October 2011
- 1621. The API Corner: The Case of the Missing Stream Files, Part II
- (APIs)
- ... entries were previously returned, but not successfully processed, the OTHER operation will be true and the program will leave the current DOU. This last situation should not occur as only an RPG run-time ...
- Created on 20 October 2011
- 1622. Using Binding Language with Your Service Programs
- (RPG)
- ... of how to create a service program. The process of creating a service program is very similar to creating an RPG program, except that there's no need for a main procedure and you use a different command ...
- Created on 19 October 2011
- 1623. Technology Focus: Encryption and Tokenization
- (IBM i (OS/400, i5/OS))
- ... is an RPG-sourced payment card solution that directly connects to the Elavon acquisition system for global account servicing. Elavon provides end-to-end processing for all payment card, e-commerce, hosted ...
- Created on 17 October 2011
- 1624. Assess the Appropriateness of the iSeries/IBM i in Your Business
- (IBM i (OS/400, i5/OS))
- ... with the iSeries/IBM i platform, resourcing challenges are typically the culprit. An aging population of RPG programmers and system administrators means organizations need to be more proactive in maintaining ...
- Created on 10 October 2011
- 1625. The CL Corner: Getting Additional IFS File Information
- (CL)
- ... used to detect the use of conflicting parameter values when running the USEDIRPGM command. It had been my intent for this month's column to continue that discussion of validity-checking programs. However, ...
- Created on 07 October 2011
- 1626. ASNA Announces Upcoming U.S. ASNApalooza
- (Certification / Training)
- The event will feature 100 percent technical information and include sessions on .NET, Web, and mobile development, among other topics. ASNA has announced that its next U.S. ASNApalooza developer conference—ASNApalooza ...
- Created on 06 October 2011
- 1627. TechTip: Exploring GeoNames Web Services, Part III: Find Nearby Points of Interest
- (APIs)
- ... from GeoNames or OpenStreetMap about the maximum number of POIs the Web service returns. Finally, a quick look at the provided example in the QRPGLESRC/TST_FNPADD source member shows the usual orchestratio ...
- Created on 23 September 2011
- 1628. How to Create, Compile, and Use Service Programs
- (RPG)
- ... an article a few months ago about creating procedures called "Practical RPG: Prototyping for Productivity Through the Use of Subprocedures." I also wrote an article a short time ago about using static variables; ...
- Created on 21 September 2011
- 1629. The API Corner: The Case of the Missing Stream Files
- (APIs)
- ... information such what's shown below using the RPG DSPLY operation code. DSPLY Job QPADEV000F/VINING/095249 removed *STMF DSPLY MyMissingFile.txt DSPLY at 2011-09-04-11.11.14.734704 ...
- Created on 21 September 2011
- 1630. TechTip: Some Top Features from Java 7
- (Java)
- ... because they tend to threaten backward compatibility, and changes need to be made to avoid breaking existing code. For example, that's why the new opcodes in RPG have hyphens: no variables could have been ...
- Created on 16 September 2011
- 1631. CNX Upgrades Valence but Keeps Community Edition Free
- (Development Tools)
- ... and handles Unicode characters without issue, the company says. CNX is looking at expanding the functionality of the editor beyond just JavaScript to handle the back-end RPG code, but a decision on that ...
- Created on 09 September 2011
- 1632. Create an Auto-Extend User Space
- (RPG)
- Editor's Note: This article is an excerpt from RPG TnT: 101 Dynamite Tips 'n Techniques with RPG IV. Written by Robert Cozzi The User Space is an interesting object. User Spaces have been around on this ...
- Created on 07 September 2011
- 1633. Cool Things: SQL Functions and List APIs
- (RPG)
- Two functionalities that work perfectly together. Written by Mike Faust One of my favorite programming techniques is linking together functionality to make even-more-powerful functionality. An example ...
- Created on 02 September 2011
- 1634. ASNA Presents Wings Half-day Workshops in Raleigh-Durham and Cincinnati
- (Development Tools / Utilities)
- Roger Pence to delve into Wings features and architecture, IBM's Open Access RPG Edition, green-screen to GUI modernization, and ASNA's view of the future of RPG and IBM i. ASNA today announced two ...
- Created on 31 August 2011
- 1635. ASNA to Hold Wings Half-day Workshops in Raleigh-Durham and Cincinnati
- (Certification / Training)
- Roger Pence to delve into Wings features and architecture, IBM's Open Access RPG Edition, green-screen to GUI modernization, and ASNA's view of the future of RPG and IBM i. ASNA today announced two free ...
- Created on 31 August 2011
- 1636. The CL Corner: Dependency and Validity-Checking of Command Parameters
- (CL)
- Today, we extend the USEDIRPGM command. Written by Bruce Vining In last month's column, "Clearing, Rather than Deleting, an IFS File," we implemented a CLRSTMF command. Today, we will start to incorporate ...
- Created on 26 August 2011
- 1637. Don't Be Misled by SETLL *LOVA
- (RPG)
- Be careful when using SETLL *LOVAL on keyed access paths containing numeric key fields. Written by Junlei Li Almost every RPG programmer has become accustomed to setting the file pointer to the starting ...
- Created on 17 August 2011
- 1638. The API Corner: Determining the Last Spool File Created
- (APIs)
- ... dWait s 1 /copy qsysinc/qrpglesrc,qsprilsp ...
- Created on 17 August 2011
- 1639. TechTip: Exploring the GeoNames Free Web Services, Part II: Country Info
- (APIs)
- ... For a simple RPG example, see the QRPGLESRC/TST_CINCOD source member. (You can find all the source code here.) The problem is that the input parameter is the country code, which you might not ...
- Created on 12 August 2011
- 1640. Building Mobile Apps with ToolboxME for iSeries
- (Java)
- ... skill set to accomplish the task as best you can, learn new skills, or defer and bring in an expert from outside who has different skills. One question an RPG programmer should ask is, do you really want ...
- Created on 12 August 2011
- 1641. Partner TechTip: Command Access Can Bring Unexpected Consequences
- (Security - Other)
- ... STRSQL commands on critical files. Prevent programmers from using CRTRPGPGM or CRTCLPGM commands to compile directly into a production library. And last, but certainly not least, for my CIO friend: ...
- Created on 12 August 2011
- 1642. IBM i Embraces Biometric User Authentication
- (IBM i (OS/400, i5/OS))
- ... used RPG programs to manage time and attendance. In one case, the employee provided an employee ID and a password to one of several workstations located on the manufacturing floor. In the other, employees ...
- Created on 08 August 2011
- 1643. OCEAN Tech Conference Sets Standard for Quality Training on a Budget
- (Channel News)
- ... the Systems and Technology Group, and Trevor Perry, chief strategist at Angus Thinks! Other speakers included Brian May of Profound Logic Software—RPG enhancements for IBM i 7.1, XML service, modernize ...
- Created on 03 August 2011
- 1644. Analyzing the MI Instruction Stream of an OPM Program
- (RPG)
- ... op-code-extender entry. Put It All Together Now let's exploit the techniques discussed above in a practical example. Assume that you have a compiled OPM RPG program called HELLO and you already have ...
- Created on 03 August 2011
- 1645. Power i Forecast: Smartphones and Mobile Apps, Part II
- (Development Tools / Utilities)
- ... Eamon Musallam Product Manager looksoftware Eamon Musallam: If you are considering extending your RPG- and/or COBOL-based IBM i applications for mobile devices, there are some basic ...
- Created on 01 August 2011
- 1646. Get Your System Humming: 7 Great Tips for Tuning DB2 for i
- (DB2)
- ... on the SQL-based data access interfaces. The SQL performance-tuning techniques are being emphasized because there is so much information already available on tuning the performance of RPG and COBOL programs ...
- Created on 25 July 2011
- 1647. Partner TechTip: Synon Rises Again
- (General)
- ... RPG applications on the IBM i struggle with how to comprehend their sprawling code and create a strategy for what, if anything, can be done to migrate it. These applications are full of proven business ...
- Created on 25 July 2011
- 1648. iTM - 2011/07/25 Advertorial
- (MC iTechnology Manager)
- See your system as you’ve never seen it Download your free 30 day trial Instant knowledge - 3 Minute videos: Extracting Your Business Rules Recovering Your Data Model Documenting ...
- Created on 25 July 2011
- 1649. TechTip: Cast Binary Data to Built-in Data Types
- (DB2)
- ... external function is written in a high-level language such as RPG, COBOL, or Java. Because the SQL language doesn't have great support for interpreting and manipulating binary data (the original problem ...
- Created on 22 July 2011
- 1650. iMap 3.0 Adds Intelligence to Mapped Forms Data from Spool and Database Files
- (Document Management)
- ... PCL into the RPG code of an application and every time someone wants to underline or boldface a word in a printed report, a programmer has to go in and change the code. That is what I call job security. ...
- Created on 22 July 2011