- 2751. Function Junction
- (General)
- ... Software Systems, Inc. (GSSSI) has developed a package of RPG IV subprocedures that can be called from ILE programs written in RPG, COBOL, and C. On second thought, has developed is not an ...
- Created on 30 September 2000
- 2752. Stored Procedures 101
- (General)
- ... they are and by showing you how to call RPG programs as stored procedures. What Is a Stored Procedure? At its heart, a stored procedure is just a mechanism for calling a program on the AS/400 via SQL. ...
- Created on 30 September 2000
- 2753. TechTalk
- (General)
- ... and a 1 indicates it was truncated. But, because you’re using *IN16 to control that on the EXFMT, you can move XHMODE into *IN16. In RPG, the code required to handle this looks like the following: C ...
- Created on 30 September 2000
- 2754. The Demise of SEU?
- (General)
- ... Edition, Visual RPG, Code/400, and SEUis now being packaged as a single offering. In addition to the standard tools, IBM is including in this package the Enterprise Toolkit/400 (ET/400) for VAJ (which ...
- Created on 30 September 2000
- 2755. Message Description: Do You Copy?
- (IT Infrastructure - Other)
- ... information on sending messages and using message subfiles, see RPG Building Blocks: ILE Message Handling in the November 1998 issue of Midrange Computing.) Another way to use message descriptions ...
- Created on 30 September 2000
- 2756. Using Mobile Devices to Access Your AS/400
- (Development Tools / Utilities)
- ... in ILE C as well as some written in RPG IV. Both samples are stored in an AS/400 save file. They can be downloaded from Midrange Computing’s Web site at www.midrangecomputing.com/mc. These objects and ...
- Created on 31 August 2000
- 2757. Maintaining Database Integrity Without Commitment Control
- (IBM i (OS/400, i5/OS))
- ... of program or system failure. Most RPG and COBOL AS/400 legacy applications were written with the idea that the code could not fail. This belief is the result of the AS/400 being such a robust platform, ...
- Created on 31 August 2000
- 2758. Cleaning Up the Web with SOAP
- (Web Languages)
- SOAP is a clean way to harness network power.The world is not Java. The world is not RPG. Nor is the world Visual Basic, COBOL, C++, or Prolog. In the world of networked computers, one needs to be able ...
- Created on 31 August 2000
- 2759. Doing E-Business with XML Schemas and SOAP
- (Web Languages)
- ... (MSXML). It can be used as part of the browser or as a standalone component of any language that is capable of using ActiveX components, such as ASNA Visual RPG (AVR) or Visual Basic (VB). Whoever creates ...
- Created on 31 August 2000
- 2760. Form Follows Function: HTML Form Validation with JavaScript
- (Scripting)
- ... scripting language that runs in the context of a browser. JavaScripts most common use is to jazz up user interfaces and perform simple validation of user input. Java, as with RPG and COBOL, is a ...
- Created on 31 August 2000
- 2761. Improving Your Passing Game
- (RPG)
- ... common method of exchanging data between programs. We want to show you yet another way to standardize your parameters. This method is called prototyping parameters. The RPG IV language has built-in ...
- Created on 31 August 2000
- 2762. Should New Development Be in Java/Servlets/JSP?
- (Java)
- Here are some points to ponder. First, the RPG programmer pool appears to be shrinking while the average RPG programmer age is rising. Second, the AS/400 is losing market share in some key areas like Enterprise ...
- Created on 31 August 2000
- 2763. The Business Case for Use Cases
- (Java)
- ... languages, such as RPG and COBOL. Structured analysis and design techniques are not a good fit for cross-platform applications that are to be written in object-oriented Java. So what's the replacement strategy ...
- Created on 31 August 2000
- 2764. Security Patrol
- (IBM i (OS/400, i5/OS))
- ... system? Answer: For the longest time, everyone thought that the answer was no. But in June of this year, an enterprising programmer posted a 17-line RPG program in an Internet forum that would allow viewing ...
- Created on 31 August 2000
- 2765. Anatomy of Net.Data Language
- (General)
- ... an RPG C spec, whereas explicit creation is similar to defining the variable in the RPG IV D spec. The debate over implicit vs. explicit variable creation has gone on for a long time, but likely you will ...
- Created on 31 August 2000
- 2766. 'No Sweat' Command Hel
- (General)
- ... skeleton help text member for a command named Indent RPG (INDRPG), which was published in “The Eagle Eye of INDRPG” in the June 1999 issue of MC. All you have to do is replace all occurrences of the (Enter ...
- Created on 31 August 2000
- 2767. TechTalk
- (General)
- ... in RPG IV. Is this possible? —David Christie A: Yes, the SQL SELECT statement in Figure 5 illustrates how to do this. Make sure that the first argument of the substring operation has as many blanks ...
- Created on 31 August 2000
- 2768. User Interfaces
- (General)
- ... made in the Web, so its likely to be around for a long time. There are many AS/400 tools that can be used to create a Web-based application, including RPG, Java, Domino, and Net.Data. So why not ...
- Created on 31 August 2000
- 2769. Power Up SQL Performance with QSQPRCED
- (SQL)
- ... setting this value to 0 is generally recommended for real applications. QSQPRCED Program Example Shown in Figure 2, RPG program CAFEPGM1 is a simple, hypothetical example of an application used by a coffee ...
- Created on 31 August 2000
- 2770. Cothern Computer Systems' Call Pro--Computer Telephony Software
- (IT Infrastructure - Other)
- ... switches require different sequences of CallPath APIs to perform the same function. Suppose your business has a GeeWhiz 2000 phone switch and your RPG or COBOL programs are calling APIs A, B, C, D, and ...
- Created on 31 August 2000
- 2771. Displaying and Understanding System Reference Codes
- (IT Infrastructure - Other)
- ... language that supports Sockets, such as Java, C++, Visual Basic, and even RPG IV. Look to APIs, such as GetSPCNSRC or GetSRCs, to retrieve these values. Consider using APIs and Java to create a Java applet ...
- Created on 31 August 2000
- 2772. Implementing DB2 UDB for AS/400 UDFs
- (DB2)
- ... their variety of languages provides a great degree of flexibility. Being able to use any AS/400 HLL makes it quite easy to reuse existing code written in RPG, COBOL, etc. that implements various business ...
- Created on 31 July 2000
- 2773. The AS/400 and IBM's DB2 DataJoine
- (DB2)
- ... it very easy to access DB2 DataJoiner from just about any AS/400 application. With the DB2 UDB precompilers, you can embed SQL statements in RPG, C, C++, and COBOL applications on the AS/400. The following ...
- Created on 31 July 2000
- 2774. Using Linux as a Cheap Development System
- (Linux / Open Source)
- ... had to have a terminal to program in CL, RPG, or COBOL. If your equipment was slightly more advanced, you might have had (or may still have) a blazingly fast 9,600 bits per second (bps) dial-up connection ...
- Created on 31 July 2000
- 2775. Component Security in MTS
- (Microsoft)
- ... Many popular Windows development tools, including Visual Basic, Borland Delphi, and ASNA Visual RPG, can be used to create ActiveX components that are suitable for MTS. These tools give the programmer ...
- Created on 31 July 2000
- 2776. Practical Java
- (Java)
- ... RPG subroutine. A Java method (just like a good RPG subroutine) should do two things. The first thing the method should do is narrowly focus on a single task. A getOrderHeader method, for example, should ...
- Created on 31 July 2000
- 2777. What's Wrong with Java
- (Java)
- There is nothing wrong with Java. Then why arent more shops using it? IMHO, whats slowing the adoption rate of Java in traditional RPG shops has absolutely nothing to do with the language itself. ...
- Created on 31 July 2000
- 2778. Dynamic Menu Bars with DSM
- (APIs)
- ... of a DDS menu bar in action. The DDS Curtain Raiser Figures 1 and 2 show DDS and RPG IV source code for a small menu bar program with four choice items: Nurse, Procedure, ICD9, and Drug. Each item has ...
- Created on 31 July 2000
- 2779. Manage DASD User by User
- (APIs)
- ... has only the parameter User, whose default is *CURRENT. The RPG IV and CL source members should be created as modules and then bound together with the Create Program (CRTPGM) command. As shown in Figure ...
- Created on 31 July 2000
- 2780. The Stuff Legends Are Made Of
- (APIs)
- ... the data structures used with the Retrieve Display File API, QDFRTVFD. We didn’t have to enter the definition specifications for these structures. They can be found on your system in QSYSINC/QRPGLESRC ...
- Created on 31 July 2000
- 2781. H-1B Visas: Labor Shortage Solution or Tool of Oppression?
- (General)
- ... While it is still desirable to be proficient in some version of RPG, one can make the case that knowing Java means having potential as a good AS/400 candidate for hire. Other general skills that are very ...
- Created on 31 July 2000
- 2782. How to Find Programmers in Your Organization
- (General)
- ... to computer programming), language-specific programming (RPG IV and CL), systems operation and support, people-skills, and environment-specific information (e.g., department structure, organization charts, ...
- Created on 31 July 2000
- 2783. FTP: Tricks of the Transfer
- (General)
- ... the member TESTPGM from the QRPGLESRC source file. Once the transfer is complete, I will have a file on my PC in the c:download directory named qrpglesrc.textpgm. This file will be a text file, and it ...
- Created on 31 July 2000
- 2784. AS/400 Stored Procedures to the Rescue!
- (General)
- ... with a legacy system written in RPG III that has been around since the System/38. You know the kind of code. Just keep shoveling on functionality and never do a total rewrite. Not that thats bad; ...
- Created on 31 July 2000
- 2785. TechTalk
- (General)
- ... named differently. Using this system gives you an accurate picture of file usage by program in each library, thus giving you an up-to-date picture of all program references (CL and RPG) to a selected ...
- Created on 31 July 2000
- 2786. AS/400: The E-biz Box
- (Web Languages)
- ... Standard Edition. As of V4R5, IBM is bundling a complete Web application development environment. Those tools are as follows: WebSphere Studio CODE/400 VisualAge for RPG (VARPG) ...
- Created on 30 June 2000
- 2787. Converting to Page-at-a-time Subfiles
- (RPG)
- ... and Figure 4 shows the supporting RPG IV code. Figures 5 and 6 (page 92) contain the display file DDS and RPG IV source code, respectively, for the “after” version in Figure 2. We will begin by discussing ...
- Created on 30 June 2000
- 2788. Java Flies on V4R5
- (Java)
- IBM has improved Java performance up to 65 percent!I had the displeasure of working with AS/400 Java on OS/400 V3R7. Back then, I was using the Hursley port of Java. Hursley is the IBM lab in England that ...
- Created on 30 June 2000
- 2789. ASPs, the Channel, and a Radical Proposal
- (Analysis of News Events)
- ... to modern AS/400 hardware and modern OS/400 software by hosting their own applications at an ASP’s data center. They can move their RPG and COBOL applications over, have someone else put a Web front-end ...
- Created on 30 June 2000
- 2790. IBM Clarifies the Future of AS/400 Application Development
- (Commentary)
- ... Should he hire some Visual Basic programmers? Or would Visual C++ be better? Or maybe he should use one of the visual RPG products, since his programmers were already proficient in RPG. Then again, maybe ...
- Created on 30 June 2000
- 2791. TechTalk
- (General)
-
... a file open between programs yet produce only one printout, etc. Is there a way to do this with RPG and CL? — Larry Katerzynske
This email address is being protected from spambots. You need JavaScript enabled to view it. A: The OVRPRTF FILE(printer_file_name) SHARE(*YES) ... - Created on 30 June 2000
- 2792. New Ideas in Documentation and Help Text
- (General)
- ... the DDS help (HLPxxx...) keywords will get the job done, Ill use another technique in my example. Figure 1 contains the source for the RPG program HELP. The source for the display file HELPWINDS ...
- Created on 30 June 2000
- 2793. Debugging AS/400 Stored Procedure Calls from the Client (Part 1)
- (SQL)
- ... us some common ground to work on, I first had to come up with an application that would be interesting to debug. I decided to start by writing a stored procedure in RPG code called CUSTINS, which simply ...
- Created on 30 June 2000
- 2794. 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
- 2795. 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
- 2796. 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
- 2797. 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
- 2798. 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
- 2799. 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
- 2800. 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