- 1851. Navigate DB2 for i Through the SQL Server Galaxy
- (DB2)
- ... to how DB2 for i developers can create "external" stored procedures or functions in a high-level language (HLL) such as C, Java, RPG, or COBOL. With this in mind, it is possible to make available to T-SQL ...
- Created on 10 November 2009
- 1852. Aldon Fully Compatible with Zend Studio 7.0
- (Development Tools / Utilities)
- ... PHP to modernize their applications by creating Web-based interfaces to RPG programs and DB2 database files. Zend Studio provides powerful PHP editing and debugging capabilities, along with a myriad of ...
- Created on 10 November 2009
- 1853. TechTip: MySQL and PHP Are a Perfect Match, Part II
- (Web Languages)
- Putting MySQL under your PHP/AJAX hood really gives your apps horsepower. Written by Jan Jorgensen If you've read my last two tips, you should by now have installed an Apache Server running PHP and a ...
- Created on 05 November 2009
- 1854. The CL Corner: Retrieving Test Case Information
- (CL)
- ... you could enter the following command: DSPTSTCASE CMD(DONOTHING) As with the previous articles, here are the equivalent programs using RPG-like CL commands and the base run-time support. The ...
- Created on 29 October 2009
- 1855. Ross Mauri Outlines Next Release of IBM i
- (Trends)
- ... exploitation of solid state disk (SSD) technology to automatically move the most frequently accessed data to SSDs for higher application performance IBM Rational product enhancements to RPG-enable programs ...
- Created on 26 October 2009
- 1856. IBM Announces Interim Release 6.1.1 of IBM i
- (IBM i (OS/400, i5/OS))
- The company's statement of direction for Version 7.1 will affect RPG programmers, among others. Written by Chris Smith IBM announced an interim release of the IBM i operating system this week—6.1.1—and ...
- Created on 23 October 2009
- 1857. Practical SQL: Don't Be Afraid of Recursio
- (SQL)
- ... more generic application (say in an embedded SQL RPG program), you'd probably use a host variable to contain the seed value. The point is that this first SELECT statement gets the initial record(s) that ...
- Created on 21 October 2009
- 1858. The API Corner: Intercepting Inquiry Messages
- (APIs)
- ... /copy qsysinc/qrpglesrc,qmhrcvpm /copy qsysinc/qrpglesrc,qusec ...
- Created on 21 October 2009
- 1859. Technology Focus: CRM Is Putting the "Custom" Back in Customer Relationship
- (Customer Relationship Management)
- ... installation of SAP NetWeaver, the company's service-oriented architecture middleware package. Touchtone Corporation Wintouch eCRM www.touchtonecorp.com/wintouch.htm Wintouch eCRM is written in RPG ...
- Created on 19 October 2009
- 1860. TechTip: Are You Timing Your Dates Correctly?
- (RPG)
- UDATE may not be the right way to get the current date, but old habits are hard to break. Written by Sam Lennon When you need to put a date and a time together in your RPG IV program, be sure you understand ...
- Created on 09 October 2009
- 1861. Enhance Your CGIDEV2 Application with Calendar Integration
- (RPG)
- ... the starting date, ending date, current date, current time, description, and subject with variables. These variables will be populated in an RPG program. The RPG program REMIND1 will display a Web ...
- Created on 07 October 2009
- 1862. The CL Corner: Controlling the CL Testing Environment
- (CL)
- ... CRTCMD CMD(VINING/CHGTSTCASE) PGM(VINING/CHGTSTCPP) PMTOVRPGM(VINING/CHGTSTPOP) To change the test message for command DONOTHING in program MONESCAPE to CPF3012 (File &1 in library &2 not found), ...
- Created on 25 September 2009
- 1863. CL for Files (CLF) Solves Age-Old Problem of Poor CL Database Support
- (CL)
- ... administrators. It allows anyone who knows CL but may not know RPG, COBOL, or C, to create system maintenance utilities, application control programs, and test scripts without developer support. "CL ...
- Created on 25 September 2009
- 1864. Take Advantage of the Freebies at iSeries DevCon 2009
- (Analysis of News Events)
- ... means you must get into Web development. If you're not willing to learn a new language or don't have time, then you should get comfortable with RPG CGI. If you are willing to learn a new language but want ...
- Created on 21 September 2009
- 1865. Technology Focus: Knowing the Score with Testing Software
- (General)
- ... out there to help you test server-based RPG or COBOL programs. But there are a few. Please note that the following is merely summaries of a few important features of each product. You should consult the ...
- Created on 21 September 2009
- 1866. The API Corner: Validating Inquiry Message Responses
- (APIs)
- ... d JobNbr 264 269 /copy qsysinc/qrpglesrc,qmhrcvpm ...
- Created on 16 September 2009
- 1867. Revisited: Reliability and Simplicity Will Continue to Define the System i
- (Analysis of News Events)
- ... It is an interview with Ian Jarman, manager of IBM Power Systems Software, in which Jarman lays out the future of the Power Systems platform, including RPG and IBM i OS, as envisioned by IBM. We invite ...
- Created on 11 September 2009
- 1868. Practical SQL: More Dynamic Selection Criteria
- (SQL)
- ... data type (and its siblings, the time and timestamp data types), the i5/OS database took a huge step forward. And although RPG's acceptance was a little more grudging, we eventually got to where we are ...
- Created on 02 September 2009
- 1869. The CL Corner: A Much More Flexible SNDESCAPE Program
- (CL)
- ... using a language such as RPG or C, but as this is "The CL Corner," using CL seems more appropriate. Since CL does not have direct support for adding records to database files (and who wants to write an ...
- Created on 28 August 2009
- 1870. TechTip: Simulate One-Part Names for DB2 Web Query Synonyms over Stored Procedures
- (DB2)
- ... SQL in RPG), it can make use of user-defined functions or SQL views you have already created. If your shop has power users who were accustomed to creating their own Query/400 reports, you can develop ...
- Created on 21 August 2009
- 1871. Employment (and Unemployment) Take Center Stage at OCEAN
- (General)
- ... and don't be afraid to toot your own horn. In either case, go beyond just RPG and familiarize yourself with other technologies, such as PHP and Web Services. Langieri noted from an analysis he did of the ...
- Created on 21 August 2009
- 1872. Automate Your File Transfers Using FTP on the IBM i
- (RPG)
- ... which requires capabilities that you would need to use RPG for. At this point, you'd really wish that you had written the program in RPG, which is why we will be creating our program in RPG instead of CL. ...
- Created on 19 August 2009
- 1873. The API Corner: Beyond Watches
- (APIs)
- ... as RNQ0100, and it is proving very difficult to re-create the problem. Wouldn't it be nice to tell all the users to reply D (RPG formatted dump) if RNQ0100 is encountered when running that particular program? ...
- Created on 19 August 2009
- 1874. TechTip: PHP and AJAX, a Great Pairing
- (Web Languages)
- ... works in a similar manner to the select/case in RPG. So the correct information for the specified rate plan will be output, depending on which rate plan was passed in on the URL. Once you have all ...
- Created on 14 August 2009
- 1875. Leverage Existing Business Developers' Skills with EGL
- (Development Tools)
- ... applications. This is the chaotic environment that business application developers found themselves in. RPG programmers in particular were hard-pressed to become conversant in all of this new technology; ...
- Created on 10 August 2009
- 1876. TechTip: Meet the Local Tribes - Apache and PHP
- (Web Languages)
- Learn how to set up Apache and PHP to run on your local PC. Written by Jan Jorgensen This tip is a gamble. Either you'll dislike it so much you'll flame me on the Web or you'll nod your head and say, ...
- Created on 31 July 2009
- 1877. TechTip: Use a Stored Procedure as Your Data Source in DB2 Web Query for i
- (DB2)
- ... with the totals for the period being reported; others wanted information related only to period. The legacy reports that we were replacing were written in RPG and had no input parameters other than Month. ...
- Created on 24 July 2009
- 1878. TechTip: Use PHP and Zend_Mail to Send Email
- (Web Languages)
- ... right tool means knowing the strengths of each language in your toolbox. RPG does a lot of things extremely well, but email is not one of them. On the other hand, PHP handles email very well. The Zend_Mail ...
- Created on 17 July 2009
- 1879. Use a Logical File Layer to Minimize Recompiles from Field Additions
- (RPG)
- ... to avoid level checks. Each record format in an externally defined file has a format level identifier. When an RPG or COBOL program uses a format, the compiler saves the current format level identifier ...
- Created on 15 July 2009
- 1880. Use String Manipulation Built-In Functions to Process External Files
- (RPG)
- With the right RPG tools, you can make the most challenging data manipulation project fun. Written by Tom Snyder Dealing with interface files from external systems is always an involved exercise in data ...
- Created on 15 July 2009
- 1881. TechTip: Minimize DB2 Database Monitor Overhead
- (DB2)
- ... AS CHAR(1)) AS QQDSS , CAST(NULL AS CHAR(1)) AS QQIDXA , CAST(NULL AS CHAR(1)) AS QQORDG , CAST(NULL AS CHAR(1)) AS QQGRPG , CAST(NULL AS CHAR(1)) AS QQJNG , CAST(NULL AS CHAR(1)) AS QQUNIN ...
- Created on 10 July 2009
- 1882. IBM Rational Team Concert for i Now Supports Floating Licenses
- (Development Tools / Utilities)
- ... applications or modernizing existing applications using diverse, non-integrated development tools that isolate RPG/COBOL developers from Web/Java/Enterprise Generation Language (EGL) developers Adhering ...
- Created on 08 July 2009
- 1883. OmniFind, Part II: Integrating OmniFind Text Search Server with DB2 Web Query
- (DB2)
- ... Procedure! A stored procedure is really just a program object that is registered to the database. It can be written in the SQL procedural language or any supported IBM i language, such as RPG, COBOL, ...
- Created on 08 July 2009
- 1884. OCEAN User Group Extends Discount Rate for Coming Conference
- (Channel News)
- ... i and Power Systems infrastructure, and systems management. The application development track is subdivided into intermediate and advanced RPG and application modernization. The new career skills track ...
- Created on 02 July 2009
- 1885. Practical SQL: Archiving Data with SQL
- (SQL)
- ... in the article. You can use the new table anywhere the old table was used, including traditional RPG and COBOL programs. So, enjoy this technique; I think it's one of the most realistic uses of set-based ...
- Created on 01 July 2009
- 1886. The IBM i Programmer's Guide to PHP: Using Record-Level File Acces
- (Web Languages)
- ... resemble native file access on the System i. If you're used to using SETLL, READ, CHAIN, and UPDATE in RPG, you may find these data access methods more intuitive than other alternatives. We applaud this ...
- Created on 24 June 2009
- 1887. TechTip: Write Modular, Dynamic Code with Procedure Pointers
- (RPG)
- Rather than create multiple versions of code to do different things with data, this technique allows you to have only one copy of that logic. Written by Kevin Forsythe As we try to develop more modular ...
- Created on 19 June 2009
- 1888. Reusing a Single File Description on Multiple Files
- (RPG)
- Dynamically specify files in RPG without the use of embedded SQL. Written by Tom Snyder Do you have physical files with the same file format that are separated into multiple physical files--whether it ...
- Created on 17 June 2009
- 1889. The API Corner: Reorganizing Files Based on Percentage of Deleted Records
- (APIs)
- ... IGC 3 const options(*nopass) /copy qsysinc/qrpglesrc,qusrmbrd /copy ...
- Created on 17 June 2009
- 1890. 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
- 1891. 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
- 1892. 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
- 1893. 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
- 1894. 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
- 1895. 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
- 1896. The API Corner: Selectively Using RGZPFM on Files
- (APIs)
- ... /copy qsysinc/qrpglesrc,escwcht ...
- Created on 20 May 2009
- 1897. 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
- 1898. 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
- 1899. 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
- 1900. 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