- 1901. BCD's Clover Now Imports, Displays Query/400 Report
- (Business Intelligence)
- ... graphs. Clover also has advanced reporting features to handle dynamic library lists, change management, prompting for runtime values for record selection and calling existing back end RPG programs or reports. ...
- Created on 01 May 2009
- 1902. BCD's Clear PATH Modernization Suite Gets Muchas Enhancement
- (Development Tools / Utilities)
- ... to bring existing RPG applications to the Web, develop new PHP or RPG Web applications, create real-time Web reports, distribute reports and documents, and control access to enterprise information. All ...
- Created on 01 May 2009
- 1903. Aldon and BCD Partner to Bring Robust ALM to Web Application Development for i Platform
- (Development Tools / Utilities)
- ... levels of process automation and efficiency to Web application development and modernization for the IBM i platform covering PHP and RPG-CGI centric projects. The partnership marks the integration of ...
- Created on 29 April 2009
- 1904. LANSA Announces the Fusion of Power and Productivity
- (Business Integration)
- ... platform or development language (C#, VB.NET, RPG, COBOL, LANSA, Synon, SQL, PHP). The result is zero duplication of business rules, tighter security, faster performance and more assured data integrity ...
- Created on 29 April 2009
- 1905. A Proactive Approach Is Needed to Address IBM's Legacy Solution
- (General)
- ... demanding Web-based applications and are unwilling to use green-screen applications. •· There's a lack of available team resources. According to customers, IBM offers too few green-screen RPG courses, ...
- Created on 26 April 2009
- 1906. The API Corner: Re-enable Disabled User Profiles
- (APIs)
- ... /copy qsysinc/qrpglesrc,escwcht dCPF1393 ds based(RplDtaPtr) ...
- Created on 13 April 2009
- 1907. Zend Releases Community Edition of Zend Server
- (Web Languages)
- ... comes with connectivity to a number of major databases, including DB2 for Windows and Linux, Oracle, SQL Server, and MySQL. While RPG developers may not be as proficient in Windows or Linux environments ...
- Created on 08 April 2009
- 1908. TechTip: Keyboard Shortcuts for Remote System Explorer (RSE)
- (General)
- We all love our keyboard shortcuts, and RSE has a bunch you probably don't even know about. By Susan Gantner If you use Remote System Explorer (RSE) as part of either WDSC or RDi to edit your RPG ...
- Created on 01 April 2009
- 1909. Practical Array Processing: Dynamic Arrays
- (RPG)
- ... DISK RENAME(STORES:RSTORES) Here is the file specification for the STORES database file. I created it using DDL, so the record format name is the same as the file name; RPG requires ...
- Created on 30 March 2009
- 1910. Streamline Searches with Dynamic SQL
- (SQL)
- Whether your applications are completely RPG/SQL-based or include processes written in languages such as Java or ASP.NET, dynamic searches are likely a key component. By Kevin Forsythe Are you ...
- Created on 21 March 2009
- 1911. Has Your System i Emailed Someone Today?
- (RPG)
- ... Procedures ExecCmd This very handy procedure is used to replace the call to the QCMDEXC API. It was created by the bright guys of the Free RPG Tools Web site, and it consists of the invocation of the ...
- Created on 17 March 2009
- 1912. The API Corner: Handling System Changes Automatically
- (APIs)
- ... the Event data parameter as there is no good reason to define and test our own data structure. The RPG data structure, which is found in member ESCWCHT of QSYSINC/QRPGLESRC, is shown below. This member ...
- Created on 17 March 2009
- 1913. Editorial Review Board
- (ROOT)
- ... and iSeries. Susan left IBM in 1999 to devote more time to teaching and consulting. She co-authored one of the most popular System i Redbooks ever, Who Knew You Could Do That with RPG IV? She and partner ...
- Created on 17 March 2009
- 1914. BCD Professional Services Group Gears Up for 2009
- (Development Tools / Utilities)
- ... as part of a Web application for a large transport company. This type of functionality would not be possible with an RPG CGI program." 5250 Application Modernization Presto, BCD's rapid green-screen ...
- Created on 13 March 2009
- 1915. OmniFind, Part I: Add Sizzle to Your SQL with OmniFind Text Search Server for DB2 for i
- (DB2)
- ... RPG and COBOL programs. However, the text indexes used by OmniFind are not to be confused with these traditional database indexes. For starters, they are not part of the DB2 for i database. The text indexes ...
- Created on 10 March 2009
- 1916. Integrated Web Services Server for IBM i
- (Application Servers)
- ... RPG or COBOL or any other language. Depending on your perspective, SOA means different things. From the business perspective, SOA is a set of services that a business wants exposed within the enterprise ...
- Created on 22 February 2009
- 1917. Designing a Sound Application Architecture Built for the Future
- (General)
- ... and the increased complexity of the underlying technology has reached a point where the old ad hoc approach to application development is no longer viable. Monolithic RPG or COBOL programs, which were ...
- Created on 22 February 2009
- 1918. The API Corner: One Approach to System Automation
- (APIs)
- ... d MsgDta likeds(ESCQWFM) /copy qsysinc/qrpglesrc,escwcht ...
- Created on 17 February 2009
- 1919. Centerfield Technology Smacks Recession with Double Grand Slam
- (Development Tools / Utilities)
- ... throw fast balls the rest of the game," Holm says. Whether you are using Microsoft's .NET technology, IBM's WebSphere, RPG with SQL, or an off-the-shelf ERP package, Centerfield can help ...
- Created on 10 February 2009
- 1920. Is IBM Making a Statement of Direction by Bundling the Zend Web Stack with IBM i?
- (Web Languages)
- ... the investment its customers have in RPG applications that run on the AS/400, or today's Power Systems. The company remains convinced that the Power Systems hardware running IBM i is still the best ...
- Created on 05 February 2009
- 1921. Zend Delivers Fully Integrated Web Solution on IBM i
- (Programming Languages)
- ... Larry Nies, President of NSC. "As a whole PHP runs faster, accesses the database quicker, and is easier for the RPG-minded developer to become proficient in, than other web languages (Net.data, CGIDEV2, ...
- Created on 05 February 2009
- 1922. Determining and Providing the Appropriate CCSID for an API, External System, or Language
- (RPG)
- What do you do when you need to convert back and forth between EBCDIC and ASCII? By Tom Snyder When dealing with systems other than the IBM i or communicating with languages other than RPG, you ...
- Created on 03 February 2009
- 1923. Managing IBM i PTFs in the New Millennium
- (IT Infrastructure - Other)
- ... broke" rule. This stopped being enough a while back. Right about the time that the system moved from essentially a closed system of RPG and a proprietary database and instead became a super-open ...
- Created on 27 January 2009
- 1924. The API Corner: More on Customizing Application Behavior for Each User
- (APIs)
- ... a new user of the RPG_DEVELOPER_MY_APPLICATION application. Today, we will look at how to combine the Update API with the Retrieve User Application Information API in order to provide application awareness ...
- Created on 20 January 2009
- 1925. TechTip: Change the User Profile for the Currently Running Job
- (Security - Other)
- ... current thread to run under the user profile specified by the handle. Note that I said "thread" not "job." But you cannot have multiple threads in RPG yet, so if you're only using ...
- Created on 15 January 2009
- 1926. Designing SQL Procedures and Functions
- (SQL)
- ... tasks when you're designing an application is deciding how to code each portion of the application. We can develop applications in CL, RPGLE, SQL, and a host of other languages. The capabilities of ...
- Created on 13 January 2009
- 1927. Rich UI Unleashed
- (Web Languages)
- ... relied on one another. In case you haven't seen the basic application, here it is: Figure 1: This is the Rich Internet Application (RIA) I built with EGL Rich UI and RPG. (Click image to ...
- Created on 11 January 2009
- 1928. Making the Case for a Database Administrator (DBA) on IBM i
- (DB2)
- ... to the DBMS via DRDA, ODBC, JDBC, or CLI, it is still SQL. At this point, you might be thinking, "Hey, we don't use much SQL. We use the traditional COBOL and RPG high-level language data access ...
- Created on 11 January 2009
- 1929. Practical Array Processing: Initializing and Sorting
- (RPG)
- Array processing has changed in RPG IV and has gotten significantly better. This article starts with the basics: initializing and sorting. By Joe Pluta Every computer language above the level of assembly ...
- Created on 06 January 2009
- 1930. Does Source Maintenance Need to Be So Difficult?
- (RPG)
- ... that this study was done using a leading source tool, Eclipse, to maintain Java, we in the RPG world should not feel particularly slighted if we have to answer "no." However, it is pretty easy ...
- Created on 06 January 2009
- 1931. Frank Soltis, Father of AS/400, Retires from IBM
- (Analysis of News Events)
- ... around the country. "In the lab, I was working with a couple of young engineers who put it together for me. I designed a machine, a computer system that directly implemented RPG. Now, at the time, I felt ...
- Created on 04 January 2009
- 1932. Dick Bains, IBM S/38 Giant, Dead at 64
- (Analysis of News Events)
- ... IBM iSeries/System i and became the basis for all of the Integrated Language Environment compilers, including RPG, COBOL, CL, C, and C++, and the backend intermediate code, W-Code, which is used throughout ...
- Created on 18 December 2008
- 1933. The API Corner: Customize Application Behavior for Each User
- (APIs)
- ... for another application. For STRMYAPP, the application ID will be RPG_DEVELOPER_MY_APPLICATION. The maximum length of the application ID is 200 bytes, and IBM suggests in the API documentation that certain ...
- Created on 16 December 2008
- 1934. Exploiting the IBM Express Runtime
- (Development Tools)
- ... vendors is the environment. Back in the day of the midrange, you could write an application in RPG or COBOL for the platform of your choice and be reasonably assured that it would run on any machine of ...
- Created on 09 December 2008
- 1935. Welcome to the New RDi-SOA
- (Web Languages)
- ... them directly into the language. In that way, EGL is very much like RPG and its implicit connection to the DB2 database, except that EGL does this same sort of encapsulation for the entire world of programming ...
- Created on 07 December 2008
- 1936. The Unglamorous Science of Software Maintenance
- (General)
- Big gains can be realized by focusing on what RPG programmers actually do. By Steve Kilner For the past few decades, while software development has traveled through a long list of new languages ...
- Created on 02 December 2008
- 1937. Take Control of DB2 for i Performance with V6R1 System i Navigator
- (System Administration)
- ... applications (for instance, RPG), then you'd need to check the last-used date. For a native application reading directly from a table, the SQL counts won't be incremented (Count = 0). Nevertheless, ...
- Created on 23 November 2008
- 1938. Practical Examples of Code Without Indicators, Part II
- (RPG)
- ... variables. Until the advent of named indicators, though, it was rather difficult to make full use of those capabilities in RPG programs. No matter how you sliced it, using an indicator meant at some point ...
- Created on 18 November 2008
- 1939. TechTip: Mapping a Network Drive from the IBM i
- (Networking)
- I showed you how to map drives to the IBM i; now I'll show you how to map drives from the IBM i. By Tom Snyder In my previous TechTip, I discussed the benefits and capabilities of mapping a ...
- Created on 13 November 2008
- 1940. Remote System Explorer: The Tool of Choice for IBM i Application Development
- (Development Tools)
- ... the currently selected call stack frame, as shown in Figure 1. If the mainline code of an RPG IV program is selected, this view shows all global fields defined for the program. If an RPG subprocedure is ...
- Created on 11 November 2008
- 1941. Getting the Message Using an SQL UDTF
- (SQL)
- ... indicate that either the data was read OK or the file is at end of file. Message File, Meet Message..."File" To make accessing message file descriptions easier, you'll take an RPGLE service ...
- Created on 11 November 2008
- 1942. Partner TechTip: Working with Embedded SQL Is Error-Prone and Messy. Is There an Easier Way?
- (SQL)
- Coding SQL within RPG or Java is time-consuming and tedious, but what if you could automatically generate SQL for RPG or Java in seconds? By Scott Salisbury As System i programmers, we are being ...
- Created on 11 November 2008
- 1943. Greg Schottland Appointed President of ASNA
- (Channel News)
- ... provides comprehensive solutions for modernizing System i applications to RPG on the Microsoft .NET platform. Using a staged approach, ASNA enables companies to integrate and extend their solutions to ...
- Created on 05 November 2008
- 1944. Avoid Record Lock Errors
- (RPG)
- ... that I discuss have probably been in use for 20 years or more and were given to me by veteran RPG programmers. Despite the fact that very easily implemented solutions have been around for such a long time, ...
- Created on 04 November 2008
- 1945. Is Working with the .NET Tribe a Secret to Surviving in Paradise?
- (DB2)
- ... within their .NET applications by using the LANSA Repository, the feature is not limited to only them. RPG and COBOL programmers can take advantage of having a central repository for these items to serve ...
- Created on 02 November 2008
- 1946. Partner TechTip: Creating Multilingual Software Doesn't Have to Be Scar
- (General)
- ... or people power? Does the task seem too daunting? There is more to it than changing your screens to message IDs. What about your RPG and CL programs? Internal printer files? Compile-time arrays? Constants ...
- Created on 30 October 2008
- 1947. 5 Essentials of Encryption Key Management
- (Compliance / Privacy)
- ... management system. Does your key management vendor provide example applications in Java, .NET, RPG, and other common languages? This will be crucial to the success of your key management strategy. ...
- Created on 26 October 2008
- 1948. 5 Reasons to Modernize Your Legacy Apps for the 21st Century
- (Enterprise Resource Planning / Financial)
- ... completely modernized system will have eliminated RPG/COBOL/CL/DDS dependencies within your application, which gives the applications platform mobility. Solutions may be deployed against IBM i, Windows, ...
- Created on 26 October 2008
- 1949. Using SQL in the Real World
- (SQL)
- ... base RDi product, although we've pleaded with IBM to do so. It seems to me that if you want to get RPG programmers off of the green-screen, you need to provide them with an alternative to STRSQL, and ...
- Created on 21 October 2008
- 1950. Practical Examples of Code Without Indicators, Part I
- (RPG)
- You've heard a lot about coding without indicators and perhaps even seen some code, but this article will show how the techniques can make you a better developer. By Joe Pluta RPG programmers ...
- Created on 14 October 2008