- 2501. Lotus Gets Its Workplace in Order
- (Analysis of News Events)
- ... technologies--such as RPG and Domino's Native Store Facility (NSF)--that limit their flexibility. Both platforms must migrate to industry-standard technologies if they are to integrate with today's distributed ...
- Created on 16 November 2003
- 2502. Microsoft Computing: Visual Studio--the .NET Interactive Development Environment
- (Microsoft)
- ... consider the iSeries programmer's plight. In an interactive iSeries application, there are typically a number of participants--some screen formats with source code in QDDSSRC, an RPG program with source ...
- Created on 16 November 2003
- 2503. CLLE's CALLPRC Comman
- (RPG)
- Now, it's easier to integrate RPG IV procedures with CL.One of the pieces of contemporary RPG is the ILE version of CL, or CLLE. Unlike RPG, however, CL didn't have a syntax change in the ILE program model. ...
- Created on 11 November 2003
- 2504. Tips and Techniques: Debug CGI Programs
- (RPG)
- ... 1. Compile the CGI program with DBGVIEW(*SOURCE or *LIST or *COPY). You already know how to do this. Use the CRTBNDRPG or CRTRPGMOD commands and specify the DBGVIEW keyword. 2. End the HTTP server. ...
- Created on 11 November 2003
- 2505. TechTip: 10 Really Helpful APIs
- (APIs)
- ... the ability to use pointers in RPG, some of the User Space APIs are pretty much obsolete--the Retrieve User Space API (QUSRTVUS) for example. With that said, I'll cut to the chase. Here is the ...
- Created on 09 November 2003
- 2506. Using Dynamic SQL in CL: Part 2--Retrieving a Data Value
- (SQL)
- ... useful. CL itself doesn't offer much help to deal with these types of issues. Because of CL's single-file limitation and poor key-processing ability, many an RPG program has been written to retrieve simple ...
- Created on 09 November 2003
- 2507. Weaving WebSphere: Remote System Explorer
- (Development Tools)
- ... RPG (a topic for another day). It's clear to me from looking at the list of proposed enhancements that the team is charting a new course for IBM tools. Prior to this, I think that IBM's philosophy was ...
- Created on 09 November 2003
- 2508. TechTip: Excel on the Fly
- (Microsoft)
- ... APIs from a standard RPG program without knowing Java? Yes, it does. And it's really easy. Furthermore, it's a good challenge to improve our programming techniques and learn a little bit of Java. Chapter ...
- Created on 02 November 2003
- 2509. Debugging with IBM WebSphere Development Studio Client Version 5.1
- (Development Tools)
- ... product for the iSeries server. Based on the Eclipse framework, it contains everything for your Java and Web development as well as tools for writing and maintaining RPG and COBOL host applications. ...
- Created on 02 November 2003
- 2510. 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
- 2511. 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
- 2512. 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
- 2513. 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
- 2514. 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
- 2515. 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
- 2516. 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
- 2517. 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
- 2518. 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
- 2519. 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
- 2520. 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
- 2521. 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
- 2522. 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
- 2523. 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
- 2524. 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
- 2525. 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
- 2526. 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
- 2527. 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
- 2528. 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
- 2529. 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
- 2530. 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
- 2531. 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
- 2532. 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
- 2533. 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
- 2534. 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
- 2535. 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
- 2536. 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
- 2537. 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
- 2538. 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
- 2539. 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
- 2540. 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
- 2541. 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
- 2542. 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
- 2543. 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
- 2544. 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
- 2545. Author Guidelines: How to Write an MC Press Article
- (General)
- ... * Create Commands: CRTRPGMOD MODULE(library/CALCELAPSD) * SRCFILE(library/QRPGLESRC) * ...
- Created on 06 July 2003
- 2546. 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
- 2547. 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
- 2548. 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
- 2549. 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
- 2550. 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