- 2001. The API Corner: Retrieving Information, Continued
- (APIs)
- ... surely there's a better way. And of course there is. This is not so much a "tip" about APIs, but rather a technique based on ILE RPG capabilities that can be applied to many situations, this being ...
- Created on 20 May 2008
- 2002. Partner TechTip: Get Productive with PHP and Java in Just Two Minutes!
- (Web Languages)
- ... theory and obtuse examples, I usually table it for another day, which ultimately never comes. SQL(snap) is a rapid development engine that generates Java and PHP (and RPG) based on SQL queries that ...
- Created on 20 May 2008
- 2003. V6R1 CL: The Story Continues
- (CL)
- ... or *BNDDIR. We can specify these, and more, on the DCLPRCOPT command within the source we are compiling. This capability to store compile options within the CL source is similar to ILE RPG's H-spec ...
- Created on 13 May 2008
- 2004. CNX Announces Release of Valence Web Application Framework for the System i
- (Development Tools / Utilities)
- ... tools necessary for System i shops to create rich Web 2.0-based browser interfaces with RPG, and includes an attractive tab-based portal for controlling user access to the applications as they're developed, ...
- Created on 12 May 2008
- 2005. BluePhoenix Reports Record Quarter, Expands Collaboration with Microsoft
- (Trends)
- ... VSAM to SQL Server, and from application languages such as COBOL, Natural, RPG and PowerBuilder to .NET. "BluePhoenix brings to the table its market leading automated migration tools and services, and ...
- Created on 12 May 2008
- 2006. SQL(snap) Eliminates the Burden of Messy Embedded SQL
- (Development Tools / Utilities)
- ... of V1.2 of SQL(snap), a rapid development engine that generates SQL for use in RPG, Java, and PHP. SQL(snap) removes the complexity and tediousness of working with embedded SQL, the company says, and provides ...
- Created on 02 May 2008
- 2007. COMMON Europe Announces 2008 Top-Concerns Survey
- (Channel News)
- ... in Barcelona, Spain, May 17-20. It will also host the RPG and DB2 Summit and have five parallel streams covering the new Power Systems, V6R1, security, database management and Linux. For more information, ...
- Created on 02 May 2008
- 2008. Partner TechTip: Embedded SQL Is Just Plain Messy. Is There a Better Way?
- (SQL)
- Coding SQL within RPG can be tedious, but what if you could automatically generate SQL for RPG, SQL for Java, and SQL for PHP in a just few clicks? by Scott Salisbury Have you ever avoided using ...
- Created on 01 May 2008
- 2009. Zend Deepens Interoperability of PHP with IBM i
- (Programming Languages)
- ... suite. "For the past two years we have been working with Zend to help i5/OS (IBM i) customers develop and deploy new Web applications that leverage their RPG applications and DB2 data," said ...
- Created on 30 April 2008
- 2010. SOA Governance: Better Now Than Never
- (General)
- ... piloted a supply chain application. The company used a SOAP engine inside the IBM Websphere Application Server (WAS) with Enterprise JavaBeans for the front-end and connections to an i5/OS RPG application ...
- Created on 27 April 2008
- 2011. EGL in 2008
- (Web Languages)
- ... and we should be looking at fully featured programming environments, and of those, there are really only two: Java EE and .NET. I'm not going to address RPG-CGI; if you choose that route, this is a completely ...
- Created on 22 April 2008
- 2012. Microsoft and IBM Play Nice
- (Web Languages)
- ... trend. It seemed that .NET technology was being been ignored or poorly covered at most of the seminars and educational sessions. RPG, Java, and PHP are great development languages, but if you don't ...
- Created on 22 April 2008
- 2013. TechTip: Replace Data Areas with Java Properties Files
- (General)
- ... the properties file isn't found. H Option(*NoDebugIO:*SrcStmt) H Thread(*Serialize) NoMain /copy Source,IFS_ToolsC /copy QSYSINC/QRPGLESRC,JNI **************************************************** ...
- Created on 17 April 2008
- 2014. Prototypes: For All Calls, All the Time
- (RPG)
- Utilizing the full capabilities of prototypes can make your life as a programmer easier and make your programs more bulletproof. By Susan Gantner With the use of free-format (aka /Free) RPG logic becoming ...
- Created on 15 April 2008
- 2015. The API Corner: Retrieving Information, Part II
- (APIs)
- ... /copy qsysinc/qrpglesrc,qwvrcstk /copy qsysinc/qrpglesrc,qwcattr /copy qsysinc/qrpglesrc,qusec ...
- Created on 15 April 2008
- 2016. looksoftware Makes It a SNAP to Plug System i Apps into Leading Front-Ends
- (Development Tools / Utilities)
- ... and open portals like Google. SNAP provides rapid integration of back-end RPG and COBOL with the business user's preferred front-end, thereby delivering streamlined business processes and reduced operational ...
- Created on 11 April 2008
- 2017. V6R1 SQL Query Engine Delivers on Its Promise
- (DB2)
- Learn how to prepare for the new DB2 for i5/OS query engine. By Jarek Miszczyk With V6R1 DB2 for i5/OS, the transition of SQL workloads from Classic Query Engine (CQE) to the new SQL Query Engine (SQE) ...
- Created on 08 April 2008
- 2018. BCD's WebSmart Presto Instantly Web Enables System i 5250 Applications with No Codin
- (Development Tools / Utilities)
- ... all RPG and COBOL applications. The new modern look with improved UI meet the requirements users and management are increasingly demanding. Web enabling is more cost effective and faster to implement ...
- Created on 07 April 2008
- 2019. S4i Acquires disk/HUNTER from Centerfield Technology
- (Mergers / Acquisitions)
- The move allows S4i to expand the capabilities of DASD-Plus to include real-time disk utilization monitoring. S4i Systems, Inc. has announced that it has entered into an agreement with Centerfield Technology ...
- Created on 07 April 2008
- 2020. New Products, Upgrades, and Enhancements Grace COMMON Expo
- (Analysis of News Events)
- ... over all RPG and COBOL applications. The solution completes BCD's ClearPath integrated modernization suite that also includes Web Smart PHP and Web Smart ILE, Clover Query, Smart Charts, Catapult, ...
- Created on 03 April 2008
- 2021. Calculate Begin and End Dates for Any Month
- (RPG)
- Need to calculate the dates of the first and last days of last month or any month? See how easy it is in RPG IV. by Sam Lennon It's fairly common that you need to calculate the dates of the ...
- Created on 01 April 2008
- 2022. V6R1 DB2 for i5/OS Highlights
- (DB2)
- ... combined. This support is similar to a derived key logical file. Note that an RPG program can use an index with selection using native I/O, but the program cannot use it in an SQL statement. ...
- Created on 18 March 2008
- 2023. The API Corner: Retrieving Information, Part I
- (APIs)
- ... /copy qsysinc/qrpglesrc,qwvrcstk /copy qsysinc/qrpglesrc,qwcattr ...
- Created on 18 March 2008
- 2024. ProData Releases DBU 8.0
- (Business Intelligence)
- ... DBU 8.0 is designed to complement other ProData productivity utilities for the System i and can be packaged with DBU Audit, DBU/RDB for remote DBU access, RDB Connect for remote access within RPG applications, ...
- Created on 17 March 2008
- 2025. Reliability and Simplicity Will Continue to Define the System i
- (Analysis of News Events)
- ... As to the future of RPG, Jarman acknowledges it is a "specialty language" in the eyes of younger IT professionals, but knowing RPG can be a great asset for a young programmer who also ...
- Created on 16 March 2008
- 2026. Introducing Eclipse Monkey
- (Development Tools)
- ... that for testing, and you can ignore it. Neither will you see the RPG__Fix_D_Specs.js file. That's mine, but that one we will talk about shortly. Anyway, this folder is built with several interesting ...
- Created on 11 March 2008
- 2027. CodeGear from Borland Now Offers Delphi/400 Tools for System i Modernization Projects
- (Development Tools / Utilities)
- ... development languages such as Delphi and PHP instead of RPG and COBOL. The Delphi/400 and Delphi/400 for PHP products are now available directly from CodeGear as part of its industry-leading developer ...
- Created on 10 March 2008
- 2028. Using Host Variables in Embedded SQL
- (SQL)
- Learn how to use host variables to get the most from your embedded SQL statements. by Adam Glauser In its simplest form, embedded SQL in RPGLE is not much different from the type of SQL you can ...
- Created on 04 March 2008
- 2029. Vendors Adapt to a Changing IT Market
- (Analysis of News Events)
- ... perhaps even an RPG routine) running on i5/OS. Considering the potential of this announcement, I would encourage those of you with Microsoft skills to play with the new protocols and then submit articles ...
- Created on 02 March 2008
- 2030. Large Sportswear Outfit Finds looksoftware Solution Highly Adaptable
- (Development Tools / Utilities)
- ... the world using 5250-based applications: acceptance of the customized RPG back-end was being hampered by its green-screen front end. There was also no apparent chance for easy integration with the Office ...
- Created on 29 February 2008
- 2031. The CL Corner: Incrementing a Numeric Value Across Jobs
- (CL)
- ... testing comparing RPG *DTAARA *IN and *OUT operations with a CMPSWP solution generating 10000 invoice numbers, CMPSWP was consistently in the neighborhood of 100 times faster (5 ms vs. 565 ms on my 515). ...
- Created on 28 February 2008
- 2032. Better Spool File Management Can Result in Big Savings
- (Document Management)
- ... WebSmart, and ProGen Plus. It's interesting to note that even WebSmart can be used together with Catapult to create a Web front-end to existing RPG report programs creating spool files. WebSmart brings ...
- Created on 28 February 2008
- 2033. COMMON Attendees to Learn How Web Services Can Complement Business Integration
- (Business Integration)
- ... and from IBM will deliver education on leading-edge System i technologies such as SQL, RPG IV, DB2 for i5/OS, Java, Lotus Domino/Workplace and many other technical topics. COMMON conferences have been ...
- Created on 28 February 2008
- 2034. Character Conversion APIs
- (APIs)
- ... like the horrible "set the second bit on for each byte found in the range of a to z" (as shown in Figure 1) or the minimally correct "use the RPG %xlate function" (as shown in Figure ...
- Created on 26 February 2008
- 2035. Weep Not, Loyal Users. All Things Must Perish, Even Remarkable Tools Like WDSc
- (Development Tools)
- ... an Eclipse-based IDE for traditional i5/OS development. It has edit, compile, and debug for RPG, COBOL, C, and C++ and virtually all the capabilities formally found only in WDSc AE. RDi includes Application ...
- Created on 21 February 2008
- 2036. The API Corner: Understanding API Data Types
- (APIs)
- ... or integer, field can be a source of confusion to RPG developers and is a common pitfall when first using APIs. The pitfall is that the RPG developer may code the parameter/field using a number of digits ...
- Created on 19 February 2008
- 2037. Centerfield Enhances Autonomic Features in Latest Release of HomeRun
- (Development Tools / Utilities)
- ... DDS logical files and SQL indices with the objective of making SQL and RPG programs that process large amounts of data much more efficient. With HomeRun V6.1, IBM System i shops get: Improved prioritization ...
- Created on 13 February 2008
- 2038. AD Repackaging in V6R1
- (Development Tools)
- ... OPM) compilers, and the Application Development ToolSet (ADTS). Each is separately priced and user-based. The ILE component includes all of the ILE compilers: RPG, COBOL, CL, even C and C++. The "heritage ...
- Created on 12 February 2008
- 2039. Could Your Productivity Use a Boost?
- (General)
- ... feel as if I am walking through mud; everything takes so long. These days, I'm not just an RSE user; I'm one of RSE's most devoted fans and supporters. That's why at the RPG & DB2 ...
- Created on 05 February 2008
- 2040. IBM Unveils i5/OS V6R1: A First Look
- (IBM i (OS/400, i5/OS))
- ... of other systems. Like i5/OS V5R4 before it, V6R1 comes packaged with an integrated Web services environment that makes it easier to expose RPG and COBOL as Web services. Also like its predecessor, ...
- Created on 03 February 2008
- 2041. Enhancements to V6R1 Include Better Availability, Security, Performance, and Search
- (IBM i (OS/400, i5/OS))
- ... more flexibility in how source code is organized and stored. With the support of variable scoping in the ILE RPG precompiler, RPG applications can more easily integrate SQL with current native database ...
- Created on 03 February 2008
- 2042. TechTip: Creating Functions to Get Day Names, Month Names, or Full Dates
- (General)
- Use SQL functions to create RPG functions. By Kevin Forsythe If you've been using SQL, you've probably noticed that there are many functions built into SQL that RPG doesn't have. We ...
- Created on 31 January 2008
- 2043. Profound Logic Software Releases Genie 3.0
- (Development Tools / Utilities)
- ... be downloaded from Profound Logic Software's web site (www.profoundlogic.com), and a video demonstrating the Genie Designer's capabilities can be viewed at www.profoundlogic.com/genievideo.rpgsp. ...
- Created on 30 January 2008
- 2044. PHP: What Can You Do with It on Your System i?
- (Web Languages)
- PHP takes you where RPG can't: into a world of heterogeneous operating systems running the same language. By Duncan Kenzie PHP is a highly productive programming language for developing Web ...
- Created on 27 January 2008
- 2045. Jazz Up Your Web Site by Customizing PHP Templates
- (Web Languages)
- ... Web development: 1. Approach it like writing RPG code with SEU: Write every page from scratch, probably by copying in common pieces of user interface code and business logic, tweaking areas of the code ...
- Created on 22 January 2008
- 2046. The CL Corner: Working with Bits
- (CL)
- ... such as RPG and C, provide direct support for this type of operation. Other languages, with CL and COBOL coming quickly to mind, do not. Traditionally, I've seen some rather convoluted coding in CL ...
- Created on 17 January 2008
- 2047. The API Corner: System API Basics
- (APIs)
- Are you as knowledgeable about APIs as you should be? By Bruce Vining While it seems reasonable to assume that anyone reading RPG Developer is quite familiar with RPG, not every reader may be as ...
- Created on 15 January 2008
- 2048. TechTip: Frame Crossing, Part I
- (General)
- ... same thing can be accomplished if you write everything in PHP or ASP, but that is not always my world. Very often, I have to write something in HTML and, for example, RPG. And this is where frames come ...
- Created on 10 January 2008
- 2049. %Handling XML-INTO Problems
- (RPG)
- ... of the XML support added to the RPG IV language in V5R4. In this second article, we will continue those explorations and look at some of the additional features of the XML-INTO opcode. The %HANDLER BIF ...
- Created on 18 December 2007
- 2050. Call-Back Processing: A Brief Introduction
- (RPG)
- ... the perspective of an RPG programming scenario where the technique might be applied: list processing. Suppose that we have a procedure (or even a called program) that we currently use to build a list of ...
- Created on 18 December 2007