- 2901. The AS/400 IFS Network Integration in a Tree
- (General)
- ... is QSYS.LIB, in which all of your DB2/400 libraries, program, files, and objects are stored. When you run an RPG, CLP, or ILE C/400 program, you are working with the QSYS.LIB file system. Other standard ...
- Created on 31 July 1999
- 2902. Instant Menus!
- (General)
- ... the arrow that appears to the left of the command line on OS/400 menus, so > suggests command. And * is the symbol that RPG uses for comments, so its used here to comment ...
- Created on 31 July 1999
- 2903. Lock It Up
- (General)
- ... the system uses RPG program Retrieve Lock Workstation Information (RTVLWSINF) to see if the session is currently being monitored. If it is being monitored, a second RPG program, Retrieve Lock Workstation ...
- Created on 31 July 1999
- 2904. TechTalk August 1999
- (General)
- The More Digits, the MerrierThe More Digits, the Merrier Q: I have a calculation that requires field lengths of more than 30 digits. Unfortunately, RPG IV allows up to only 30 digits for a numeric field ...
- Created on 31 July 1999
- 2905. Is ERP in Your Future?
- (Enterprise Resource Planning / Financial)
- ... packages would eventually get so good it would no longer pay to write homegrown softwaremay finally be reality. I dearly love RPG, and I could stay busy working in RPG shops for a good portion of ...
- Created on 30 June 1999
- 2906. XML Today
- (Web Languages)
- ... Another alternative for presenting XML data is to develop a Java API that is customized for your industry-specific XML. Java and XML work well together; you could say that Java is to XML what RPG is to ...
- Created on 30 June 1999
- 2907. Now On Display: Access Paths
- (RPG)
- This gem of a utility has been newly polished for RPG IV. We have been writing monthly articles for MC for five years now. We decided to celebrate this momentous occasion by revisiting one of our favorite ...
- Created on 30 June 1999
- 2908. Vanishing Act?
- (RPG)
- Without fresh talent, RPG programming may go the way of the dinosaur. There is a shortage of new talent in our profession, and we need to do something about it. This is not news to those of us who have ...
- Created on 30 June 1999
- 2909. Enterprise JavaBeans: Show Me the Code!
- (Java)
- ... that some Java class must later implementsimilar to a set of RPG IV D-specs that contains function and procedure prototypes. A beans home interface provides the CRUD: the EJB life-cycle methods ...
- Created on 30 June 1999
- 2910. Color by Numbers with DSM
- (APIs)
- ... Screen Art In addition to TESTWEA, Ive included on the Web an RPG IV program that I call PAINT because it lets you paint a 5250 workstation into 24 x 80 pixels of color. To download this program, ...
- Created on 30 June 1999
- 2911. Midrange Insights
- (Analysis of News Events)
- ... way ahead of the curve when it comes to dealing with millennium bugs), the next couple of years of your life—whether you are a programmer maintaining RPG code, an IT manager guiding the programming activities ...
- Created on 30 June 1999
- 2912. Lights, Camera, Action: Directing Printer Output
- (Document Management)
- ... the output queue needs to be selected only once. To manage this function, I use two physical files, one logical file, two display files, and four RPG programs (see Figure 4). The source for these objects ...
- Created on 30 June 1999
- 2913. Professional Paths
- (General)
- ... before program changes go into production. Programmers have a reasonable grasp of RPG, CL, and the AS/400 system architecture, show an understanding of business principles, and want to learn programming ...
- Created on 30 June 1999
- 2914. Testing...1...2...3...
- (General)
- IBM Professional Certification testing:I recently had the opportunity to take the IBM Professional Certification test for the IBM Certified Specialist-AS/400 RPG Programmer. If this hadnt ...
- Created on 30 June 1999
- 2915. ASP, Reporting for Active Service, Sir!
- (General)
- ... of ASNAs Visual RPG (AVR) Version 3.0, it is also now possible to create ActiveX components using the RPG language and record-level AS/400 database access. Developing ASP Applications with AVR The ...
- Created on 30 June 1999
- 2916. Memo to Self: Organize Your Data Values
- (General)
- ... method for accessing user values from a command line or CL program. The APIs are the better choice for accessing user values from RPG programs. Figure 1 shows a list of the commands and APIs that access ...
- Created on 30 June 1999
- 2917. TechTalk July 1999
- (General)
- ... to support various AS/400 programming languages. I have set up PDM options for doing source comparisons of CL with RPG III source members but ignoring comments, but you can do the same with Work with User- ...
- Created on 30 June 1999
- 2918. What Does That Query Do?
- (General)
- ... to understand about BLDQRYXREF is its command interface and the physical file it loads, QRYXREF. Besides these objects, BLDQRYXREF also has three CL programs and one RPG III program. BLDQRYXREF loads information ...
- Created on 30 June 1999
- 2919. A Roadmap for E-business
- (Commerce - Other)
- ... legacy languages such as RPG. You must decide which road map to follow, but in today’s competitive market, any decision will be a good one. Remember the Zen saying: “A journey of a thousand miles must ...
- Created on 30 June 1999
- 2920. DB2 Data Slides into Lotus Notes
- (Collaboration & Messaging)
- ... a few values. You can actually think of the @DbLookup function as an RPG CHAIN operation since it retrieves a single record by a key value. If you need more than a single item or single column of data ...
- Created on 31 May 1999
- 2921. Competitive Alternatives to IBM's OLE DB Providers: Who Are These Guys
- (APIs)
- ... and how they can benefit your shop. Some Alternatives Amalgamated Software of North America, ASNA You might be familiar with ASNA (www.asna.com) because of its Visual RPG product, but ASNA ...
- Created on 31 May 1999
- 2922. From the Editor: You Dont Need a Weatherman to Know Which Way the Wind Blows
- (Commentary)
- ... At first, we were just a publication for RPG programmers, but we soon learned that advancements in OS/400 security required special consideration. Later, as the AS/400 architecture embraced client/server ...
- Created on 31 May 1999
- 2923. Focus On IDEs
- (General)
- ... people who pushed Integrated Development Environments (IDEs). A large part of my consulting time is spent modifying and writing RPG programs using, for the most part, IBMs tools: PDM, SDA, SEU, and ...
- Created on 31 May 1999
- 2924. Behold the March of IDEs: A Killer Tool for the AS/400
- (General)
- ... classes, and methods. Visual Basic projects include modules, procedures, classes, and methods. If you develop ILE applications in RPG or COBOL, you must track and manage such components as modules, service ...
- Created on 31 May 1999
- 2925. Repository-based Source Control
- (General)
- ... software versions that then need to be maintained and supported. So whether your applications programming language is Visual Basic, C++, Java, or RPG, the fact is that, where you once dealt with a dozen ...
- Created on 31 May 1999
- 2926. TechTalk June 1999
- (General)
- ... A: If you are using RPG IV, you can use the RPG IV keyword *START to get to the top of any file: C *START SETLL FILE In RPG III and RPG IV, to reposition the file to the first record for a nonindexed ...
- Created on 31 May 1999
- 2927. The Hack in the Back
- (General)
- ... Dr. Seuss, Joe Pluta draws from one of his favorite authors to depict this age-old conflict in a slightly different light. This is the story of the Hack in the Back, a curmudgeonly old RPG programmer ...
- Created on 31 May 1999
- 2928. Take This Job Log and Scan It
- (IT Infrastructure - Other)
- ... of four source members: • Command SCNJOBLOG • CL program SRC620CL • RPG IV program SRC620RG • Display file SRC620DS The CL program first checks to see if the job log has been written to a spool file. ...
- Created on 31 May 1999
- 2929. Universal Database DB2: The Sequel
- (DB2)
- ... The point is, when Im developing business applications using C++, Java, RPG, or some other programming language, I want my RDB. Regardless of what I thought, OODBs were gaining in popularity, and ...
- Created on 30 April 1999
- 2930. Breaking Apart the Monolith
- (RPG)
- ... alone was about 4,000 lines of RPG code, not counting the display file DDS source. You Say That like It Was a Bad Thing Well, it was, especially if you wanted to modify your application. These programs ...
- Created on 30 April 1999
- 2931. When Less Is More
- (RPG)
- ... for, this feature alone gives our tool a substantial advantage over IBM’s DSPFD command. How It Works Three source components make up our DSPFILDSC command: the RPG IV driver program, which uses five ...
- Created on 30 April 1999
- 2932. The Business of Java
- (Java)
- ... I need to clarify that a bit. I’m not saying you should use Java and object-oriented programming (OOP) for everything and throw away all that you’ve ever learned about RPG (or COBOL, for that matter) and ...
- Created on 30 April 1999
- 2933. Links, Imports, Exports: Using ODBC to Share OS/400 Data with Microsoft Access
- (APIs)
- ... the exported Access data, you may (depending on the language) have to take special care to read files containing a null. For example, RPG/400 and older RPG ILE releases do not support nulls. However, there ...
- Created on 30 April 1999
- 2934. Fast Track to Training
- (Analysis of News Events)
- ... So how do you choose the option that’s right for your situation? To give you a feel for the options and the costs, I have examined the cost of RPG training through various formats and for various scenarios, ...
- Created on 30 April 1999
- 2935. Web Application Servers: Middleware Plumbing for E-business
- (Analysis of News Events)
- ... terminal emulation software and perhaps linking an RPG or COBOL application to a word processor, a spreadsheet program, or a homemade PC-based interface for that program written in a visual programming ...
- Created on 30 April 1999
- 2936. IMHO: A Programmer?s Reality Check
- (Commentary)
- ... Egregious Misconception Number One: RPG III is a dead language. Ha! This is the most egregious misconception of all! RPG III is anything but dead. For years, Ive been berating poor ol RPG ...
- Created on 30 April 1999
- 2937. When Training is a Matter of Survival
- (Commentary)
- ... RPG, COBOL, Java, Dominoit never stops. Seemingly overnight, todays experts become tomorrows novices, then train again to become experts, knowing that the only thing that awaits them ...
- Created on 30 April 1999
- 2938. Focus on Careers and Certification
- (General)
- ... Intel, or Sun. Other times, you are buffeted by the software hype, running with or against the shifting winds of programming technologies: COBOL, RPG, C++, Java, Visual Basic, and many others. Most times, ...
- Created on 30 April 1999
- 2939. PIE Charts Careers
- (General)
- ... Track III: AS/400 Application Development AS/400 Operations AS/400 Application Development Tools CL Programming Procedural Programming I (RPG/400 or COBOL) Procedural Programming ...
- Created on 30 April 1999
- 2940. Testing Out IBM Certification
- (General)
- ... no one has seen in 10 or more years because the company never upgraded its own code. Someone who has worked only with RPG/400 or ILE RPG would have a different answer than the company using RPG III. My ...
- Created on 30 April 1999
- 2941. The Bottom Line on Certification
- (General)
- ... AS/400 professionals, some might answer no when asked whether certification is important to their career. However, I think those people are a bit shortsighted. An RPG programmer, for instance, ...
- Created on 30 April 1999
- 2942. Integrating ASP with the AS/400
- (General)
- ... In the Action dropdown box, select Service from the dropdown menu. In the URL Template field, enter the following: /*.asp In the Replacement File Path Field, enter /QSYS.LIB/QHTTPSVR.LIB/QZHJSVLT.SVRPGM: ...
- Created on 30 April 1999
- 2943. TechTalk May 1999
- (General)
- ... text in RPG IV is a task programmers frequently perform and one that we constantly rewrite every time we need it, usually trying to improve on our technique. Heres a method for centering text that ...
- Created on 30 April 1999
- 2944. E-commerce Security with Cerberus, the Three-headed Dog
- (Security - Other)
- ... for AS/400 IFS Web directories with your CGI profile (QTMHHTP1). However, because CGI programs use the AS/400 library system (where our RPG and COBOL programs reside along our DB2/400 files), specify *USE ...
- Created on 30 April 1999
- 2945. APIs That Sort
- (APIs)
- Using the sort APIs with RPG IV, you can sort data, and sort it fast!Just because RPG doesnt have native data sorting functions, it does not mean that RPG cant sort data. In fact, as soon as ...
- Created on 31 March 1999
- 2946. More AS/400 Client/Server Programming with ADO and VBA
- (APIs)
- ... it doesn't have to be loaded again each time it is called. In CL, the RETURN command is used to do achieve this result. In ILE RPG and RPG/400, issuing the RETURN (RETRN) op-code without having *INLR on ...
- Created on 31 March 1999
- 2947. Midrange Insight
- (Analysis of News Events)
- ... expensive server processing power. The AS/400 has benefits when comparing legacy applications written in RPG and COBOL with new Java applications. For instance, Java applications run within a software ...
- Created on 31 March 1999
- 2948. From the Editor: Welcome to the Instant Economy
- (Commentary)
- ... point to a need for more book titles on the subject of Java or RPG. IBM calls the use of these tools business intelligence (BI), a sector of the software market expected to grow at an annual rate of 15 ...
- Created on 31 March 1999
- 2949. Microsoft Is Knocking: Should You Let It into Your Career?
- (General)
- ... came the IBM 360 and 370; and IBM System 3 with a new language, called RPG II; followed by IBM Systems 32, 34, 36, and 38 with another new language, called RPG III. And, finally, came the IBM AS/400. Somewhere ...
- Created on 31 March 1999
- 2950. Using J Walk to Build a Better GUI
- (General)
- ... of having a GUI, the GUI project was usually the first one to be set aside when other important issues, such as Y2K, percolated to the surface. We had already used IBM’s VisualAge for RPG (VA/RPG) to create ...
- Created on 31 March 1999