- 1301. Case Study: HelpSystems' SEQUEL Data Access
- (Business Intelligence)
- ... users already use every day, even at home, has significantly reduced the learning curve for users. Increased IT Productivity In the past, Mayline developed reports using RPG. Not anymore. The reason ...
- Created on 26 September 2014
- 1302. You Want to Build Business Apps for Mobile Devices?
- (Development Tools / Utilities)
- ... operating system, like RPG or COBOL applications on IBM i, Java on Linux, or C# on Windows. Developers build native apps using languages including Objective-C (or Swift) on iOS, Java on Android, C# o ...
- Created on 24 September 2014
- 1303. 10 Reasons IBM i Developers May Want to Take a Closer Look at Microsoft .NET
- (Microsoft)
- ... on popularity calculated from various search engines. For November, C is #1 again, Java is at #2, PHP is at #6, and C# is at #5. COBOL has fallen a spot to #28, CL gets in at #65, and RPG ekes out a spot ...
- Created on 24 September 2014
- 1304. Technology Focus: Mobile Application Development Tools
- (General)
- ... web apps already have the skills necessary to move those apps to mobile. "With an HTML5 approach, an IBM i RPG team can build one mobile app that targets Apple, Android, or Windows 8 mobile devices," ...
- Created on 24 September 2014
- 1305. An Intimate Conversation About 5250 Emulation
- (Emulation)
- ... was part of the ASNA Wings RPG modernization product. But it has been so popular with ASNA users that they have encouraged the company to make the emulator available separately. What's really nice for small ...
- Created on 22 September 2014
- 1306. Installing Zend Server on the i: How and Why
- (Web Languages)
- ... Written by David Shirey PHP on the i. Why am I bothering to write about this? Mostly because I think we have reached a point where every RPGer and every IBM i should have some capability to do web-oriented ...
- Created on 17 September 2014
- 1307. Merger Gives IBM i Market a Fresche Look
- (Mergers / Acquisitions)
- ... RPG, COBOL, CA 2E (Synon) and CL - the primary programming languages on the IBM i. CIOs want to retain the value that this tried and true platform brings to their enterprise, but know they need to modernize ...
- Created on 16 September 2014
- 1308. In the Wheelhouse: The Question of Hiring IBM i Talent
- (Commentary)
- ... prototyped calls to other languages. The RPG curriculum is entirely RPG III, staying close to the Original Program Model. The databases are still created with DDS source. When someone says they know what ...
- Created on 15 September 2014
- 1309. TechTip: A Hidden Tax with SQL Programs and SQL Packages
- (SQL)
- ... The application programs in library APPOBJ are shared in common and can run against one of two data libraries: APPDATA and APPDATA2. A new embedded SQL RPG program called ORDERSR is introduced into ...
- Created on 12 September 2014
- 1310. The Transfer Ownership (XFRO) MI Instruction
- (RPG)
- ... Now, let's test the XFRONR program via the a tiny ILE RPG program xfronrt2.rpgle, which accepts the name of a user profile (user) and the name of an object (obj), and the 2-byte MI object type/subtype ...
- Created on 03 September 2014
- 1311. TechTip: Accessing Database Files in C and C++
- (General)
- Will there always be RPG and COBOL programmers? Learn how to access files natively using C and C++. Your application’s future may depend on it. Written by John Vriezen Google "Most popular programming ...
- Created on 29 August 2014
- 1312. inFORM Decisions Celebrates 20 Years of Providing IBM i Document Management Solutions
- (Document Management)
- ... RPG programmers, and "the maximum of my savings and credit cards," laughs Dan Forster, President, inFORM Decisions. Forster who has been at the helm since the company's inception, says the company ...
- Created on 27 August 2014
- 1313. Tackling IBM i Enterprise Key Management
- (IBM i (OS/400, i5/OS))
- ... 1,000 encryption operations in your RPG application, how many key retrieval operations are involved? Secure key caching can dramatically reduce the performance impact of a KMS on your system. IBM' ...
- Created on 25 August 2014
- 1314. Susan Gantner Shares New "Favorite RSE Keyboard Shortcuts" Tip Shee
- (Other Industry Solutions)
- Free download now contains Debugger shortcuts and tips. System i Developer, the consortium of top IBM i educators and producers of the RPG & DB2 Summit, today releases an expanded version of their ...
- Created on 22 August 2014
- 1315. TechTip: Protecting Against Accidental Updates with Masked Values
- (DB2)
- ... with a masked value. Consider a table containing three columns—first name, last name, and credit card number—that is read by an RPG program. The user running the program isn't authorized to see the ...
- Created on 22 August 2014
- 1316. The API Corner: Getting Directions Using Inquiry Messages
- (APIs)
- ... of the message, and so on. A definition of these fixed fields in format RCVM0100 can be found in QSYSINC/QRPGLESRC source member QMHRCVPM, so we also add the following /copy directive to AllocObj. /copy ...
- Created on 20 August 2014
- 1317. Top 10 Reasons Why Rails on i Is So Cool
- (Web Languages)
- ... the S/38's RPG development strategy—with things like subfiles and the world's first relational database—was standardized. And Midrange Computing was the bible for best practices. But the popularity ...
- Created on 11 August 2014
- 1318. The Atomic Add (ATMCADD) MI Instruction
- (RPG)
- ... values, respectively. The ILE RPG prototypes of these SYSBIFs can be found in mih-stgsync.rpgleinc as follows: /** * @BIF _ATMCADD4 (Atomic Add (ATMCADD)) * @return ...
- Created on 06 August 2014
- 1319. Security Patrol: V7R2 Security Enhancements, Part 2: Implementing Row and Column Access Controls
- (IBM i (OS/400, i5/OS))
- ... security is not usually enforced with the same rigor as on production systems. However, once again, careful planning and application testing is required. For example, RPG gurus Jon Paris and Susan Gantner ...
- Created on 18 July 2014
- 1320. TechTip: Biting the Bullet: Options for DB2 for i Automated Testing
- (DB2)
- ... test individual subprocedures in an RPG service program rather than try to test a behemoth monolithic OPM RPG program that has subroutines and variables that can't be isolated. The same holds true with ...
- Created on 18 July 2014
- 1321. The API Corner: Trying to Allocate an Object?
- (APIs)
- ... To compile AllocObj, you can use the command CRTBNDRPG PGM(ALLOCOBJ). h DftActGrp(*no) ...
- Created on 16 July 2014
- 1322. TechTip: Suggestions for DB2 for i Code Quality Testing
- (DB2)
- ... tools for traditional IBM I, so I'm going to lay out some ideas on how to approach writing unit tests for DB2 for i code. By extension, these concepts can be applied to HLL code such as RPG, COBOL, and ...
- Created on 11 July 2014
- 1323. The CL Corner: Still More Tools for the CL Developer
- (CL)
- ... 'bytes') The message displayed by the SndPgmMsg command is this: BytAvl contains up to 10 digits in 4 bytes A Note About RPG and CL Before we close, some caveats for those ...
- Created on 27 June 2014
- 1324. More Thoughts on Modernization
- (General)
- ... to present this page. Second Step: Control Module The next step is to develop a control module. If you're doing a GUI screen, I suggest using RPG. The first step in the testing can be to ensure that ...
- Created on 18 June 2014
- 1325. The API Corner: Problems Allocating an Object?
- (APIs)
- ... using the RPG DSPLY operation code, the first job found that prevented the ALCOBJ request from succeeding. Next month, we will extend this initial program to help automate recovery and/or problem determination ...
- Created on 18 June 2014
- 1326. TechTip: DB2 for i Impersonation Take 2: External Routines
- (DB2)
- ... few restrictions on this statement that can limit its usefulness. In this tip, I'll introduce some external SQL routines (written in RPG) that allow an application to override the user profile without some ...
- Created on 13 June 2014
- 1327. Modifying a Subfile: Change Is Good, Part 1
- (RPG)
- ... contain update, add, and delete capabilities. Written by Kevin Vandever Editor's Note: This article is an excerpt from the book Subfiles in Free-Format RPG. In this article, you'll learn one way to ...
- Created on 11 June 2014
- 1328. TechTip: Impersonate Your Neighbor Using DB2 for i
- (DB2)
- ... is not overridden by adopted authority. To illustrate, say application profile NOBLE has sole authority to IFS folder MyApp and its files. RPG program MYAPPIFS (written as an external stored procedure) ...
- Created on 06 June 2014
- 1329. Practical ILE: Building Your Service Program Library, Part 3
- (RPG)
- ... Creating a Service Program Remember that a service program is a collection of procedures. If you had only one procedure, you could theoretically just use an old-fashioned bound RPGLE program with a ...
- Created on 04 June 2014
- 1330. How Do I Know if Two Space Pointers Do Not Address the Same SLS Segment in ILE HLL Programs?
- (RPG)
- ... AND (pointer-A is NOT equal to pointer-B) Say ptra@ and ptrb@ are two pointer variables used as space pointers within an ILE RPG program. The if statement to tell that ptra@ and ptrb@ ...
- Created on 04 June 2014
- 1331. In the Wheelhouse: Are You Up for Sharing Your iThusiasm?
- (Commentary)
- ... groups, RPG groups, and depending on who you want to find and the success rate of getting the right answer, you have to post in all of them." How do we get the word out about our platform? Where ...
- Created on 02 June 2014
- 1332. 2014 OCEAN User Group Technical Conference Expands to Three Days
- (Certification / Training)
- ... DB2 Database Topics, Systems Management, and Strategic Directions. Of course the latest advances in free form RPG as well as Open Access will be taught as will "three approaches to Web with RPG," working ...
- Created on 30 May 2014
- 1333. Last Chance to Participate in the XML vs. DDS Survey for IBM i
- (Survey Results)
- On April 2, 2014, an article about OA invited all IBM i users to participate in a survey about enabling RPG to use XML rather than DDS for buffer compilation. On April 2, 2014, an article about OA ...
- Created on 28 May 2014
- 1334. Six Tips to Craft Your IBM i Mobile Application Strategy
- (Development Tools / Utilities)
- ... RPG programmers with little or no mobile development experience can create great departmental apps for you. Have realistic offline expectations. I've spoken to several IBM i executives who claim, ...
- Created on 28 May 2014
- 1335. The CL Corner: More Tools for the CL Developer
- (CL)
- ... parameter and is by far my favorite of the built-ins we'll review this month. The %char built-in, as you might guess if you're familiar with the ILE RPG %char built-in, converts data from one format to character ...
- Created on 23 May 2014
- 1336. What Is Modernization?
- (General)
- ... or one that impacts the bottom line. SQL Replacing RPG IO The second thing that people jump all over is using SQL instead of the "normal" RPG IO database interface. I don't blame them. SQL is ...
- Created on 21 May 2014
- 1337. The API Corner: Monitoring Data Changes within Your Database
- (APIs)
- ... d CalledAfter c '1' d CalledBefore c '2' /copy qsysinc/qrpglesrc,trgbuf ...
- Created on 21 May 2014
- 1338. Profound Logic Software Offers Multiple Display File Options with Profound UI Version 5.0
- (Other Industry Solutions)
- The latest release of the IBM i application modernization suite simplifies and expands the scope of RPG development projects. Profound Logic Software is proud to announce the release of Profound UI ...
- Created on 08 May 2014
- 1339. Practical ILE: Building Your Service Program Library, Part 2
- (RPG)
- ... date. The code is concise, but in fixed-format RPG that conciseness is sometimes overdone to the point of incomprehensibility. As an alternative, I'd like to show you what the free-form version of this ...
- Created on 07 May 2014
- 1340. Fresche Legacy Unlocks Enterprise Capabilities within X-Analysis
- (Development Tools / Utilities)
- ... extraction from RPG and COBOL – a key feature set previously available only in the product’s Enterprise Edition – is now available in the X-Analysis Professional Edition. This exciting new release is now ...
- Created on 06 May 2014
- 1341. Quadrant and BCD Software Unveil Improved Business Partner Program
- (Channel News)
- ... maximizing, modernizing and mobilizing their customer’s investment in the IBM i with RPG and PHP web applications, web GUIs for existing green screens and new RPG applications, mobile applications, web-based ...
- Created on 05 May 2014
- 1342. BCD Enhances Web Development and Document Distribution Tools
- (Document Management)
- ... company and an IBM i industry leader for over 38 years, has announced the releases of three of their web development and document distribution tools: WebSmart 10.2 for rapid RPG or PHP desktop and mobile ...
- Created on 05 May 2014
- 1343. TechTip: So What's in the TR8 Anyway? ...
- (General)
- ... article too. RDI Stuff As someone who has written several articles on free-form RPG D/F/H/etc. specs (oops, "control statements"), I am painfully aware of the fact that while this was supported i ...
- Created on 02 May 2014
- 1344. looksoftware Brings Open Access to COBOL
- (Other Industry Solutions)
- ... technological advantages of Open Access that has up until now been only available to RPG developers. Easy to learn and implement, unlimited power and capability looksoftware have architected ...
- Created on 01 May 2014
- 1345. Rational Development Studio for i 7.2 Continues to Deliver
- (Other Industry Solutions)
- ... per user and per system: IBM i Integrated Language Environment (ILE) Compilers, the current generation of compilers for RPG, COBOL, and C/C++ that are based on modern, cross-language technology ...
- Created on 01 May 2014
- 1346. IBM i 7.2: An Efficient, Resilient Platform for Business
- (Operating Systems)
- ... I/O capabilities including support for WAN over LAN Rational tools enhancements to support Free Format Report Program Generator (RPG) Support for the open source file serving ...
- Created on 30 April 2014
- 1347. Profound Logic Software to Announce Profound UI 5.0 at COMMON 2014 Conference in Orlando, FL
- (Other Industry Solutions)
- ... foremost in mind. In addition to Profound UI’s traditional support for RPG Open Access and Rich Display Files, the solution will: - Streamline the support for green screen display files alongside Rich ...
- Created on 29 April 2014
- 1348. Versions 9.1 of IBM Rational Developer for i and IBM Rational Developer for AIX and Linux
- (Other Industry Solutions)
- ... and Linux deliver significant new capabilities. Highlights include: Rational Developer for i: Enhancements to the basic development tools to support the expanded scope of RPG free-form ...
- Created on 29 April 2014
- 1349. ASNA Presents the 15th ASNApalooza Developer Conference in San Antonio, Texas
- (Certification / Training)
- The Palooza theme this year is RPG: Something for Everybody. The 15th ASNApalooza, ASNA's Developer Conference, will be held in San Antonio on October 20th and 21st this year. The conference hotel ...
- Created on 24 April 2014
- 1350. In the Wheelhouse: IBM i 7.1 Technology Refresh 8 Announced
- (Analysis of News Events)
- ... probably the next IBM HTTP Group PTF. Other software updates included in the IBM i 7.1 Technology Refresh 8 announcement are to DB2 on i and free-form RPG enhancements to Rational Developer for i ...
- Created on 21 April 2014