- 2101. 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
- 2102. 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
- 2103. 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
- 2104. 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
- 2105. 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
- 2106. 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
- 2107. 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
- 2108. 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
- 2109. 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
- 2110. 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
- 2111. 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
- 2112. 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
- 2113. 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
- 2114. 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
- 2115. 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
- 2116. 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
- 2117. 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
- 2118. 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
- 2119. 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
- 2120. 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
- 2121. 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
- 2122. 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
- 2123. 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
- 2124. 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
- 2125. 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
- 2126. 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
- 2127. 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
- 2128. 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
- 2129. 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
- 2130. 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
- 2131. 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
- 2132. 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
- 2133. 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
- 2134. 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
- 2135. 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
- 2136. 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
- 2137. 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
- 2138. 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
- 2139. 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
- 2140. ProData Gives Away Free Tools to Academia
- (Trends)
- ... and RSP RPG Server Pages enables development of web applications. ProData is also announcing a challenge of their own. The æDBU ChallengeÆ contest encourages those working on the System i to submit ...
- Created on 11 February 2007
- 2141. Error-Checking C APIs
- (APIs)
- Retrieving the error message text isn't too complex. Using APIs is always an exciting opportunity with RPG IV. Apparently, IBM believes that providing prototypes and accurate data structures with meaningful ...
- Created on 06 February 2007
- 2142. Is It "System i," "i5," "System i5," or "iSeri
- (Commentary)
- ... Bob Cozzi is host of iSeriesTV.com, an audio and video podcast/netcast Web site dedicated to the iSeries/System i world. Bob is also the author of several books, including The Modern RPG IV Language ...
- Created on 06 February 2007
- 2143. TechTip: WebSphere MQ Administration with PCF
- (Development Tools)
- ... (STRMQMCSVR). The enclosed RPGLE program JYMONMQ is an example on how you can monitor queue manager, channels, and queue using PCF. This program accepts two input parameters and returns three output ...
- Created on 01 February 2007
- 2144. Weaving WebSphere: Is WDSC Worth It or Not?
- (Development Tools)
- ... What do you get for that? Well, what I'm not going to do is to recount all the capabilities of WDSC as a server-side development tool for RPG (and all System i languages) and as a powerful and full-featured ...
- Created on 23 January 2007
- 2145. TechTip: Automatically Refresh Web Pages
- (Web Languages)
- With RPG CGI and JavaScript, you can automatically update Web page information.Most of you have been in airports or train stations and seen the big screens that inform you that a plane or train is boarding, ...
- Created on 18 January 2007
- 2146. TechTip: Full Outer Joins on DB2 for i5/OS
- (DB2)
- ... Rochester. While in the CTC, he assisted customers with application design and development using RPG, DB2 for i5/OS, CallPath/400, and Lotus Domino. His current responsibilities include providing consulting ...
- Created on 11 January 2007
- 2147. Open-Source Technologies for Change Management Systems
- (Change Management)
- ... management for their legacy (RPG, ILE, etc.) applications along with their Java and Web applications. One of the main purposes for using a system like Subversion is to provide a means by which to deal ...
- Created on 09 January 2007
- 2148. PHP and V5R3 Are Groovy
- (Programming Languages)
- ... Steve Will, Whei-Jen Chen, and Alan Seiden. Finally, a web cast entitled "Why RPG programmers should care about PHP" will occur on February 14th. During this free web cast George Farr, iSeries Application ...
- Created on 09 January 2007
- 2149. Business Management Systems: The Integration Pitfall
- (Commentary)
- ... has always been its ability to integrate BMS solutions onto a single platform, using a single database technology (DB2), accessible by a robust high-level programming language (RPG). Today, the System ...
- Created on 07 January 2007
- 2150. TechTip: Spice Up Your Web Pages, Part Two
- (Web Languages)
- Add more cool features to the interface.In my last TechTip, I spiced up an RPG CGI program by adding colors and status messages, which made the Web page more user-friendly to look at and work with. This ...
- Created on 21 December 2006