- 2701. 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
- 2702. 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
- 2703. 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
- 2704. 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
- 2705. 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
- 2706. 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
- 2707. 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
- 2708. 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
- 2709. 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
- 2710. 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
- 2711. TechTalk
- (General)
- ... /* To compile/implement: */ /* */ /* CRTCLPGM PGM(XXX/PMTOVRC) SRCFILE(XXX/QCLSRC) */ /* CHGCMD CMD(XXX/LSTFFD) PMTOVRPGM(*LIBL/PMTOVRC) */ /* */ /*==================================================================*/ ...
- Created on 31 January 2001
- 2712. 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
- 2713. 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
- 2714. 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
- 2715. 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
- 2716. 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
- 2717. 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
- 2718. 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
- 2719. 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
- 2720. 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
- 2721. 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
- 2722. 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
- 2723. 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
- 2724. 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
- 2725. 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
- 2726. 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
- 2727. 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
- 2728. 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
- 2729. 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
- 2730. 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
- 2731. 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
- 2732. 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
- 2733. 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
- 2734. 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
- 2735. 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
- 2736. 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
- 2737. 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
- 2738. 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
- 2739. 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
- 2740. 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
- 2741. 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
- 2742. Hang a Left at Calendarville and Head to the AS/400 Meeting Scheduler
- (Visual Basic)
- ... to the data on the AS/400. Throw in some embedded SQL, stored procedures, and RPG programs on the AS/400, and you are good to go. No, it doesnt have all of the bells and whistles of Microsoft Outlook ...
- Created on 31 October 2000
- 2743. Are You Ready for Apache?
- (Application Servers)
- ... GUI interface for the Apache configuration; Lightweight Directory Access Protocol (LDAP) directory storing of configuration files for users; support for CGIs written in RPG, COBOL, and REXX; support for ...
- Created on 31 October 2000
- 2744. Nothing But .NET
- (Scripting)
- ... There are, also, not a lot of Java programmers, but there are plenty of RPG, COBOL, C, VB, Fortran, Pascal, and various other programmers. These programmers dont want to learn a new language; nor ...
- Created on 30 September 2000
- 2745. EJB for Everyone
- (Java)
- ... about EJB. I see two alternatives when using Java for AS/400 applications: one is to use RPG or COBOL for your business logic and the other is to use EJB. In either scenario, youd use JavaServer ...
- Created on 30 September 2000
- 2746. The Primrose Path of AS/400 IFS Names
- (APIs)
- ... components you will need to compile: command EXPLORE, display file EXP001D, and ILE RPG program EXP001R. Type EXPLORE on an AS/400 command line and press the Enter key. Figure 2 shows a screen shot ...
- Created on 30 September 2000
- 2747. Take Security to the Next Level
- (IBM i (OS/400, i5/OS))
- ... RPG language, have enabled access to low-level MI interfaces to virtually any programmer. This is amply evidenced by recent disclosures of password-sniffing interfaces that use RPG to exploit security ...
- Created on 30 September 2000
- 2748. Have Keyboard, Will Travel: The Whys and Why Nots of Hiring a Consultant
- (General)
- ... to completely apply on its own. Alternately, the organization might retain contract programmers with the same general skill set as internal resources to address a slipping deadline for a new RPG IV-based ...
- Created on 30 September 2000
- 2749. Legacy is E-friendly
- (General)
- The AS/400 and RPG "legacy" can help get your business on the Web.Youve finally gotten around to putting together a plan to get your business on the Web. Then a flyer (or 10) hits your desk with different ...
- Created on 30 September 2000
- 2750. PC Commands from the AS/400
- (General)
- ... known as a connection-oriented approach. With the advent of the UNIX-type APIs and the ability of RPG IV and other ILE languages to use these APIs, the AS/400 now has the ability to write to and read ...
- Created on 30 September 2000