- 1551. Practical SQL: Defining Your Data: TEXT and LABEL
- (SQL)
- ... the table has as its record format the name of the table. This is unacceptable in the RPG world (you need to rename the format in your F-spec in order to even compile a program with that file), and we ...
- Created on 02 May 2012
- 1552. Profound Logic Will Release Profound UI 4.0 at COMMON 2012
- (Other Industry Solutions)
- ... UI suite already gives IBM i users best-of-breed solutions for 5250 Web enablement and RPG application modernization,” he says. “With version 4.0, users will be able to extend the power of Profound UI ...
- Created on 01 May 2012
- 1553. Road Warriors Using Mobile Devices Can Now Sync Up to the IBM i
- (Development Tools / Utilities)
- ... the data back to a LOB application, said David Brault, product marketing manager. "The app lets data be captured on the device, moved to the IBM i server, and eventually tied back into RPG programs ...
- Created on 30 April 2012
- 1554. CA Plex Could Be the Best Development Tool of All, Reader Says
- (Development Tools)
- ... be near CA headquarters in Islandia, New York. Among the differences between CA Plex and CA 2E are that CA Plex employs a Windows-based visual IDE with GUI screen designers and generates RPG III and IV, ...
- Created on 27 April 2012
- 1555. Use Git to Document and Manage Any Source Code with Version Control
- (Linux / Open Source)
- ... an article called "Update Your Data with Piece of Mind Using Commitment Control." It showed a sample of using commitment control within RPG to ensure that a series of database transactions are committed ...
- Created on 25 April 2012
- 1556. Cool Things: Read dBASE Files Easily!
- (RPG)
- ... source member. dBASEprc—The prototypes for each of the subprocedures are stored in this source member. This can then be used with a /copy in RPGLE programs that are bound to the service program. ...
- Created on 20 April 2012
- 1557. PHP 1: What You Need to Know Before You Start
- (Web Languages)
- So you're a great RPG programmer. Is that enough? Maybe not. Written by David Shirey So, here you are, an RPG professional, all dressed up and ready to go. You can code up RPG real good, even some ILE. ...
- Created on 18 April 2012
- 1558. The API Corner: Accessing a Command Line
- (APIs)
- ... existing application, named DSPHI (Display Hi), using the display file (*DSPF) HI. Below is the DDS source for the HI *DSPF, followed by the RPG source for DSPHI. A R HITHERE ...
- Created on 18 April 2012
- 1559. looksoftware Announces Partnership with Mainline Information Systems
- (Mergers / Acquisitions)
- ... additional value to our customers. Mobile, cloud and RPG Open Access are three areas in which our customers continue to identify significant requirements, and looksoftware’s proven track record with each ...
- Created on 17 April 2012
- 1560. Technology Focus: Application Modernization Isn't Just Good for You, It's Getting Critic
- (Development Tools)
- ... "Application modernization" has come to mean many things, from simply improving the execution of RPG code (e.g., by translation of old code to RPG ILE), to adding a graphical UI to legacy apps ("screen-scraping"), ...
- Created on 16 April 2012
- 1561. System i Developer Debuts SQL-for-i Conference and Hands-On Workshops
- (Certification / Training)
- Proper use of SQL is key to releasing the value of IBM DB2 for i. System i Developer, organizers of the popular RPG & DB2 Summit, has opened registration for SQL for i Spotlight, a new hands-on technical ...
- Created on 13 April 2012
- 1562. DB-Gate Simplifies Access to Remote Databases from IBM i
- (Analytics & Cognitive - Other)
- ... record-level access to remote data using RPG, COBOL, or CL. The user uses RDB Connect APIs to execute SQL queries to access the remote data. Author and RPG programmer Scott Klement also has a solution ...
- Created on 13 April 2012
- 1563. 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
- 1564. 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
- 1565. 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
- 1566. 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
- 1567. 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
- 1568. 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
- 1569. 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
- 1570. 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
- 1571. 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
- 1572. 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
- 1573. 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
- 1574. 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
- 1575. 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
- 1576. 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
- 1577. 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
- 1578. 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
- 1579. 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
- 1580. 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
- 1581. 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
- 1582. 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
- 1583. 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
- 1584. 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
- 1585. 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
- 1586. 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
- 1587. 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
- 1588. 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
- 1589. 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
- 1590. 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
- 1591. 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
- 1592. 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
- 1593. 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
- 1594. 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
- 1595. 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
- 1596. 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
- 1597. 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
- 1598. 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
- 1599. 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
- 1600. 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