- 2501. Ten Simple Rules for Using Subprocedures
- (RPG)
- They're not laws, but maybe they should be.When it comes to building programs with RPG IV, storing the source in a single, large source member is no longer a viable programming practice. The use of subprocedures, ...
- Created on 28 October 2003
- 2502. Tips and Techniques: C Language Procedures
- (RPG)
- ... library available to RPG IV programmers. There are only two things you need to do to call any C language procedure. 1. Specify BNDDIR('QC2LE') on the header specification of the source member that will ...
- Created on 28 October 2003
- 2503. TechTip: Compiling an SQL Program
- (SQL)
- Here are four techniques to get the job done.There are a few ways to compile an SQL program in the ILE environment with special compiler parameters, such as ACTGRP:1. If the program is ILE RPG, you may ...
- Created on 26 October 2003
- 2504. Display File Fields Using Pointers
- (CL)
- ... structures that describe the sections of the user space and address some internal RPG control areas, the RTVINF utility program that retrieves database file key field information, the CRTUSRSPC command ...
- Created on 19 October 2003
- 2505. TechTip: Command Key Indicators
- (CL)
- ... indicator relate to the INKx indicator in RPG? For example, how does *IN03 relate to *INKC? I see programs where the programmer checks *IN03 after EXFMT. How do these indicators get turned on and off? ...
- Created on 19 October 2003
- 2506. Microsoft Computing: Measuring the iSeries Professional by the Microsoft Yardstick
- (Microsoft)
- ... for the group at hand. While talking to one iSeries programmer, I asked, "Are you an RPG programmer?" "I used to be," she replied. I asked her what she meant, and she indicated she had wholly embraced the ...
- Created on 19 October 2003
- 2507. Using Edit Codes
- (RPG)
- The QECCVTEC and QECEDT APIs simplify the process.Often, when I'm writing an application, I need to use an edit code. The RPG IV built-in function %EDITC is great for editing on the fly within the Calc ...
- Created on 14 October 2003
- 2508. Tips and Techniques: Miscoding Standalone Fields
- (RPG)
- Be careful with your D specs.There always seems to be an endless supply of oversights when writing code, and RPG IV is no exception. When I do code reviews, I often see the following problem in the Definition ...
- Created on 14 October 2003
- 2509. Weaving WebSphere: WDSci 5.1 First Look
- (Development Tools)
- ... for Java. Currently, though, the jLpex editors are still slower, and they occasionally crash or just get hung up. Free-format RPG in particular tends to make the editor a little flaky. In general, though, ...
- Created on 12 October 2003
- 2510. Using Dynamic SQL in CL: Part 1--Running Action Queries
- (SQL)
- ... IMMEDIATE can be used in an RPG program: D Order_No S 10I 0 D Inv_No S 10I 0 D SQL S 1024 Varying C Eval SQL='DELETE FROM Invoices ' ...
- Created on 05 October 2003
- 2511. Create *PGM Objects from Multiple *MODULE Objects
- (RPG)
- ... model. There are two very different ways you can create *PGM objects from multiple *MODULE objects. The first is to compile each source member independently of the other, using the CRTRPGMOD command, ...
- Created on 30 September 2003
- 2512. Tips and Techniques: Using LIKEDS
- (RPG)
- Create data structures that have the same subfields as previously declared data structures.With the advent of OS/400 V5R1, we can use the new LIKEDS keyword on the RPG IV Definition specification to create ...
- Created on 30 September 2003
- 2513. JavaScript: What, Why, and How
- (Java)
- ... for processing is similar to the dataflow of the EXFMT opcode of a typical RPG program as it communicates with a display file. HTML 101 HTML is the language by which servers and browsers communicate. ...
- Created on 28 September 2003
- 2514. Product Review: Crystal Decisions' Crystal Reports 9.0
- (Product Reviews)
- ... small tree waiting for distribution. And after all, what does the "R" in RPG stand for, anyway? (The answer is "report.") So, if AS/400 reporting capability is so extensive, why use a Windows-based product ...
- Created on 28 September 2003
- 2515. Product Review: Crystal Decisions' Crystal Reports 9.0
- (Product Reviews)
- ... the remnants of a small tree waiting for distribution. And after all, what does the "R" in RPG stand for, anyway? (The answer is "report.") So, if AS/400 reporting capability is so ...
- Created on 28 September 2003
- 2516. That Indestructible Black Box: A Testimonial
- (Commentary)
- Tomorrow's another day, so bring on the rain.It was a warm spring day in early May. I was with Jon Paris and Susan Gantner at the first RPG World conference in Orlando when my daughter Chrissy called me ...
- Created on 16 September 2003
- 2517. 5250 to the Web--A Primer for the Perplexed
- (Emulation)
- ... your IS staff have to learn? If you have only RPG programmers, depending on the type of solution you need, you may need to consider whether you want to spend the time and money to have them learn Java ...
- Created on 14 September 2003
- 2518. IBM Adds Options to iSeries Portfolio
- (Analysis of News Events)
- ... and 890 now include three new products: • The XML Toolkit for iSeries provides an interface to an XML parser that allows RPG, C, C++, and COBOL programmers to write applications that work with XML documents. ...
- Created on 14 September 2003
- 2519. TechTip: Remote SQL
- (SQL)
- It's as easy as 1-2-3.Do you work in a development environment with multiple iSeries that don't always have all of the SQL tools installed? Or have you ever felt like it would be so much easier if you ...
- Created on 07 September 2003
- 2520. Weaving WebSphere: WebSphere Express and Tomcat
- (Development Tools)
- ... RPG MOVE Debate." In it, I referenced some discussions I had on a mailing list, but I neglected to mention the name of the mailing list. Well, that list is the RPG400-L list, one of over a dozen lists ...
- Created on 07 September 2003
- 2521. See What's in
- (RPG)
- RPG programmers shouldn't limit themselves to only RPG.For years, I have been an advocate of taking advantage of what's available in a programming language. For example, the C language includes a number ...
- Created on 02 September 2003
- 2522. Tracking Triggers
- (RPG)
- ... unformatted states. F12 (Cancel) TRGTGEN The TRGTGEN command generates source code for a model trigger program.This is the syntax: TRGTGEN FILE() + PROGRAM() + SRCFILE(|*LIBL|*CURLIB/) + SRCMBR(*PROGRAM|) + LANGUAGE(RPGLE|CBLLE) + REPLACE(*NO|*YES) ...
- Created on 31 August 2003
- 2523. TechTip: Deleting All Records That Match a Key
- (RPG)
- ... delete capability of RPG: c dou not %FOUND(MyFile) c MyKey delete MyFile c enddo It's simple and straightforward, ...
- Created on 31 August 2003
- 2524. Architecting for Change--The Message-Based Server
- (Application Servers)
- ... my client program can proceed with a simple extract. Using RPG and embedded SQL, the syntax would be something like what is shown in Figure 2. select empnam, year(curdate()-empdob), year(curdate()-emphir) ...
- Created on 24 August 2003
- 2525. The Midrange Manager: The Return of the Application Backlog
- (RPG)
- ... little more aggressively. Author's Note: RPG World in Orlando was so well-received that Jon Paris, Susan Gantner, and I have scheduled a second one for November in Anaheim, California. RPG World is nothing ...
- Created on 19 August 2003
- 2526. RTVSQLSRC
- (CL)
- ... the API uses a data structure to identify the various flags and attributes you've specified to control the API. The data structure name is SQSR0100, and it's located in the QSQGNDDL source member in QRPGLESRC ...
- Created on 19 August 2003
- 2527. The Midrange Manager: What's in Your Budget for Next Year
- (RPG)
- Are you buying tools and utilities or creating them in-house?If an average, experienced RPG programmer is earning $65,000 (Midwest region with 7+ years experience), that comes to approximately $32.50 per ...
- Created on 05 August 2003
- 2528. The Linux Letter: Nuke It!
- (Linux / Open Source)
- ... For an iSeries shop, that equates to the original HTTP server (or the Powered by Apache Web server), DB2 for iSeries, and one or more of the languages available on the iSeries, such as Java or RPG IV. ...
- Created on 03 August 2003
- 2529. ASP.NET to iSeries Socket Server
- (Microsoft)
- ... value from the corresponding user profile. Figure 3 contains the ILE RPG source code for the socket server application. H DFTACTGRP(*NO) ACTGRP('QILE') BNDDIR('QC2LE') ***************************************************************** ...
- Created on 03 August 2003
- 2530. Variable-Length Fields
- (RPG)
- If it's efficiency you're after, here's where you'll find it.For decades, we've been using fixed-length character fields in RPG to store information. Every one of us has used these fields; it's virtually impossible ...
- Created on 22 July 2003
- 2531. The Midrange Manager: What's in a Name
- (RPG)
- ... xSeries. So eServer xSeries is the solution, right? So how do we move our old AS/400 RPG III applications onto a new xSeries box? Well, we don't. xSeries is a PC; yet for some reason, IBM believes companies ...
- Created on 22 July 2003
- 2532. TechTip: Using the QTMMSENDMAIL API
- (APIs)
- ... those of us who are predominantly RPG programmers are used to working with fixed field lengths and tend to be thrown off by variable field lengths and pointers. If you are familiar with C and/or C++ and ...
- Created on 13 July 2003
- 2533. Weaving WebSphere: Getting Started with WDSci
- (Development Tools)
- ... required fix packs 2. Installation, Phase 1: Base WDSci 3. Installation, Phase 2: Installing "classic" WDT (CODE and VARPG) 4. Installation, Phase 3: Applying the required fix packs 5. Downloading ...
- Created on 13 July 2003
- 2534. Let's Try to Avoid Using Subroutine
- (RPG)
- In RPG IV, think "subprocedures" instead.One thing that is surely ingrained in RPG programmers' heads is the use of subroutines. Hardly an RPG program exists today without subroutines (although I have recently ...
- Created on 08 July 2003
- 2535. The Midrange Manager: Playing in the Sandbox
- (RPG)
- ... in RPG since 1978. Since then, he has written many articles and several books, including The Modern RPG IV Language--the most widely used RPG reference manual in the world. Bob is also a very popular speaker ...
- Created on 08 July 2003
- 2536. Author Guidelines: How to Write an MC Press Article
- (General)
- ... * Create Commands: CRTRPGMOD MODULE(library/CALCELAPSD) * SRCFILE(library/QRPGLESRC) * ...
- Created on 06 July 2003
- 2537. Changing Object Ownership Generically
- (RPG)
- ... Bob Cozzi has been programming in RPG since 1978. Since then, he has written many articles and several books, including The Modern RPG IV Language--the most widely used RPG reference manual in the world. ...
- Created on 24 June 2003
- 2538. The Midrange Manager: More About Field Names
- (RPG)
- ... on. While we all have our own view on field names, a recent conversation on an RPG IV list server that I monitor spawned an idea that, at first, was simply a matter of taste. But truth be told, it's really ...
- Created on 24 June 2003
- 2539. TechTip: Calling the List Object APIs
- (APIs)
- ... To define the external data structure with RPG III, use the following input specification: I#CTRL E DSAPICTL Here is the code snippet you use to retrieve the Control section information; ...
- Created on 15 June 2003
- 2540. Abandon Response Indicators
- (RPG)
- ... requests to the RPG program. Traditionally, an indicator is assigned to the key when it is declared in the display file. An indicator is assigned by specifying the indicator within parentheses adjacent ...
- Created on 10 June 2003
- 2541. The Midrange Manager: Names Are Important
- (RPG)
- ... prefixing of field names. Ironically, the main reason I hear for using this is so that if you read one file and then another, the field's content is not overridden. Yet I see entire sections of RPG code ...
- Created on 10 June 2003
- 2542. TechTip: Upgrade Your JWSPLF
- (RPG)
- ... JWUSIDX, a reusable RPG module that allows you to easily manage user indexes and index entries with ILE/MI, which is the fastest access method--the same as using pure MI code. In addition, you'll find JSPLGET ...
- Created on 01 June 2003
- 2543. CALL or CALLB?
- (RPG)
- You've migrated your programs from RPG III to RPG IV. Now what?One area of moving to RPG IV always seems to cause people confusion: migrating two individual programs from RPG III to RPG IV and then deciding ...
- Created on 27 May 2003
- 2544. The Midrange Manager: Fostering a Sense of Unity
- (RPG)
- ... with the IT staff on a professional level, the barriers that have prohibited your staff from accomplishing their goals will begin to be broken. Bob Cozzi has been programming in RPG since 1978. Since ...
- Created on 27 May 2003
- 2545. TechTip: DATE-ing Advice for Query/400
- (RPG)
- Are you looking for an easier way to deal with those pesky date values?Love it or hate it, Query/400 is one of the most widely used reporting tools for OS/400. One of the big challenges that can face a ...
- Created on 18 May 2003
- 2546. Pointer Fields
- (RPG)
- What exactly are they, and how can you use them?A pointer is a type of RPG IV field, just like any other field. Pointer fields contain a specific kind of data that is interpreted as a memory address. Suppose ...
- Created on 13 May 2003
- 2547. The Midrange Manager: Program Templates
- (RPG)
- You're probably using them, but do you ever update them?I had an interesting conversation at RPG World earlier this month. The discussion was about shop standards, which led to questions about the benefit ...
- Created on 13 May 2003
- 2548. Weaving WebSphere: Version 5 Is Generally Unavailable
- (Development Tools)
- ... release. Version 2.1 of Eclipse just came out, and it's even better; I hope WDSc is upgraded to use the new version soon. 2. The LPEX editors advanced tremendously. The editors for RPG and COBOL are ...
- Created on 11 May 2003
- 2549. TechTip: Elapsed Time Function
- (RPG)
- If you're creating an application that has to calculate elapsed time based on a start and end time, you know what a challenging task this can be. Even with many of the date and time RPG op codes, this can ...
- Created on 04 May 2003
- 2550. Modules, Modules Everywhere
- (RPG)
- ... user space object that may be retrieved into any RPG program. Once the information is retrieved into RPG, you may of course do anything you want with it, including write it out to a database file. The ...
- Created on 29 April 2003