- 1601. 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
- 1602. 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
- 1603. 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
- 1604. 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
- 1605. 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
- 1606. 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
- 1607. 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
- 1608. 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
- 1609. 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
- 1610. 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
- 1611. 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
- 1612. 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
- 1613. 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
- 1614. 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
- 1615. 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
- 1616. 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
- 1617. 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
- 1618. 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
- 1619. 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
- 1620. 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
- 1621. 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
- 1622. 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
- 1623. 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
- 1624. 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
- 1625. 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
- 1626. The API Corner: Determining the Last Spool File Created
- (APIs)
- ... dWait s 1 /copy qsysinc/qrpglesrc,qsprilsp ...
- Created on 17 August 2011
- 1627. 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
- 1628. 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
- 1629. 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
- 1630. 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
- 1631. 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
- 1632. 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
- 1633. 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
- 1634. 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
- 1635. 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
- 1636. 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
- 1637. 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
- 1638. 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
- 1639. Does Your Shop Participate in Code Reviews?
- (General)
- Produce better code and exchange knowledge with code reviews. Written by Tom Snyder One of the most typical obstacles with the adoption of modern programming techniques in RPG shops is the fact that ...
- Created on 20 July 2011
- 1640. The API Corner: Just How Many Spool Files Do You Have?
- (APIs)
- ... /copy qsysinc/qrpglesrc,qspspli /copy qsysinc/qrpglesrc,qusec /free ...
- Created on 20 July 2011
- 1641. Power i Forecast: Smartphones and Mobile Apps, Part I
- (Development Tools / Utilities)
- ... the upcoming RPG & DB2 Summit October, 17-19 in St. Louis. Below are the questions we asked, and many are repeated further on along with their responses. I know there are others out there who also ...
- Created on 18 July 2011
- 1642. Technology Focus: Web App Construction Tools for Power Systems
- (Development Tools)
- ... that replace function keys. ASNA Monarch ASNA's Monarch Web-enables RPG-based applications by converting them to Microsoft .NET and optionally converts IBM i databases to SQL Server. Converted ...
- Created on 18 July 2011
- 1643. TechTip: Exploring the GeoNames Free Web Services, Part I: The Time Zone
- (APIs)
- ... of i5/OS, the fact that the closing of the status tag is "/>" instead of "" causes some problems, so a real error message might be misinterpreted as a malformed XML. In the examples provided in QRPGLESRC/TST_TMZADD, ...
- Created on 15 July 2011
- 1644. iTM - 2011/07/11 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 11 July 2011
- 1645. TechTip: Parse XML Data Using jQuery, Part 1
- (Web Languages)
- Demystify the noble art of reading XML data. Written by Jan Jorgensen Every day, the expectations of our skills are challenged. It is not enough to know RPG, DDS, and CL. Nowadays, we must also know ...
- Created on 08 July 2011
- 1646. TechTip: XLATE and Character String Manipulation
- (RPG)
- Manipulate and protect data quickly and easily. Written by Issak Brender There are many ways in modern RPG/RPGLE to manipulate data: BIFs, data structures, whole programs. This TechTip demonstrates ...
- Created on 01 July 2011
- 1647. The CL Corner: Using Command Parameter Lists, Elements, and Conditional Prompting
- (CL)
- More functionality extends the USEDIRPGM command. Written by Bruce Vining In last month's article, "Isn't Recursion Great?," we saw how a CL command can recursively invoke itself in order to provide nested ...
- Created on 24 June 2011
- 1648. TechTip: New in 7.1: The %SCANRPL Built-in Function
- (RPG)
- Replacing values has gotten a whole lot easier! Written by Steve Pitcher The new RPG IV built-in function %SCANRPL gives you the ability to scan a string for a value and then replace all occurrences ...
- Created on 17 June 2011
- 1649. The API Corner: So You Want to Know About Display Files
- (APIs)
- ... dSFLCtlFmt c x'20' /copy qsysinc/qrpglesrc,qdfrtvfd ...
- Created on 15 June 2011
- 1650. TechTip: Synchronizing Your LDAP Server
- (System Administration)
- ... and this tip shows you a simple command that can help you do just that. If you've never heard of LDAP, start here or you could refer to my recent article on accessing LDAP servers via RPG. If you'r ...
- Created on 10 June 2011