- 1901. Can the Right Tool Really Help Reduce System Maintenance Costs?
- (RPG)
- Modernization is one way to enhance the value of an application, but reducing back-end maintenance expense is a close second. Written by Chris Smith The trend toward modernization of RPG legacy systems ...
- Created on 12 June 2009
- 1902. Run SQL from a Source Member Using RUNSQLSTM
- (SQL)
- ... change slightly each time you run them, or maybe they're cleanup processes that you run on a regular basis and you can't justify the time dedicated to creating and debugging a full-fledged RPG program with ...
- Created on 03 June 2009
- 1903. Jobs Continue to Evaporate, but the Impact Isn't Felt Evenly Throughout Societ
- (Analysis of News Events)
- ... with a job have no clue. Those who are laid off can expect their search to last from three months to more than a year. When the jobs do start coming back, RPG by itself will not get an interview. If yo ...
- Created on 01 June 2009
- 1904. Rev Up "i" Reporting with SQL Server 2008 Reporting Service
- (Microsoft)
- ... click the Page button to move it to the Page section. · Group--The group section controls how the detail fields are grouped in the table. For RPG and COBOL folks, a group is synonymous with a control ...
- Created on 27 May 2009
- 1905. Book Review: The IBM i Programmer's Guide to PH
- (DB2)
- ... I was so excited to see this book that I didn't know where to start. Knowing that many RPG and COBOL developers struggle with the realm of object-oriented development, I went there first. I wanted to ...
- Created on 22 May 2009
- 1906. Installing IBM System i Access on Linux
- (Linux / Open Source)
- Follow these simple steps and avoid the gotchas! By Tom Snyder On my home computer, I am using Ubuntu Linux 8.10. Being an RPG programmer, I could not do this if I did not have a 5250 emulator to use. ...
- Created on 20 May 2009
- 1907. The API Corner: Selectively Using RGZPFM on Files
- (APIs)
- ... /copy qsysinc/qrpglesrc,escwcht ...
- Created on 20 May 2009
- 1908. TechTip: 5250 Emulator Alternatives for IBM System i Access on Multiple Operating Systems
- (System Administration)
- ... operating system...until recently. Now my primary desktop operating system is Linux. As you start integrating your RPG applications with other operating systems, you start expanding your expertise ...
- Created on 07 May 2009
- 1909. Use Advanced C Function to Find Distance Between Cities
- (RPG)
- ... use the cosine advanced math function. (For more information on cosine, just Google it.) We all know that regular RPGLE doesn't allow advanced math functions such as trigonometry, so we need to add ...
- Created on 04 May 2009
- 1910. Profound Logic Announces Atrium Enterprise Portal
- (Development Tools / Utilities)
- ... been opened. Atrium helps complete the Profound Logic modernization suite by providing users with a seamless way to integrate all their RPGsp Web applications, Genie-enhanced screens, and iData database ...
- Created on 04 May 2009
- 1911. Modest Attendance at COMMON Belies Underlying Energy
- (Analysis of News Events)
- ... to Web application development and modernization for the IBM i platform covering PHP and RPG-CGI centric projects." The partnership integrates Aldon Lifecycle Manager with WebSmart ILE and ...
- Created on 02 May 2009
- 1912. 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
- 1913. 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
- 1914. 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
- 1915. 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
- 1916. 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
- 1917. The API Corner: Re-enable Disabled User Profiles
- (APIs)
- ... /copy qsysinc/qrpglesrc,escwcht dCPF1393 ds based(RplDtaPtr) ...
- Created on 13 April 2009
- 1918. 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
- 1919. 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
- 1920. 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
- 1921. 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
- 1922. 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
- 1923. 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
- 1924. 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
- 1925. 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
- 1926. 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
- 1927. 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
- 1928. 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
- 1929. The API Corner: One Approach to System Automation
- (APIs)
- ... d MsgDta likeds(ESCQWFM) /copy qsysinc/qrpglesrc,escwcht ...
- Created on 17 February 2009
- 1930. 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
- 1931. 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
- 1932. 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
- 1933. 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
- 1934. 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
- 1935. 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
- 1936. 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
- 1937. 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
- 1938. 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
- 1939. 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
- 1940. 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
- 1941. 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
- 1942. 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
- 1943. 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
- 1944. 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
- 1945. 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
- 1946. 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
- 1947. 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
- 1948. 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
- 1949. 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
- 1950. 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