- 2051. TechTip: Move Your Compile-Time Arrays to the D-Specs
- (RPG)
- ... going to show you some clever D-spec tricks that will allow you to remove one of those remnants of old-fashioned RPG programming. A D-spec, or definition specification, is the specification we use to define ...
- Created on 18 December 2007
- 2052. i5/OS Offers Native XML Support in V5R4
- (IBM i (OS/400, i5/OS))
- ... hottest topics at conferences this year has been XML in general and, in particular, the native support added to RPG in V5R4. Demands for processing XML continue to grow in the System i arena, and as more ...
- Created on 20 November 2007
- 2053. Excel Program Inventions Announces New Release of Database Assistant
- (Development Tools / Utilities)
- ... Version 2.2 of Database Assistant can reduce typical RPG database maintenance projects by up to 80 percent, the company says. Database Assistant is a field-level change and analysis tool designed ...
- Created on 19 November 2007
- 2054. Putting Business Intelligence at Your Fingertips, Part II
- (Business Intelligence)
- ... or external stored procedures in one of the many languages supported by i5/OS, such as RPG, COBOL, C, C++, or Java. To support a process that involves capturing only changes (i.e., transactions) to ...
- Created on 13 November 2007
- 2055. Weaving WebSphere: IT Starts with an "i
- (Commentary)
- ... people using the tool. On the other hand, it doesn't bode well for niche technologies like VisualAge for RPG. The trend here is that tools will either be paid for by the marketplace (you and I), or they ...
- Created on 13 November 2007
- 2056. Aldon, a leading provider of process-driven application lifecycle management (ALM) solutions, has an
- (Development Tools / Utilities)
- ... Since its initial release years ago, WebSmart ILE has had a major impact on traditional RPG shops, and the System i market in general. In part, WebSmart ILE has been a big success because other products ...
- Created on 07 November 2007
- 2057. Partner TechTip: Track Changes to Remote Data
- (RPG)
- ... to data across all platforms. This new product gives developers full SQL access to remote databases from RPG, COBOL, or CL programs running on the System i. Using APIs to execute SQL queries, RDB Connect ...
- Created on 06 November 2007
- 2058. SQL Subselect: Soup to Nuts
- (SQL)
- ... from a primary file and use information from this record to do a single-record random retrieval (CHAIN in RPG, GET BY KEY in other high-level languages) to retrieve information from a secondary file. As ...
- Created on 06 November 2007
- 2059. Writing the Binder Language
- (RPG)
- ... look like for the CUSTPROCS service program used in the original example. STRPGMEXP PGMLVL(*CURRENT) EXPORT SYMBOL(GetCustInfo) EXPORT SYMBOL(SearchByPhone) EXPORT SYMBOL(ValidCust) ...
- Created on 16 October 2007
- 2060. ProData Announces RDB Connect for Data Integration
- (Database)
- The new product gives developers full SQL access to remote databases from an RPG, COBOL, or CL program on the System i.ProData Computer Services, Inc. has introduced Remote Database Connect (RDB Connect). ...
- Created on 15 October 2007
- 2061. IBM Suits Up i5/OS for Web Services
- (Commentary)
- ... administrative task. The integrated Web services server will work with code written in ILE RPG as well as the ILE versions of COBOL, C, and C++. An integrated Web services client for ILE—While the new ...
- Created on 14 October 2007
- 2062. TechTip: JavaScript Made Easy, Part II—Is Caps Lock On?
- (Scripting)
- ... have to copy it to your RPG-CGI program or PHP script or whatever else you wrote your Internet application in. The job is done, and Mr. and Ms. Clumsy will never waste your time on that subject again! ...
- Created on 11 October 2007
- 2063. Lotus Symphony Directly Targets Microsoft
- (Collaboration & Messaging)
- ... (the new word-processing document named New Document and the presentation WDSC for RPG Programmers) are both open in a tabbed view. If you've used WDSC, you'll be familiar with the concept of a ...
- Created on 07 October 2007
- 2064. Service Program Signatures
- (RPG)
- ... scenarios in a future issue of RPG Developer. Avoid Signature Violation Errors I hope this look inside service programs and their signatures has helped you understand the purpose of signatures and ...
- Created on 02 October 2007
- 2065. Taking the Initiative on Education
- (Commentary)
- ... teaching our first RPG class this fall. And we've done numerous introduction and development projects and classes on it. Now we're going to be able to expand that not in just some technical areas, ...
- Created on 02 October 2007
- 2066. Training the Cross-Platform Team
- (General)
- ... CASE tools generated code in high-level languages (HLLs) such as C or RPG. Later, the term "4GL" (fourth-generation language) was born, which meant specifically a higher-level language, which ...
- Created on 25 September 2007
- 2067. The Domino DB2 Debate: Why No System i DB2 Domino Data Store?
- (Commentary)
- ... accessed with traditional RPG, for obvious reasons. Forest for the Trees Were you to draw an analogy of how these two different directory services function, one might think of a deep forest of data ...
- Created on 16 September 2007
- 2068. Using i5/OS Commands
- (CL)
- ... CL Program DSP Display RPGPGM RPG Program WRK Work with MSGQ Message Queue STR Start OUTQ Output Queue END End ...
- Created on 11 September 2007
- 2069. Moving to Structured Software Change Management
- (Change Management)
- ... includes these elements: Auditing existing applications Documenting business rules Migrating RPG code to its more recent versions Merging development environments like native and Java This ...
- Created on 11 September 2007
- 2070. BCD's WebSmart PHP Is Ready to Rock 'N Roll after Four Months of Testi
- (Development Tools / Utilities)
- ... and Windows servers. Developers can also access multiple disparate databases as well as call existing RPG programs. Since the beta release of WebSmart PHP was first announced at COMMON last May, it ...
- Created on 11 September 2007
- 2071. All Dressed Up and Nowhere to Go
- (Analysis of News Events)
- ... recruitment and staffing firm and have been placing people exclusively in the IBM midrange arena since 1973, in the early days of RPG II and 96-column cards. I have seen many ups and downs in the economy, ...
- Created on 06 September 2007
- 2072. Centerfield Announces General Availability of HomeRun V6.0
- (Trends)
- ... The 6.0 release is focused on fully optimizing database indices (DDS logical files and SQL indices) in order to make SQL queries and RPG programs more efficient. Why just drive when you can hit the cruise ...
- Created on 29 August 2007
- 2073. Build Upon the Strengths of Your Legacy Systems
- (General)
- ... (e.g., RPG, Visual Basic) New programmers hard to find Reliable Hard to customize due to outdated or poor programming practices Good performance Finely tuned but difficult ...
- Created on 26 August 2007
- 2074. BluePhoenix Closes Deal to Acquire ASNA
- (Trends)
- ... developing visual programming and systems software for the midrange community since 1982. ASNA's, flagship product, "Monarch," is a fully-integrated solution for transforming RPG applications to the Microsoft ...
- Created on 26 August 2007
- 2075. TechTip: Start Using PHP on the iSeries...NOW! Part III
- (Web Languages)
- Calling native iSeries programs from PHP really leverages existing code. In Part I of this series, I showed how to install PHP on your iSeries and make sure it was functioning. In Part II, I walked though ...
- Created on 23 August 2007
- 2076. SOA on the System i: Moving into the Future
- (Analysis of News Events)
- ... R&D department and time to spend in investigations? And if this really works, does it work for System i shops like yours? What does it mean to your legacy applications developed in RPG and COBOL? And what ...
- Created on 21 August 2007
- 2077. Weaving WebSphere: Debugging a Running System i Job
- (Development Tools)
- ... I've done a little grooming of the debug perspective in WDSC to best accommodate RPG development. Note that I can see not only my breakpoints on the top, but also the contents of my variables as well as ...
- Created on 21 August 2007
- 2078. Northdoor Relies on LANSA to Launch System i Modernization Service in Britain
- (Channel News)
- ... RPG, .NET and Java skills and was recently selected to become a prestigious IBM Premier Partner. Users can obtain more information through Northdoor's System i seminars, details of which may be found at ...
- Created on 21 August 2007
- 2079. OCEAN User Meeting to Be Held Aug. 21 in Costa Mesa, Calif.
- (Channel News)
- ... your Java database handler work with your RPG programs. So don't struggle with complicated APIs or cumbersome data transfer techniques. Come to the August OCEAN User Group meeting and learn about a technique ...
- Created on 16 August 2007
- 2080. Play Time = Productive Time?
- (General)
- ... that encourage you to explore new ideas and techniques. Generating XML Some time ago, when I first became interested in XML, I wrote a number of RPG programs that generated XML documents. RPG IV's string-handling ...
- Created on 14 August 2007
- 2081. Essential Skills for System i Web Development, Part II
- (Web Languages)
- ... commercial development environments. Most of these exploit RPG as the primary development/generation language, but it is possible to write CGI-protocol-based code in most any ILE language, such as Cobol, ...
- Created on 12 August 2007
- 2082. TechTip: Start Using PHP on the iSeries...NOW! Part II
- (Web Languages)
- Let's look now at PHP scripts and functions. In Part I of this series, I covered how to install and configure PHP on your iSeries. Also, I touched a bit on how to access the existing DB2 databases. ...
- Created on 09 August 2007
- 2083. Best Practices: Cross-Platform Documentation
- (General)
- ... Business Rules in Legacy Code," addressed the idea of documenting business rules. It gave a specific example of documenting business rules for a free-form RPG program. While that was a helpful exercise, ...
- Created on 07 August 2007
- 2084. TechTip: SQLCOD End-of-File Gotcha
- (SQL)
- ... Application program SQL_DEMOR (Figure 1), lists all the promos that are active on a given date, in promo order. It employs the DOW SQLCOD = 0 construction, and I created it with the CRTSQLRPGI command, ...
- Created on 02 August 2007
- 2085. Feel Constrained!
- (SQL)
- Do you know how to handle RPG's key constraints, foreign key constraints, and check constraints? Oh, the times they are a changing! Slowly but surely, our systems are being opened up to multiple points ...
- Created on 31 July 2007
- 2086. System i Division Split into Two Business Units
- (Commentary)
- ... the platform. Where will the next generation of System i programmers come from if RPG slips again into the lexicon of "legacy application systems?" How will IBM Systems i skills be fostered? Indeed, the ...
- Created on 29 July 2007
- 2087. System i Division Split into Two Business Units
- (Commentary)
- ... the platform. Where will the next generation of System i programmers come from if RPG slips again into the lexicon of "legacy application systems?" How will IBM Systems i skills be fostered? Indeed, the ...
- Created on 29 July 2007
- 2088. CA Releases CA Plex r6 Rapid Application Development Environment
- (Trends)
- CA Plex r6 adds a code generator for C# to its existing code generators for Java, C++, RPG III, and RPG IV.CA has announced the availability of CA Plex r6, a state-of-the-art rapid application development ...
- Created on 29 July 2007
- 2089. TechTip: Start Using PHP on the iSeries...NOW! Part I
- (Web Languages)
- ... are great for getting started and have some really useful features to help experienced RPG developers make the switch to PHP. I would also recommend the Zend Studio for i5/OS; you can check it out at Zend ...
- Created on 26 July 2007
- 2090. Legacy Maintenance: Evaluating and Documenting Business Rules in Legacy Code
- (General)
- ... over the years that promise the ability to migrate your applications from one platform to an entirely different one. Some of them involve language-to-language migrating (RPG to Java is a popular one), ...
- Created on 24 July 2007
- 2091. Commonly Asked Questions About ILE Activation Groups
- (RPG)
- ... want or need to do so Q: Aren't all my RPGLE programs ILE programs?A: It depends on what options were used when the RPGLE programs were compiled. If the RPGLE source members were compiled with the Create ...
- Created on 17 July 2007
- 2092. ASNA Forms New Professional Services Division
- (Survey Results)
- ... migration of AS/400 applications to Microsoft .NET with ASNA Monarch. DB2/400 database conversion to Microsoft SQL Server. The Services Group will respond to ASNA customers' need to supplement their RPG ...
- Created on 17 July 2007
- 2093. TechTip: JavaScript Made Easy
- (Scripting)
- ... a weakness, and I'm looking forward to seeing you find it. See you in the forums!Jan Jorgensen is one of the founders of Flexware.dk, which specializes in i5 Web solutions. He works with RPG, HTML, JavaScript, ...
- Created on 05 July 2007
- 2094. COMMON Focus 2007 Educational Seminar Will Be Held Oct. 14-17 in Columbus
- (Channel News)
- ... to provide them with the opportunity to focus their educational needs on a specific topic each day. Workshops offered will include the following: Day 1 Disaster recovery primer Modernizing RPG applications ...
- Created on 27 June 2007
- 2095. Package Solution Integration: Modifying Package Solutions for the System i
- (General)
- ... themselves. Techniques for fixing modern ILE applications are much different from those required to fix older RPG III code. The techniques are so different, in fact, that many companies have a policy in ...
- Created on 26 June 2007
- 2096. Essential Skills for System i Web Development, Part I
- (Web Languages)
- ... know how to code them. For example, the System i supports subfiles, which are coded using a combination of DDS keywords and RPG programming. Implicit in some of those keywords is programming logic, already ...
- Created on 24 June 2007
- 2097. WebSmart PHP Beta Test to Commence with Help of System i and Other Developers
- (Development Tools / Utilities)
- ... PHP runs on top of Zend Core and supports all of its functionality. WebSmart PHP also comes with PHP snippets to make it easy to call RPG programs and modules from PHP. The 5,000-plus PHP industry functions ...
- Created on 21 June 2007
- 2098. Four! What It's Worth
- (Commentary)
- RPG Developer has a new team of authors! Take a look, and see what you can learn!You probably haven't given much thought to this, but did you realize that four is the only number in the English language ...
- Created on 19 June 2007
- 2099. WDSC Basics: Creating a Custom Perspective for IBM's WDS
- (Development Tools)
- ... studio, a compiler, an integration aid, and a test platform. It supports not only standard languages such as RPG and COBOL, but also Java, HTML, JavaServer Pages, and Cascading Style Sheets. The sheer ...
- Created on 19 June 2007
- 2100. Partner TechTip: WebSmart PHP Intelligent Templates
- (Web Languages)
- Wouldn't it be nice to get started with PHP without having to actually learn it?If you're like many RPG programmers, you've probably been looking for years for a simple means of creating Web applications. ...
- Created on 14 June 2007