- 2801. Embedded SQL and Dynamic Sorting Subfiles
- (SQL)
- Sorting in RPG is a breeze with embedded SQL.When sorting data to be displayed in a subfile, the Open Query File (OPNQRYF) command is often used. This comes in handy when you are providing the user with ...
- Created on 30 June 2000
- 2802. Hierarchical Storage Management-- Better Access to Your AS/400 Data
- (DB2)
- ... easier. For example, member QUSEC in file QSYSINC/QRPGLESRC provides the ILE/RPG common data structure for the error code parameter used by many of the APIs. The comments included in the members provides ...
- Created on 31 May 2000
- 2803. XSL Style Sheets: Display Files of the Web
- (Web Languages)
- ... architecture. In the first tier, a Web browser presented the data to the user. In the middle tier, Active Server Pages (ASPs), coupled with ASNA Visual RPG (AVR) components, implemented the business rules. ...
- Created on 31 May 2000
- 2804. IBM Makes Improvements in Java Performance
- (Java)
- ... but Just-In-Time (JIT) compilation techniques of IBM and Sun are now exceeding the performance of the batch-compiled Java executables. The time required for function invocation is a problem that RPG IV ...
- Created on 31 May 2000
- 2805. Is Java in Your AS/400's Near Future
- (Java)
- ... get started? If you examine IBMs implementation of Java, JavaBeans, and EJBs, you see raw technology. For those of us who are used to working in high-level languages like RPG or COBOL, this is akin ...
- Created on 31 May 2000
- 2806. Mastering Web Browser Fundamentals JavaServer Pages with JavaServer Pages
- (Java)
- ... forms, see Teresa Pelkies In the HTML Drivers Seat in the December 1999 issue of MC.) The host program can be coded in almost any language, such as RPG, Java, Visual Basic (on NT/2000), ...
- Created on 31 May 2000
- 2807. Getting Started with DSM Input Fields
- (APIs)
- ... midrangecomputing.com/mc. It contains three pieces to compile: command TRC5250, display file TRC5250D, and RPG IV program TRC5250R. To start the utility, type TRC5250 on a command line and press the Enter ...
- Created on 31 May 2000
- 2808. IBM Forges Hot AS/400 Iron and Announces V4R5
- (Analysis of News Events)
- ... applications, that 24-way AS/400 I- Star server costs $4,890,000. That’s a lot of pennies, but, for AS/400 shops that need that kind of power, it sure beats having to rewrite RPG applications in C++ or ...
- Created on 31 May 2000
- 2809. Easily Distribute AS/400 Reports with Microsoft Exchange
- (Microsoft)
- ... programs. Go to the Midrange Computing Web site (www.midrangecomputing. com/mc) to download the RPG program Convert Report to RTF (CVTRPTRTF), which converts the spool file output to RTF. This program ...
- Created on 31 May 2000
- 2810. IBM Is Committed
- (General)
- ... platforms. He knows RPG, DDS, and CL as well as SDA, DFU, RLU, and SEU. Now IBM wants him to learn Java and Domino. Johns concern is that his existing skill set is going to become less and less in ...
- Created on 31 May 2000
- 2811. C Should Be Free!
- (General)
- ... Call Level Interface (CLI) via OLE DB, ODBC, Client Access APIs, RPG, COBOL, CL, REXX, etc. In addition, the procedure is now callable from everywhere. This allows access from an array of interfaces to ...
- Created on 31 May 2000
- 2812. TechTalk
- (General)
- ... on that result. In CL, you might use DCLF/RCVF, but you are allowed only one file per CL program. Another way is to write an RPG program to read the file and test the condition, but writing another program ...
- Created on 31 May 2000
- 2813. More Smoke and Mirrors: Views and Virtual Fields
- (SQL)
- ... who require access to the employee master file. One of the users is Bob, the personnel manager. Another is Chuck, a foreman in the factory. The last user is PAY250, an RPG (or COBOL) program that computes ...
- Created on 31 May 2000
- 2814. Three Steps to a Secure HTTP Server
- (Security - Other)
- ... business smoothly. References and Related Materials e-RPG: Building AS/400 Web Applications with RPG. Bradley V. Stone. Carlsbad, California: MC Publishing Co., 2000 HTTP Server for AS/400 ...
- Created on 31 May 2000
- 2815. Go with the 5250 Work Flow
- (Emulation)
- ... development of programs and screens used to support lists of work in workbaskets may be required. A basic example of how to call APIs from RPG IV is included with the product, along with a reasonably complete ...
- Created on 30 April 2000
- 2816. Why Commitment Control Is Important for High Availability
- (IBM i (OS/400, i5/OS))
- ... system and then modify the programs (RPG, CL, COBOL) that write to or delete records from these databases to also issue calls to the remote-journal APIs. Check out the IBM manuals OS/400 Backup and Recovery ...
- Created on 30 April 2000
- 2817. Can Your UNIX Apps Keep Up the PASE?
- (UNIX / AIX)
- ... means that the AS/400 executes 64-bit applications such as RPG IV programs you develop every day. Tags Inactive means that the AS/400 executes 64- or 32-bit AIX applications. PASE uses the Tags Inactive ...
- Created on 30 April 2000
- 2818. Bridge the Gap to Java with JSP
- (Web Languages)
- Due to easy understanding and immediate results, JavaServer Pages are just the ticket to easing the transition from RPG to Java, with Web-enablement as a bonus!Certainly by now, everyone has heard of Microsofts ...
- Created on 30 April 2000
- 2819. Net.Data--Now!
- (Web Languages)
- ... first line in the C-specs of an RPG program). A macro may have many HTML sections. Each HTML section can be used as the entry point of the macro. An HTML section has a name; the HTML section defined beginning ...
- Created on 30 April 2000
- 2820. Java Performance Tips
- (Java)
- ... Java. Here are four of the most important system tuning tips: Choose an AS/400 model that is designed for Java. Older AS/400 models are designed for RPG and COBOL applications. Java applications ...
- Created on 30 April 2000
- 2821. Focus on Printing
- (Document Management)
- ... retirement. Facing challenges like twinax cabling, uncooperative users, and RPG II would have made me a bald man if I were not bald already. No, printing is not exciting, but it’s useful. And to my way ...
- Created on 30 April 2000
- 2822. May the (AFP Overlay) Forms Be with You
- (Document Management)
- ... the RPG IV code you need to type in for INV001RP, and Figure 5 shows the DDS specs you need to type in for INV001P1. This program will create some sample output on your invoice form. There are three methods ...
- Created on 30 April 2000
- 2823. A Basic AS/400 Skills Checklist
- (General)
- ... absolute; each company has its own needs. For example, some may wish to emphasize a third-party development tool that their shops use. Others may want to focus on core programming languages such as RPG. ...
- Created on 30 April 2000
- 2824. TechTalk May 2000
- (General)
- TechTalkDont Lose Your SEU Changes Have you ever been in the middle of modifying an existing AS/400 source file, such as an RPG IV program, and deleted or changed lines of code that you didnt ...
- Created on 30 April 2000
- 2825. How to Count and Keep Your Midrange Knowledge Capital
- (Business Intelligence)
- ... by using RPG or a visual language and one of your programmers leaves, a replacement of similar or even more mature abilities might seem the easy solution. The same can be said for all different Web programmers, ...
- Created on 31 March 2000
- 2826. IBM RAISEs the Standards
- (IBM i (OS/400, i5/OS))
- ... and payroll information. It is our oldest set of test cases, and, for the most part, the test cases are run interactively with some batch jobs. The parent company uses RPG, COBOL, C, and CL applications ...
- Created on 31 March 2000
- 2827. List Dormant Programs with the LSTDRTPGM Command
- (RPG)
- This utility will catchAs an AS/400 programmer, Im well aware of the need to leave utility programs active between calls. An RPG utility program doesnt set on the LR indicator, and COBOL utility ...
- Created on 31 March 2000
- 2828. A Programmer's Notebook: Making Servlets Run Faste
- (Java)
- ... traditional programming skills come into play. Just as a poorly written RPG program is slow, a poorly written Java program will be slow. Database access delaysGetting data to and from the ...
- Created on 31 March 2000
- 2829. Servlets: The New Application Architecture
- (Java)
- ... to RPG. But would Java play nice on the AS/400? Could I leverage my companys investment in several million lines of RPG code and a database developed over a period of years? Could I draw ...
- Created on 31 March 2000
- 2830. A Better Way to Distribute Your AS/400 Software Changes
- (Change Management)
- ... display file Two AS/400 physical files One AS/400 RPG IV program One PC-based FTP server program InstallShield Most of these youll be familiar with. You may not be as ...
- Created on 31 March 2000
- 2831. Logical Files: More than Alternate Sort Sequences
- (Change Management)
- ... qualifies as a program, even though the query is really not a program in the same way that executable objects generated from RPG source code are programs. This Month's Lesson Rather than write a monster ...
- Created on 31 March 2000
- 2832. Use CD-ROM to Port Source Code and Data
- (APIs)
- Use RPG and CD-ROM to move data to many platforms.AS/400 Guru: I need to load our invoicing data on my AS/400. How can we exchange it? UNIX Guru: AS/400? Whats that? AS/400 Guru: What type of system ...
- Created on 31 March 2000
- 2833. The Comprehensive AS/400 Guide to Microsoft Terminal Server
- (Microsoft)
- ... up front and ensure that the applications you run in-house have been tested to run on Terminal Server. I have just run into this with VisualAge for RPG (VARPG). IBM has not tested it with Terminal Server ...
- Created on 31 March 2000
- 2834. Are Your Programmers Stale?
- (General)
- ... with an aging workforce unfamiliar with emerging trends. The problem is particularly prevalent in AS/400 shops where even RPG IV code resembles its immediate RPG III predecessor or RPG II grandparent. ...
- Created on 31 March 2000
- 2835. TechTalk
- (General)
- ... (SRTDDS) also in QTEMP. RPG IV program SRTDDSR1 is then executed to read the original source member and write the code it finds to SRTDDSW. Then, program SRTDDSR2 reads SRTDDSW sequentially by key (thus ...
- Created on 31 March 2000
- 2836. Mapping Your Data to XML the Easy Way
- (Web Languages)
- ... XML document means that it follows XML standards. What does that mean? Well, compare it to an RPG compiler. A compiler makes sure that the RPG code is syntactically correct: all variables are defined, ...
- Created on 29 February 2000
- 2837. XML: The E-language for E-business
- (Web Languages)
- ... of support are Microsoft's MSXML ActiveX, IBM's XMLJ4 parser for Java, and ASNA's Externally Described XML Schemas for Visual RPG. Unfortunately, most documents on the Web today are formatted using HTML ...
- Created on 29 February 2000
- 2838. Java Performance Tuning
- (Java)
- Maximize the performance of your Java Applications on the AS/400.Several attributes of the Java language make performance tuning a bit more of a challenge than typical procedural languages such as RPG ...
- Created on 29 February 2000
- 2839. Midrange Insights: UNIX Crosses AS/400 Threshold, Linux Out in the Cold
- (Analysis of News Events)
- ... loads into a private address space in the AS/400’s memory and runs. The AIX applications within PASE can access AS/400 databases just like other AS/400 applications, and they can call ILE RPG, C, and Java ...
- Created on 29 February 2000
- 2840. Tom Jarosh Speaks on Plans for the AS/400
- (Analysis of News Events)
- ... that the AS/400 has to be successful on its own merits as opposed to being successful because that is the only place that RPG runs. And I have no problem competing in that regard. And to a large extent, ...
- Created on 29 February 2000
- 2841. Three Steps to Report Duplication and Distribution
- (Document Management)
- ... isn’t. Most of the APIs use parameters retrieved by others; so, for the most part, duplication is simply calling one API after another. The six spooled file APIs used are shown in the S2SP01RG RPG program, ...
- Created on 29 February 2000
- 2842. TechTalk
- (General)
- A forum for sharing AS/400 tips and techniques.Got a Date? Recently, I was asked how to use the RPG IV date addition and subtraction op codes to determine a date one month from the current date. Not ...
- Created on 29 February 2000
- 2843. Full Frontal Access
- (Visual Basic)
- If you're an RPG programmer and programming front-end applications in Microsoft's Visual Basic for Applications (VBA) seems like a foreign language, this is the article for you.If youre an RPG programmer ...
- Created on 29 February 2000
- 2844. Systems Administration & Operations: IBM Gives Us a Better AS/400 Webserver Search Engine
- (IT Infrastructure - Other)
- I remember when I first learned to program in BASIC. Man, I couldnt believe how cool that language was and all the neat stuff I could do with it. Then I got onto the AS/400 and learned RPG and thought, ...
- Created on 29 February 2000
- 2845. Can't LotusScript It Any Better
- (Scripting)
- ... Good News and Bad News The technique I have described has many uses but has some catches as well. You can call a C function, for example, but calling an RPG program directly is not recommended because ...
- Created on 31 January 2000
- 2846. Breathing New Life into Old Code
- (RPG)
- RPG IV can work wonders with your old code.Ive seen some RPG code Id rather forget. These programs used all 99 indicators and had loads of redundant code. Code such as this wastes both time ...
- Created on 31 January 2000
- 2847. Wanna Play Center Field?
- (RPG)
- ... such class was Jon Paris’ session in which he discussed new features for V4R4 of the OS/400. Jon talked about RPG's new EVALR operation code, which is basically an EVAL statement that moves the result to ...
- Created on 31 January 2000
- 2848. Midrange Computing: IBM May Finally Get Open Source Religion with AS/400s
- (Analysis of News Events)
- ... IBM should focus on using open source talent to expand both RPG and Java programming for business applications. There are almost a million RPG programmers in the world and over a million serious Java programmers, ...
- Created on 31 January 2000
- 2849. A Poor Man's Web Sit
- (General)
- ... easily, and within the budget. One basic option available with all servers is Common Gateway Interface (CGI) programming (see Untangle the Web with RPG and CGI, MC, September 1999), but CGI ...
- Created on 31 January 2000
- 2850. Beginner's Luck with AV
- (General)
- Don't gamble on green-screens being around forever. Hit the GUI jackpot with ASNA Visual RPG.Soon after I started the ASNA Visual RPG for Smarties tutorial, I was both hooked and doubly impressed ...
- Created on 31 January 2000