- 1451. Zend Announces Zend Server 6 for IBM i
- (Other Industry Solutions)
- ... IBM i Zend Server runs natively on the IBM i. It provides a fully supported platform for creating modern web and mobile applications that access the RPG/COBOL code, as well as business logic and the ...
- Created on 09 April 2013
- 1452. Profound Logic Releases Profound UI Version 4.5; Profound UI Framework Available as Open Source
- (Other Industry Solutions)
- ... open, native and secure modernization solutions to the IBM i community," states CEO Alex Roytman. "By making our Web 2.0 UI framework open source, we are enabling RPG developers to have more control over ...
- Created on 05 April 2013
- 1453. TechTip: Convert iSeries Spool Files to Enhanced PDF Documents using iPDF and iText
- (Document Management)
- ... for installing and using the iPDF APIs, and two demonstration programs are provided that show how the iPDF commands and APIs let you create PDF documents quickly and easily from RPG programs. iPDF ...
- Created on 05 April 2013
- 1454. LANSA to Unveil New Mobile Offerings at COMMON 2013
- (Networking)
- ... native mobile application builder for the IBM i. Using existing skills, LongRange developers code in RPG/COBOL and DDS to build sleek, high-performance native mobile apps that are deployed via the App ...
- Created on 04 April 2013
- 1455. Practical SQL: OLAP, Part 1
- (SQL)
- ... item. However, the next part is tougher: how do we use SQL to find all the cases where this has occurred? It would be relatively easy with an RPG program: read through the file by item and transaction ...
- Created on 03 April 2013
- 1456. Be Kind to Your DBCS Data
- (RPG)
- ... code of RPG would probably truncate the DBCS data in the source string and therefore lead to an invalid result character string. Learn how to ensure the validity of extended character string assignment ...
- Created on 03 April 2013
- 1457. TechTip: User Space Tricks That You Might Have Never Thought Of
- (General)
- ... look like this: find /qsys.lib/mysrclib.lib -type f -ctime -7 > /qsys.lib/mygpl.lib/oneweek.usrspc. Read the search result stored in MYGPL/ONEWEEK in an RPG program, parse the character lines, and write ...
- Created on 22 March 2013
- 1458. Weird, Simple Stuff in PHP: Operators
- (Web Languages)
- Yeah, they're sort of the same as in RPG…but not really. Written by David Shirey Over the last few articles, I have been on a PHP kick, talking about the language in general and how it integrates into ...
- Created on 20 March 2013
- 1459. The API Corner: Determining Key Values
- (APIs)
- ... /copy qsysinc/qrpglesrc,qdbrtvfd /copy qsysinc/qrpglesrc,qusec ...
- Created on 20 March 2013
- 1460. TechTip: Using Color in Printer Files on a Budget
- (Document Management)
- ... values can also be data fields with values supplied by an RPG or COBOL program. For those who would like to natively print a PDF with these features, once you have a PDF document, it is possible to convert ...
- Created on 15 March 2013
- 1461. TechTip: jQuery Fundamentals, Part III
- (Web Languages)
- ... jQuery APIs: the callback function. To understand the callback paradigm on a simple level, you must first understand how a browser executes JavaScript. I'll explain that by making a comparison to RPG. ...
- Created on 07 March 2013
- 1462. Convert Authority Special Values to and Back from MI Authority Bits
- (RPG)
- ... for the user to access the object; however, if the user has *EXCLUDE private authority to the object, object access will be prohibited. The following RPG example program (autbits01.rpgle) uses the ...
- Created on 05 March 2013
- 1463. PlanetJ Releases WOW 7.0.02
- (Other Industry Solutions)
- ... leverage their existing databases and RPG programming skills. WOW developers can also build applications that access information stored in MySQL, Microsoft Sequel Server, Oracle or any other JDBC compliant ...
- Created on 26 February 2013
- 1464. TechTip: Passing Parameters by Read-Only Reference
- (RPG)
- To improve the flexibility of your RPG coding, and to help protect the integrity of the calling program's data, learn to use read-only reference where appropriate. Written by Bryan Meyers and Jim Buck ...
- Created on 21 February 2013
- 1465. BCD's Presto 4.5 Makes It Even Faster to Modernize and Give Legacy IBM i Green-Screens a Web GUI ...
- (Other Industry Solutions)
- ... devices. It transforms all green screens (RPG and COBOL programs, menus, third party and system screens) to web pages without requiring any source code changes. Presto also gives you the most flexibility ...
- Created on 20 February 2013
- 1466. Enhance Your SQL Queries with User-Defined Table Functions
- (SQL)
- ... use repeatedly. Written by Jim Staton In my previous article, "Reuse Your RPG Code with SQL User-Defined Functions," I discussed how you could reuse RPG business logic in SQL by taking an RPG program ...
- Created on 19 February 2013
- 1467. The API Corner: Diagnosing Decimal Data Errors
- (APIs)
- ... is to replace our previous use of the RPG dsply operation code with a printer file. When the file being examined for decimal data errors might contain millions of records, a report listing the errors could ...
- Created on 19 February 2013
- 1468. Database Integration: Get Data from IBM i out and Other DBs In
- (DB2)
- ... the inherent database processing capabilities of DB2 for i and RPG IV. A recent and powerful development in the form of ROA (Rational Open Access for RPG), allows you to develop a device handler for any ...
- Created on 12 February 2013
- 1469. TechTip: Comments: The Good, the Bad, and the Ugly
- (RPG)
- Use these techniques to ensure that you're writing effective and appropriate comments in your RPG code. Written by Bryan Meyers and Jim Buck Editor's note: This TechTip is an excerpt from the book Programming ...
- Created on 31 January 2013
- 1470. ASNA announces Palooza 2013 in Barcelona, Spain
- (Certification / Training)
- ... notes on their common issues and challenges. The conference hotel in Barcelona this year is the Hoteles Catalonia. The theme for ASNApalooza this year is "RPG has never been so powerful." With ASNA' ...
- Created on 29 January 2013
- 1471. Investigating Mobile Development Languages
- (Development Tools / Utilities)
- ... have much in common except that they both came from the standard C syntax, which can be said about almost any popular programming language. OK, maybe not PHP. Or RPG. But you know what I mean. On ...
- Created on 22 January 2013
- 1472. Technology Focus: IBM i Web Application Building Tools
- (Development Tools)
- ... to venturing out of their green screen comfort zones and start learning techniques for Web development that are in use on just about all other platforms (for which RPG has a role, by the way). It depends ...
- Created on 20 January 2013
- 1473. TechTip: Installing Microsoft SQL Server 2012 Express on Your Local Machine
- (Microsoft)
- Expand your skills from the perspective of an RPG developer: Keep your IBM database close; keep your Microsoft database closer with Microsoft SQL Server. Written by Tom Snyder As a writer for MC Press, ...
- Created on 17 January 2013
- 1474. TechTip: Implement Your Own DLTOBJ Command via the Undocumented QLIDLOBJ API
- (APIs)
- ... times in the Midrange-L and RPG400-L mailing lists. That solution is the undocumented API QLIDLOBJ. The following post from Walden H. Leverich gave a brief introduction to the QLIDLOBJ API: RE: Object ...
- Created on 17 January 2013
- 1475. New Zend Toolkit: Part 2
- (Web Languages)
- Now, let's look at defining parms and calling programs. Written by David Shirey With the excitement of the holidays over, it's now time to continue with our review of how to call an RPG program from ...
- Created on 15 January 2013
- 1476. The API Corner: Detecting Decimal Data Errors
- (APIs)
- ... Machine Interface (MI) instruction. Similar to an RPG eval operation such as SomeNumber = AnotherNumber;, the CPYNV instruction can be used to copy a numeric value from a source variable to a target variable. ...
- Created on 15 January 2013
- 1477. TechTip: Starting at the Beginning with PHP Arrays
- (Web Languages)
- Learn about basic PHP arrays and how they're defined and looped. Written by Jan Jorgensen If, like me, you have begun to use PHP in conjunction with RPG, you'll very soon be using the arrays in PHP. ...
- Created on 10 January 2013
- 1478. TechTip: More Fun with Dates and Times
- (RPG)
- One trick in date/time arithmetic is learning to create and use durations. Written by Joe Pluta In the bad old days of RPG, dates and times were stored as pure numbers, and we had to work pretty hard ...
- Created on 03 January 2013
- 1479. New Zend ToolKit: Part 1
- (Web Languages)
- Forget about the old Zend Toolkit! Let's start using the new one. Written by David Shirey In my last column, I outlined how to call PHP and RPG programs from each other. I used as the basis for this ...
- Created on 18 December 2012
- 1480. The API Corner: In Search of Decimal Data Errors
- (APIs)
- ... can, assuming you store the source in QRPGLESRC as member FNDDDE, be compiled using this command: CRTBNDRPG PGM(FNDDDE) h DftActGrp(*No) ...
- Created on 18 December 2012
- 1481. TechTip: The %DIFF BIF
- (RPG)
- ... in your database using position 35 of the DDS specification. With the exception of dates, you specify the same type in the DDS as in your RPG program. Although you use type D for a date in a D-spec, for ...
- Created on 11 December 2012
- 1482. LANSA Wows Delegates at International Power 2012 Conference with Native Mobile App Builder LongRange
- (Other Industry Solutions)
- ... easily using only regular RPG skills. With LongRange there is no need to learn HTML, CSS, JavaScript or any other complex languages, or to add layers of overhead by embedding additional third-party frameworks ...
- Created on 11 December 2012
- 1483. How to Put IBM i Apps on Mobile Devices Without Getting a New Programming Degree
- (Development Tools / Utilities)
- ... a song in our pockets to announce that someone wants to talk to us, there's a need to put our IBM i apps there, too. But it's not so easy translating expertise with your trusty, server-based RPG or ...
- Created on 09 December 2012
- 1484. Simon's Solutions: Monitor for End Job Operations, Part I
- (RPG)
- ... via the SETIEXIT and CLRIEXIT MI Instructions For decades, the SETIEXIT instruction has been used in OPM RPG and OPM CL programs to register invocation exits. Issue a CRTRPGPGM or CRTCLPGM command with ...
- Created on 04 December 2012
- 1485. In the Wheelhouse: An IBM i Success Story That Needed to Be Told
- (Analysis of News Events)
- ... built with a backbone of rock-solid RPG and a PHP front-end. This week, I feel compelled to dissect a great IBM i customer success story. Plus, I'll fill you in about a new smartphone app for managing ...
- Created on 02 December 2012
- 1486. TechTip: Discover the Debug Built-ins of the IBM i System Debugger
- (General)
- ... nor calls to language-specific library routines or built-in functions (BIFs)—for example, RPG BIFs, COBOL intrinsic functions, or CL BIFs. Well, the IBM i System Debugger supports a number of debug built-ins ...
- Created on 29 November 2012
- 1487. InVue Security Products Safeguards Application Adoption By Modernizing with Profound UI
- (Other Industry Solutions)
- ... "screen-scraping" (Web-enabling 5250 data) they agreed that the best route was to modernize with RPG Open Access. This would enable them to add dynamic Web 2.0 capabilities to their application, with the ...
- Created on 28 November 2012
- 1488. CNX Announces Release of Valence Framework 3.2
- (Other Industry Solutions)
- ... developers can utilize the latest front-end components in conjunction with their server-side RPG programs. A complete list of included enhancements is listed in the Valence Framework Release History forum ...
- Created on 27 November 2012
- 1489. The API Corner: Processing the QLOCALE System Value
- (APIs)
- ... path value. This returned structure is common to many system APIs that work with IFS path names, is documented here, and is provided in member QLG of source file QSYSINC/QRPGLESRC as the data structure ...
- Created on 20 November 2012
- 1490. In the Wheelhouse: A Rose by Any Other Name
- (Analysis of News Events)
- ... years ago is still teaching RPG/400 programming on the curriculum. If I hired someone from that school, I'd have to have him or her unlearn many things that were a bit out of date when I graduated! Many ...
- Created on 18 November 2012
- 1491. Introduction to SQL, Part 1
- (SQL)
- ... is part of IBM i Navigator. In addition to interactive SQL, in which you type a statement on an SQL command line (similar to a CL command), you also can use SQL from within a C, COBOL, Java, or RPG program. ...
- Created on 13 November 2012
- 1492. Introducing LongRange University: Free, Easy Online Education for Developing Native Mobile Apps
- (Other Industry Solutions)
- Following the recent launch of LongRange, the first native mobile app builder for RPG developers, comes LongRange University, free online education for building stylish, high-performance Apple and Android ...
- Created on 12 November 2012
- 1493. Mobile Computing and the IBM i
- (Development Tools / Utilities)
- ... help it; we needed that GUI. Had to have the GUI. For many years, IBM talked up the importance of, among others, C, SmallTalk, Visual Age for RPG, OS/2 and the "polymorphic GUI," Java (remember the ad i ...
- Created on 11 November 2012
- 1494. PTM 2012/11/12 Advertorial
- (MC Power Technology Manager)
- Create superb mobile applications with RPG ASNA Mobile RPG (MR) empowers RPG programmers to create mobile applications with their traditional RPG skills. MR apps run on both Android ...
- Created on 11 November 2012
- 1495. How Much Storage Is Left in Your Main Storage Pools?
- (RPG)
- ... are defined in mih-stgrsc.rpgle (see below). The materialization template for option hex 2D consists of a base portion (defined by data structure matrmd_tmpl2d_t) followed by an array of up to 64 entries ...
- Created on 06 November 2012
- 1496. Bradley V. Stone
- (ROOT)
- ... applications using the AS/400 and RPG. Bradley is the Web administrator for Netshare400.com and provides AS/400 shareware and e-consulting services at BVS/Tools. He has also written many articles showing ...
- Created on 06 November 2012
- 1497. Developing Mobile Apps for the IBM i, Part II
- (Development Tools / Utilities)
- Let's continue our earlier discussion by looking at the Valence Framework, Sencha Touch 2, JavaScript, and RPG. Written by Scott Salisbury In the first installment of this two-part series, I described ...
- Created on 31 October 2012
- 1498. Cool Things: The Select STMF Utility
- (RPG)
- ... prompt the user to select the file to be processed. The utility is made up of an RPGLE program (SELECTSTMF) and a display file (SLCTSTMFFM). Figure 1 shows the main screen for SELECTSTMF. Take advantage ...
- Created on 26 October 2012
- 1499. The CL Corner: A CL Command to Scan for a String of Characters
- (CL)
- ... of 'a cabbage' is found within the list of searched-for values ('b', 'a', and 'g'). If you're familiar with the RPG %scan built-in, you'll notice that the SCNSTR command performs a very similar function. ...
- Created on 26 October 2012
- 1500. looksoftware Announces Astech UK Partnership
- (Mergers / Acquisitions)
- ... an established reputation for innovative IT solutions in the retail and public sectors, and with a large team of RPG and .NET specialists, are well placed to provide training and consultative assistance ...
- Created on 17 October 2012