- 2701. Who's Got the Edge: Java or C#
- (General)
- ... How does a short list of Visual Basic, JScript, C++, RPG, COBOL, and Java sound? Thats right, I said RPG and Java. Its not that difficult for a system software company to create an MSIL compiler ...
- Created on 31 March 2001
- 2702. Seven Steps to Application Security
- (Security - Other)
- ... somewhere in your database. You may also have jumped on the intranet bandwagon and have programs maintaining records using Java applets, servlets, RPG or C CGI programs, and others. The key here is to ...
- Created on 31 March 2001
- 2703. Getting Started with MQSeries V5.x on Your AS/400 or iSeries
- (Collaboration & Messaging)
- ... command stops them. Compile and Run Sample Programs to Verify the Queue Manager Is Operational MQSeries for iSeries and AS/400 V5.x includes sample programs written in C, COBOL, and RPG for the ...
- Created on 28 February 2001
- 2704. Empowering Your Database
- (DB2)
- ... technique used in the construction of an active database is stored procedures. Because stored procedures can be implemented in languages like RPG, COBOL, CL, and C, stored procedures allow your shop to ...
- Created on 28 February 2001
- 2705. Actively Grouping Your ILE Programs
- (RPG)
- ... to keep your activation groups separate. And that is what this article is all about. We are big proponents of ILE, RPG IV, and APIs, and most of our articles discuss these subjects. This article will ...
- Created on 28 February 2001
- 2706. Implementing ILE Condition Handlers
- (RPG)
- ... and condition handlers. However, direct monitors are not implemented in RPG, and only to a very limited degree in COBOL (with clauses such as ON SIZE ERROR). Since I’m talking about application errors, ...
- Created on 28 February 2001
- 2707. Java Fundamentals for OS/400 Programmers
- (Java)
- ... ago that I was safe in my little RPG programming world, cranking out subfiles and earning a comfortable, if not very exciting, living. When I began to get bored, I could always pick up a copy of Midrange ...
- Created on 28 February 2001
- 2708. Locking Down HTTP for AS/400 Server Default User Security
- (IBM i (OS/400, i5/OS))
- ... and OS/400-based CGI programs (including eRPG programs). Not only do you need to be aware of these profiles, you also need to lock down the profiles so that they can be used only for public access to your ...
- Created on 28 February 2001
- 2709. Database Performance by the Numbers Feedback
- (System Administration)
- Howard addresses reader comments and uncovers some RPG compiler shortcomings.My article Database Performance by the Numbers (in the January 2000 issue of MC) generated a lot of feedback. As ...
- Created on 28 February 2001
- 2710. So, How Long Have You Been in That Job Queue?
- (System Administration)
- ... the old RPG III-based utility into a browser-based utility that uses Java servlets. I wrote the GENPFRLOG utility to scan the history log and build a database that I could analyze more easily than the ...
- Created on 28 February 2001
- 2711. Five Steps to Running Batch FTP from Your AS/400
- (General)
- ... is nothing more than an OS/400 file member, you can use it as input for a CL or RPG program to process the output information and perform certain actions based on whether the command executed correctly ...
- Created on 28 February 2001
- 2712. TechTalk
- (General)
- Grab some pearls of wisdom from your peers.Use Windows Help Files for Documentation I collect various RPG IV procedures and functions and have found that it can be hard to remember what some of them ...
- Created on 28 February 2001
- 2713. Shopping for Free Stuff from IBM and Apache
- (Development Tools)
- ... and Dynamic XML for Java. You’ll also notice a dozen other XML tools under the Technologies section of the site. The most notable is XML Interface for RPG, C, and COBOL. (For a detailed discussion on ...
- Created on 28 February 2001
- 2714. Focus on Database Management
- (Business Intelligence)
- ... that are called from SQL. You like the way RPG programs can call each other, don’t you? Why not let ODBC programs that run on PCs do the same thing? This list boils down to one thing: Get the business ...
- Created on 31 January 2001
- 2715. Access DB2/400 Data from Notes with JDBC
- (DB2)
- ... allowing them to take advantage of the AS/400’s processing architecture and avoiding Java programs from needing to be interpretered during execution. Transforming a Java program is like compiling an RPG ...
- Created on 31 January 2001
- 2716. Resource Management the Directory Way
- (System Administration)
- ... of any LDAP server from all of the OS/400 ILE programming languages: C, COBOL, and RPG. The standard API set is implemented, so LDAP skills developed in an ILE application will transfer to other platforms. ...
- Created on 31 January 2001
- 2717. Lest We Forget
- (Commentary)
- ... battle trying to remember all the required steps. This also reminded me of the time I started to write an RPG IV program and realized that Id forgotten the syntax for the F-spec! At the time, Id ...
- Created on 31 January 2001
- 2718. Getting Started with iSeries Connect
- (General)
- ... Currently, iSeries Connect supports the following three connector types as ways to pass requests to back-end applications: Direct program calls to ILE applications (e.g., RPG) Java method ...
- Created on 31 January 2001
- 2719. Database Triggers
- (General)
- ... action is performed on a physical file. A trigger program carries out this predefined event. A trigger program can be written in a high-level language (HLL) such as RPG, COBOL, or C; in SQL; or in CL. ...
- Created on 31 January 2001
- 2720. TechTalk
- (General)
- ... /* To compile/implement: */ /* */ /* CRTCLPGM PGM(XXX/PMTOVRC) SRCFILE(XXX/QCLSRC) */ /* CHGCMD CMD(XXX/LSTFFD) PMTOVRPGM(*LIBL/PMTOVRC) */ /* */ /*==================================================================*/ ...
- Created on 31 January 2001
- 2721. WebSphere Development Tools: Studying Studio
- (Development Tools)
- ... the AS/400. Those products are CODE/400, VisualAge RPG, VisualAge Java for AS/400. For a description of CODE/400, see my article “WebSphere Development Tools: Getting Started with CODE/400,” (MC, December ...
- Created on 31 January 2001
- 2722. Query Optimizer Revealed in Graphic Detail
- (IT Infrastructure - Other)
- ... access plan. I want to use SQL so that I dont have to spend time figuring out the best way to join tables and how to process the records sequentially, as I have to do with RPG. Ill let the ...
- Created on 31 January 2001
- 2723. New Tools for Collaboration
- (Collaboration & Messaging)
- ... any topic under the sun. Whether you're just getting started with Java and have questions, or you want some advice from an RPG veteran, or even if you want to show the world how smart you are, all are invited. ...
- Created on 31 December 2000
- 2724. Getting a Handle on How OS/400 Assigns *PUBLIC Object Authority
- (IBM i (OS/400, i5/OS))
- ... many common OS/400 statements. What I found is thatin most of the OS/400 CRTxxxxxx commands I opened (such as CRTPGM, CRTPF, CRTRPGPCM, CRTCLPGM, etc.)there is generally an AUT parameter in ...
- Created on 31 December 2000
- 2725. Database Performance by the Numbers
- (System Administration)
- ... the AS/400 platform. I test ODBC from Visual Basic (VB), Java Database Connectivity (JDBC) in Java, precompiled SQL in ILE C, record- level access (RLA) in RPG, RLA in C, Call Level Interface (CLI) in ...
- Created on 31 December 2000
- 2726. XML, FOP, and PDF: The Three Tools of Printing
- (Document Management)
- ... Word and Excel. But if you wanted to create a document programmatically from, say, an RPG program, it wasn’t all that easy. In fact, the work involved far outweighed the benefits. The preferred technique ...
- Created on 31 December 2000
- 2727. TechTalk
- (General)
- ... 2: To use the DSPMODWU command, you need this REXX procedure. Data Conversion Problem Q: I received a file that I need to process in RPG. It contains numeric data that has been “superpacked” so ...
- Created on 31 December 2000
- 2728. Transcode to Get Data Where It Needs to Be
- (General)
- ... to generate HTML via CGI and RPG or perhaps through Java or even one of the many screen-scraper products out there and then display that item lookup data in a browser. If you do that, you can add some ...
- Created on 31 December 2000
- 2729. Of Shoes and SQL Subqueries
- (SQL)
- ... Clause Imagine that you were limited to just one F-spec per RPG program. Life would be quite interesting trying to build sophisticated information systems with only one file allowed per program. Storing ...
- Created on 31 December 2000
- 2730. Free Alternatives to WebSphere's EJ
- (Development Tools)
- ... components without coding or knowing how those components will become networked and distributed. RPG developers can understand the importance of EJBs and EJB containers, as most of their benefits are similar ...
- Created on 31 December 2000
- 2731. Web Strategies: OS/400 Apache and Its Effect on the HTTP Server for AS/400
- (Application Servers)
- ... your company and you have custom-written Web site applications that use OS/400-specific hooks—such as e-RPG (RPG CGI), OS/400 user profile authentication, or third-party OS/400-based products that ride ...
- Created on 31 December 2000
- 2732. The Death of OPNQRYF
- (Business Intelligence)
- ... a high- level language. Then I got a job in a S/38 shop. I was amazed that I could access a database table or view as I had accessed files on the S/34 and S/36. I could even use the RPG cycle. From that ...
- Created on 30 November 2000
- 2733. Demystifying XML
- (Web Languages)
- ... the References and Related Materials list for more ideas and examples. Dont worry about it being complex. It just seems that way at first. If you can maintain that 2000- line RPG program, this will ...
- Created on 30 November 2000
- 2734. Show Good Form
- (Web Languages)
- ... in the correct month-day-year sequence, and that they have a valid date separator. Thats actually a lot to check for most developers, but since many of you have plenty of experience in RPG III, Im ...
- Created on 30 November 2000
- 2735. Using APIs to Edit Data Areas
- (APIs)
- ... from now. If Y2K taught us anything, it taught us that software often outlives its author. We were performing Y2K fixes to RPG code written back in the ’60s, for crying out loud! The point is that, ...
- Created on 30 November 2000
- 2736. Security Patrol
- (IBM i (OS/400, i5/OS))
- ... to use. And remember that the payroll program you wrote in RPG performs all kinds of security functions (Mary can only change the salary for her direct reports; supervisors cant view executives ...
- Created on 30 November 2000
- 2737. TechTalk
- (General)
- Testing for MultithreadingTesting for Multithreading I often write little CL driver programs for my Java code. This is an easy way for my RPG programs to use my Java utilities. However, if a job environment ...
- Created on 30 November 2000
- 2738. WebSphere Development Tools: Getting Started with CODE/400
- (Development Tools)
- ... This new set of tools, which has been renamed WebSphere Development Tools for AS/400, includes CODE/400, VisualAge RPG, VisualAge for Java for AS/400, and WebSphere Studio for AS/400. These tools help ...
- Created on 30 November 2000
- 2739. A Pattern for E-business
- (Commerce - Other)
- ... with an RPG application, including “RPG Building Blocks: ILE Message Handling” (November 1998). The opportunity to use design patterns presents itself during analysis. (See “The Business Case for Use ...
- Created on 30 November 2000
- 2740. Data Interchange for E-commerce: Making Computers Talk
- (Commerce - Other)
- ... locations; although, they could even be distinct applications on the same physical box. For example, you may want to put a strategy in place for how your native RPG programs will talk to native Java applications. ...
- Created on 30 November 2000
- 2741. Rochester's Best-kept Secret: The Director
- (IT Infrastructure - Other)
- ... an LDAP server and a complete set of LDAP clients for access from C, COBOL, RPG, Client Access, Java, and a command line. The LDAP server uses DB2/400 for storing the directory information. This LDAP directory ...
- Created on 30 November 2000
- 2742. Get the Message with MQSeries
- (Collaboration & Messaging)
- ... languages including C, RPG, Java, Visual Basic, and COBOL. The APIs are written in C and certain functions, such as exits, must be written in C as well. As far as APIs are concerned, these are some of ...
- Created on 31 October 2000
- 2743. Lotus Domino for AS/400: The Heart of B2B
- (Collaboration & Messaging)
- ... ServicePort/400 is personalized for the needs of each customer and integrates with an RPG business application that retrieves data from the AS/400 J.D. Edwards enterprise resource planning (ERP) system ...
- Created on 31 October 2000
- 2744. Compress AS/400 Files Using IFS Access
- (IBM i (OS/400, i5/OS))
- ... high-level language on the AS/400, such as RPG or COBOL. IFSFileDialogUsed to traverse the AS/400 IFS and allows you to select a file. Youll use this class to prompt the user to select ...
- Created on 31 October 2000
- 2745. TechTalk
- (Java)
- ... do things not possible in RPG I/O. All our “Work withs” have fully dynamic filters and sorts that let users build their own Where and Order By clauses. The list is then rebuilt using the resulting SQL ...
- Created on 31 October 2000
- 2746. Asynchronous Processing with Open List APIs
- (APIs)
- ... from source member QGYOLSPL, source file QRPGLESRC, found in library QSYSINC. The QSYSINC library comes as a nonchargeable feature with every AS/400, but the odds are that you will need to load the feature ...
- Created on 31 October 2000
- 2747. Chart the Course of Your Midrange Career in Internet Time
- (General)
- ... an AS/400 running integrated enterprise applications, usually written in RPG. Networking was an internal affair, limited to connecting an AS/400 within the enterprise or to building PC LANs with Novell ...
- Created on 31 October 2000
- 2748. Getting Control of Host Servers
- (General)
- ... to easily control your AS/400s host servers from a green-screen. The RPG IV program, WHSR1, shown in Figure 3 (page 89) along with display file WHSFM (available for download along with all the other ...
- Created on 31 October 2000
- 2749. Going 5250 on the Information Superhighway
- (General)
- ... of how I accomplished just such a task on a client project where I was technical leader of the AS/400 group. First, the project was divided into two teams. The RPG team made the code insertions on the ...
- Created on 31 October 2000
- 2750. The Evolution of De Bug
- (General)
- Over the past few years, the programming languages available on the AS/400 have evolved into more than simple report-generating programming tools. RPG itself has progressed, with the introduction of ILE, ...
- Created on 31 October 2000