- 2101. TechTip: Eliminate Indicators in Display Programs
- (RPG)
- Never use indicators...ever!I recently started a new consulting position, and the company I am working for now is using 20-year-old RPG code that has been modified over the years by developers with questionable ...
- Created on 14 June 2007
- 2102. Write for MC Press
- (General Content)
- ... in Figure 3. HDATFMT(*ISO) NOMAIN *=============================================================== * Compile Command * * Create Commands: CRTRPGMOD MODULE(library/CALCELAPSD) * SRCFILE(library/QRPGLESRC) ...
- Created on 13 June 2007
- 2103. Weaving WebSphere: Comparing the Web Languages
- (Development Tools)
- ... that I used the term "HLL CGI." This was deliberate, because although the vast majority of CGI work on the box has been in RPG, you could conceivably use any ILE language, including C or COBOL—or, ...
- Created on 10 June 2007
- 2104. TechTip: SQL Communications Area
- (SQL)
- Get more feedback on your SQL statements by using the SQL Communications Area.When RPG programmers begin to use SQL, one of the more difficult things for them to adjust to is that the SQL statements do ...
- Created on 07 June 2007
- 2105. System i Industry Experts Set to Speak July 16 at OCEAN Conference and Expo
- (Development Tools / Utilities)
- ... While there is a fee for the seminar, the expo is free and open to the public. Those expected to attend include RPG programmers, development managers, operations people, IT management, project managers, ...
- Created on 04 June 2007
- 2106. Can MySQL Become YourSQL?
- (Analytics & Cognitive - Other)
- ... for "OS/400 DB2" delivers even fewer pages: a mere 472 thousand. Further combined searches with words like "RPG AS/400" pares the number of returned pages yet further.) The cynics among us will note that ...
- Created on 03 June 2007
- 2107. When Are Web Services Right?
- (Web Languages)
- ... Communication Use FTP to send a file across the wire and then run a remote command (i.e. ftp>QUOTE RCMD MYCLPGM) to have an RPG program process the file. Flaw: Communication back to initiator can't ...
- Created on 24 May 2007
- 2108. Product Review: ADVANCED BusinessLink's Strategi SO
- (Product Reviews)
- Strategi SOA brings RPG and other System i languages into the service-oriented world, lifting the "legacy" label of their shoulders.Much has been made of the benefits of a service-oriented architecture, ...
- Created on 23 May 2007
- 2109. Instigating Change Within IT
- (General)
- ... developer who likes to stay on the cutting edge, utilizing the latest, greatest techniques and technologies. Maybe you're a strict RPG shop, but suddenly one developer learns Java and begins to create classes ...
- Created on 22 May 2007
- 2110. Using New Tools to Maintain Legacy Apps
- (General)
- ... actually go into the RPG code and try to separate database logic from screen I/O without introducing any errors. The former has serious performance implications, while the latter is nearly impossible to ...
- Created on 22 May 2007
- 2111. Time to Say "So Long
- (Commentary)
- ... field, I've written and published dozens and dozens of articles on RPG IV and System i. But I can see that it's time to move on. To keep things fresh, to keep things evolving and moving forward requires ...
- Created on 15 May 2007
- 2112. Case Study: ADVANCED BusinessLink's Strategi webSTYL
- (Case Studies)
- ... One of the primary selection criteria was that the chosen solution had to be capable of modernizing legacy RPG application user interfaces without the need to significantly rewrite code. Getty also ...
- Created on 13 May 2007
- 2113. TechTip: Testing Stored Procedures
- (SQL)
- ... called from within SQL. On the iSeries, we can write stored procedures in RPG, SQL, CL, and more. Here is an SQL command that creates a simple stored procedure. create procedure yourlib/testproc (in file char(21)) language sql dynamic result sets 1 begin declare stmt char(50); declare c1 cursor for s1; set stmt = 'SELECT * FROM ' || file || ' ORDER BY 1'; prepare s1 from stmt; open c1; return; end ...
- Created on 10 May 2007
- 2114. Change Management and WDSC
- (Development Tools)
- ... to associate an RPG program with its display file so that when I promote one to QA, both objects get transferred. This situation gets even more complex when you start dealing with ancillary objects, such ...
- Created on 08 May 2007
- 2115. The Keyboard Is Mightier Than You Think
- (General)
- ... or RPG Forever. You get my point. Consider what executives in your company read—I mean professionally. You might want to consider reading The New York Times or The Wall Street Journal Online. And before ...
- Created on 06 May 2007
- 2116. BCD Announces WebSmart PHP for Robust System i and Multi-Platform Web Application Development
- (Development Tools / Utilities)
- ... existing RPG or other ILE programs. Intelligent Templates for DB2 SQL, My SQL and Record Level Access WebSmart PHP supports applications for the System i that use either DB2 SQL or record-level access ...
- Created on 02 May 2007
- 2117. Profound Logic Releases New Application Modernization Tool
- (Development Tools / Utilities)
- ... and produces standard HTML with no need for PC Clients, ActiveX Controls, or Applets. Once it is installed, you can modernize all of your RPG, CL, Cobol, menu, or i5/OS system screens. This is done by ...
- Created on 02 May 2007
- 2118. COMMON in High Gear
- (Commentary)
- ... data lives, it is where you make your living. Bob Cozzi is author of the best-selling The Modern RPG IV Language, Fourth Edition as well as RPG TNT: 101 Dynamite Tips 'n Techniques with RPG IV and is ...
- Created on 01 May 2007
- 2119. ADVANCED BusinessLink Announces Native System i SOA Middleware
- (Development Tools / Utilities)
- ... a leading developer of Web enablement, SOA, and mobility solutions has announced Strategi SOA, a native SOA framework for the System i that was designed for RPG or COBOL language developers. Other SOA ...
- Created on 30 April 2007
- 2120. TechTip: Making Static HTML Act Dynamic
- (Web Languages)
- ... if you grab the data and just pass it on to another HTML page using some more JavaScript? That should be possible. So I ended up with the following solution: Call an RPG CGI program with one parameter ...
- Created on 26 April 2007
- 2121. Debunking ESB (Enterprise Service Bus)
- (General)
- ... tangible can be done within six to eight weeks. Here are some key POC points to consider: SOA standards—Make sure the ESB supports Web services created from RPG programs or prototypes created from ...
- Created on 22 April 2007
- 2122. TechTip: Addressing the Issue
- (CL)
- ... fields, and the at sign (@) was nowhere to be found. The two small programs that are included with this article provided the finishing touches. RTVEMLRPG retrieves the appropriate data and formats that ...
- Created on 19 April 2007
- 2123. Open New Doors
- (General)
- Maybe you'll stay employed if you take the initiative to learn about the industry you're in.Are languages such as COBOL, RPG, C++ ,and even Java on their way out? It seems that application development, a ...
- Created on 17 April 2007
- 2124. Application Architectures
- (General)
- ... as a handheld device. At the same time, my business logic is written in RPG and maintained by RPG developers who can quickly react to changing business requirements. (I get a kick out of the whole notion ...
- Created on 10 April 2007
- 2125. Modernization Is Not Just for Applications Anymore
- (General)
- ... your company requires, and don't forget RPG and 5250! Ideally, you want to use only one language for all application development. Verify that you never have to leave the development environment for editing ...
- Created on 10 April 2007
- 2126. How to Get Out from Under an Obsolete Legacy Technology
- (General)
- ... can take maximum advantage of them as soon as possible. Languages On the System i, the languages that have traditionally been used most widely are RPG and COBOL. These were created in the late '50s ...
- Created on 08 April 2007
- 2127. Weaving WebSphere: What's New in WDSC
- (Development Tools)
- ... to the tool. Another gripe I hear about WDSC is the learning curve. Personally, I find that complaint to be a little bit lame. RPG programmers are some of the best and brightest programmers I know, ...
- Created on 08 April 2007
- 2128. TechTip: Sharing WDSC Projects Without CVS
- (Development Tools)
- ... you have, probably, are one to three traditional RPG programmers who have stepped a toe into the water of WDSC and who are only now starting to understand Web services, JavaBeans, and the like. These people ...
- Created on 05 April 2007
- 2129. OCEAN User Group Conference and Expo to Be Held July 16 in Irvine, California
- (System Administration)
- ... public. Speakers at the conference will include Bob Cozzi, Bob Tipton, Trevor Perry, Alison Butterill, and Scott Klement among others. Those expected to attend include RPG programmers, development managers, ...
- Created on 05 April 2007
- 2130. PHP: A Party Waiting for a Few Good Developers
- (Web Languages)
- ... requests are made. Critics of this approach claim that the interpretive nature of PHP results in performance issues, compared with using compiled programs such as RPG CGI programs. However, Zend also provides ...
- Created on 03 April 2007
- 2131. Best of Cozzi: Find and Replace
- (RPG)
- ... This issue includes a full-functioning procedure that performs a certain task and returns a value to the caller. The function that is performed is one that I've needed frequently in RPG, so I decided ...
- Created on 03 April 2007
- 2132. Best of Cozzi: Qualified Data Structures
- (RPG)
- ... it included what I would consider the most significant enhancement to RPG IV data structure support in history: qualified names. Qualified data structure names allow you to refer to the subfields ...
- Created on 03 April 2007
- 2133. Web Services for the Traditional Programmer, Part II
- (Development Tools)
- ... creating and testing a Web service for an RPG program or subprocedure: An RPG program or subprocedure to be called from the Web service WebSphere Development Studio Client (WDSC) (V6.0.1 or later) with ...
- Created on 27 March 2007
- 2134. Centerfield Technology Develops AutoDBA DB2 Optimization Tool
- (High Availability / Disaster Recovery)
- ... focus on fully optimizing database indices (DDS logical files and SQL indices); with the objective of making SQL and RPG programs that process large amounts of data much more efficient. "There are literally ...
- Created on 25 March 2007
- 2135. WDSC 7.0 Arrives
- (Development Tools)
- What's new and different?To much acclaim, IBM introduced a new version of its IDE for RPG, DDS, and CL programmers, stating that this new version deprecates SEU/PDM/SDA as well as the decade-old CODE Editor ...
- Created on 20 March 2007
- 2136. WDSC Advanced Edition
- (Development Tools)
- ... equivalent of SDA. You also get a lot more that justifies that fee, but if you want only Screen Designer, yikes! I'm sure IBM will have its hands full at RPG World and COMMON this spring with programmers ...
- Created on 20 March 2007
- 2137. Fresh Details Emerge on IBM Initiatives
- (Analysis of News Events)
- ... Diagram Component, a tool that lets users visualize ILE RPG and ILE COBOL applications and better understand their structure. In addition, many developers want WDSC standard edition to include a replacement ...
- Created on 18 March 2007
- 2138. WDSC 7 Arrives Amid Changes at IBM
- (Development Tools)
- ... not just from Bob Cancilla, but from everybody I talk to at IBM. At the same time, though, Bob assures me that RPG will not get short shrift and that, if anything, we will see even more development in ...
- Created on 18 March 2007
- 2139. TechTip: SQL and i5/OS Record Format Names
- (SQL)
- ... by non-SQL interfaces, such as RPG native interfaces, you need to consider the record format name generated by DB2. By default, the record format name for an SQL created table is identical to the table ...
- Created on 15 March 2007
- 2140. Two Firms Select looksoftware for System i Application Modernization
- (Trends)
- ... Web services and SOA are their future, and we can get them there without their having to change their RPG code." The looksoftware application vendor program is suited to any System i application vendor ...
- Created on 14 March 2007
- 2141. i5/OS, OS/400, and Daylight Saving Time (DST)
- (IBM i (OS/400, i5/OS))
- ... would say, "Who cares?" But Java is finally becoming relatively useful. I now use it to send email responses to people who register on the discussion forum at RPGIV.com/forum, and it works well. IBM' ...
- Created on 06 March 2007
- 2142. Min and Max
- (RPG)
- Where are these i5/OS built-in functions?Often, when I use an API or C runtime function in RPG IV, I need to pass the minimum of two or more values to the API or C function. So I end up doing this: ...
- Created on 06 March 2007
- 2143. February Brings Big Changes to System i Community
- (Analysis of News Events)
- ... to work with any syntax changes to RPG and other supported languages. None of this would be that terrible if IBM were to provide CODE users with a relatively painless migration path to a functional equivalent ...
- Created on 04 March 2007
- 2144. TechTip: The Sound of Soundex, a Working Example
- (SQL)
- ... give you a short overview of what you can achieve by reading on: An RPG CGI program will let you search a U.S. cities database using the SQL Soundex code (or the SQL Like code). Another RPG CGI progra ...
- Created on 01 March 2007
- 2145. Integrate Open-Source Applications with Your System i
- (IBM i (OS/400, i5/OS))
- ... the Jakarta POI project can be found on the project Web site. Open-Source Report Creation Most System i programmers are used to using RPG to create report programs. Today, many of us use translation ...
- Created on 27 February 2007
- 2146. Weaving WebSphere: Change Management in the Brave New World
- (Development Tools)
- ... had DDS, RPG, and CL. But even though some of us had COBOL and a few of us even had C, in general only a few languages made up any one application. And yet we still had problems getting things out the ...
- Created on 27 February 2007
- 2147. Harkins Audit Software Offers Free Trial Download of Program Audit Tool
- (Trends)
- ... Program-Audit (RTPA)-software-for-RPG productivity tool that allows all RPGIII and RPGIV programs in a source file to be audit enabled. The updated productivity tool now provides greatly enhanced full ...
- Created on 25 February 2007
- 2148. The Lost Art of Start Copy Screen (STRCPYSCN)
- (CL)
- ... In preparation for RPG World (May 21–23, 2007, in Las Vegas), I created PowerPoint presentations that include screen captures. For years, I used the output from STRCPYSCN in a program for the PC that ...
- Created on 20 February 2007
- 2149. Query 400 in 2007?
- (Commentary)
- ... to the iSeries/System i world. Bob is also the author of several books, including The Modern RPG IV Language and RPG TNT: 101 Tips 'n Techniques for RPG IV. He is also the producer of RPG World, an annual ...
- Created on 20 February 2007
- 2150. Software as a Service
- (Managed Services / SaaS / PaaS / IaaS)
- ... Science courses; the midrange world in particular is filled with programmers who originally came from the business side of the world. This is why many RPG and COBOL programmers are so effective; they are ...
- Created on 11 February 2007