- 2551. The Midrange Manager: The Value of Continuing Education
- (RPG)
- What are you doing to ensure that your employees are keeping their skills honed? Hello from RPG World in Orlando. This week, over 130 iSeries developers are meeting to discuss the world of RPG, receive ...
- Created on 29 April 2003
- 2552. TechTip: Work with CGI Spooled Files (WRKCGISPLF)
- (Document Management)
- ... developing a Web-enabled report for a client, I came up with the idea for the Work with CGI Spooled Files (WRKCGISPLF) program, which you can download by clicking here. WRKCGISPLF is an RPG IV Common ...
- Created on 27 April 2003
- 2553. The Remote System Explorer
- (Development Tools)
- ... modify or enhance the existing development environment. WebSphere Development Studio Client for iSeries consists of Java tools, Web tools, the IBM WebFacing Tool, VisualAge RPG, and CODE. One of the key ...
- Created on 27 April 2003
- 2554. The ILE Program Model from the Compiler Perspective
- (RPG)
- ... to binding, we heard about bind-by-copy and bind-by-reference. Binding is the term used for creating a program under OS/400. Back in the old RPG III days, program source code was compiled, and a program ...
- Created on 15 April 2003
- 2555. TechTip: A Way to Capture SQL Statements
- (SQL)
- For anyone in the IS/IT departments, SQL can be a very useful and productive tool. However, it can be a dangerous and untraceable process as well. We have found a trick that is very handy for monitoring ...
- Created on 13 April 2003
- 2556. Weaving WebSphere: Odds and Odders
- (Development Tools)
- ... COBOL, his sentiments could just as easily be applied to midrange RPG applications. Technology for Technology's Sake Here's a little reminder to everyone about the concept of "bleeding edge," ...
- Created on 13 April 2003
- 2557. WebSphere Application Server Basics
- (Application Servers)
- ... code or create new business logic with Java development tools. Write business logic for new e-business applications in ILE RPG or ILE COBOL with interoperability enhancements for Java. WebSphere Development ...
- Created on 06 April 2003
- 2558. Exploring V5R2's Data Structure Array
- (RPG)
- Want multiple occurrences? Declare a data structure as an array.For decades, RPG has included the ability to have multiple occurrences of a data structure in a program. Multiple occurrence data structures ...
- Created on 01 April 2003
- 2559. The Midrange Manager: SQL or DDS?
- (RPG)
- ... some of the new RPG IV data definition capabilities. For example, the integer data type is not supported; what is supported is the rather the outdated "B" data type. And 31-digit packed decimals are not ...
- Created on 01 April 2003
- 2560. TechTip: Considerations for Holiday Determination
- (RPG)
- ... the month and day)2. The day of the weekDetermining the day of the week in RPG is simple: weekDay = %rem(%diff(yourDate:d'0001-01-01':*D):7) + 1; This produces 1 for Monday through 7 for Sunday. ...
- Created on 23 March 2003
- 2561. Building a Nest out of Your Data Structures
- (RPG)
- With V5R2, qualified data structures got even better.In the last issue, I talked about qualified data structures in RPG IV. Qualified data structures give you the ability to create multiple data structures ...
- Created on 18 March 2003
- 2562. The Midrange Manager: Remote iSeries Access
- (RPG)
- ... extra hours of work each week. The benefit to them is that they are using something other than SEU to get their job done, and with practice, they become more experienced at RPG development. A policy ...
- Created on 18 March 2003
- 2563. Logical Partitioning: Better Than Ever
- (IBM i (OS/400, i5/OS))
- ... software. He is president of the Long Island Systems Users Group and a frequent speaker at COMMON and other local user groups. He is the author of the book RPG Error Handling Technique: Bulletproofing ...
- Created on 16 March 2003
- 2564. TechTip: User-Defined SEU Line Commands
- (RPG)
- ... when you are converting from "old" RPG to "new" RPG (I have given up trying to determine if it's RPG III, RPG IV, or RPG ILE, but I'm sure you get the idea). The program I have included at the end of this ...
- Created on 16 March 2003
- 2565. Retrieve DDS Source for a Physical or Logical File
- (CL)
- ... gathered to build the DDS member, how do you know how to format the member? That's easy. As with RPG source, DDS source is defined by a rigid set of column positions wherein specific entries must be made. ...
- Created on 09 March 2003
- 2566. TechTip: DSPQRYREF
- (CL)
- ... that can be read to determine what files the query uses. The RPG program ANZQRYSRC handles this part of the job. This program reads through the generated SQL source and searches for file names by looking ...
- Created on 09 March 2003
- 2567. Qualified Data Structures
- (RPG)
- Use the same subfield name in more than one data structure.When OS/400 V5R1 was announced, it included what I would consider the most significant enhancement to RPG IV data structure support in history, ...
- Created on 04 March 2003
- 2568. Validate and Adjust Your Data
- (RPG)
- ... widespread use today; start at the end of a field and check each character in the field for a blank until you encounter a non-blank. Voila! You have the data length. In RPG IV, a simple--yet often overlooked--technique ...
- Created on 18 February 2003
- 2569. The Midrange Manager: Using Modules and Procedures
- (RPG)
- Jump in--the water's not as cold as you think!Making the move to RPG IV with modules and procedures isn't as difficult as you might expect. There is some mystery surrounding the idea of using modules and ...
- Created on 18 February 2003
- 2570. TechTip: Updated SAVLIBL and RSTLIBL Utilities
- (CL)
- ... 1990. He started in S/38 operations as a programmer "understudy" and was promoted to programmer/analyst around 1996. He's currently working on a Model 730 iSeries running V5R2, programming in ILE RPG and ...
- Created on 16 February 2003
- 2571. Case Study: BOScom's Jadvantag
- (Case Studies)
- ... have taken too much work and too long to complete, not to mention maintain. With Jadvantage, we wrote a simple program for the AS/400 in CL and RPG. Then it just took a couple of hours to set up the portal ...
- Created on 16 February 2003
- 2572. Case Study: BOScom's Jadvantag
- (Case Studies)
- ... maintain. With Jadvantage, we wrote a simple program for the AS/400 in CL and RPG. Then it just took a couple of hours to set up the portal with Jadvantage." Ease of use: "With our portal, ...
- Created on 16 February 2003
- 2573. Message to the SMB Masses: Business Partners to the Rescue
- (Commentary)
- ... Web application server. It was also a suite of development products designed to make e-business easier to implement. Well, to midrange customers working with RPG applications, the prospect of getting some ...
- Created on 16 February 2003
- 2574. The Midrange Manager: What's in Store for the iSeries
- (RPG)
- All signs point toward good things for the iSeries market.I'm hearing now that RPG and the iSeries will be making a big comeback this year. Apparently over 70% of IBM's customer base owns an AS/400 or iSeries ...
- Created on 04 February 2003
- 2575. TechTip: Debug SQL Objects More Easily
- (DB2)
- RPG and COBOL programmers will find that debugging SQL stored procedures, functions, and triggers in V5R2 (and V5R1 via PTF) is easier to understand and more enjoyable. When an SQL procedure, function, ...
- Created on 02 February 2003
- 2576. TechTip: An Easier Way to Process Level Breaks
- (RPG)
- ... in the next higher break. It is coded as a group of nested DO loops.If you write such a control break program in RPG, using its native file access opcodes, you do not even need hold fields.For this ...
- Created on 26 January 2003
- 2577. Dynamic Arrays Revisited
- (RPG)
- Try this new, simpler technique for declaring dynamic arrays.A few months ago, I discussed a technique describing how to declare arrays in RPG IV that had a variable number of array elements. Arrays ...
- Created on 21 January 2003
- 2578. TechTip: QCAPCMD--A Replacement for QCMDEXC
- (RPG)
- I have never cared for the way RPG handles exceptions that occur when you run a CL command via the QCMDEXC API. Using the *PSSR just never seemed to work the way I needed it to. By way of comparison, the ...
- Created on 12 January 2003
- 2579. Using Add-On Tools
- (RPG)
- ... and "How do I retrieve a system value in RPG?" The answer to the first question is simple: Call the CEEDYWK API, and let it do it for you. The answer to the system value question is a little more complex; ...
- Created on 07 January 2003
- 2580. TechTip: %DATE, %TIME, and %TIMESTAMP
- (IBM i (OS/400, i5/OS))
- The %DATE, %TIME, and %TIMESTAMP built-in functions were new in V5R1. %CHAR has been enhanced to allow date, time, and timestamp parameters, with an optional format. They can be used to accomplish several ...
- Created on 05 January 2003
- 2581. Find and Replace
- (RPG)
- ... procedure that performs a certain task and returns a value to the caller. The function that is performed is one that I've needed frequently in RPG, so I decided to write it myself rather than wait for ...
- Created on 17 December 2002
- 2582. The Midrange Manager: Components and Extensions
- (RPG)
- Build them or buy them?Ever since IBM shipped the Integrated Development Environment (ILE), they suggested that third-party developers would prosper by creating "libraries" of extensions to the RPG language. ...
- Created on 17 December 2002
- 2583. IBM Acquires Rational Software
- (Commentary)
- ... well in the days of simple RPG and COBOL applications, but it doesn't stand a chance when building IT infrastructural e-business projects that meld together multiple architectures with the latest programming ...
- Created on 15 December 2002
- 2584. Invisible E-Commerce--Transaction Processing over the Internet
- (Commerce - Other)
- ... these solutions with tight interaction to the iSeries, RPG or COBOL, and DB2/400-based application suites. With the press and so many vendors touting solutions that need to run on Windows and Unix servers, ...
- Created on 08 December 2002
- 2585. The Midrange Manager: Dump SEU!
- (RPG)
- If you stop using SEU, what will you use instead?Yes, in the previous issue, I briefly mentioned that "[SEU] is perhaps the most significant practice that is keeping RPG programmers a generation behind ...
- Created on 03 December 2002
- 2586. The Linux Letter: Don't BASH Your Head Against a Wall Learning QSH
- (Linux / Open Source)
- ... Perhaps you still are skeptical about QSHELL because all of your development is in ILE/RPG and you don't find yourself dealing with the IFS very often. That may be true, but you can access your source ...
- Created on 01 December 2002
- 2587. An Open Letter to IBM
- (Commentary)
- ... some of the dense, difficult to read expressions needed by SQL programmers to the simple syntax of RPG or COBOL, it's a bit worrisome to us that you have decided to kill off DDS in favor of SQL. Scrollable ...
- Created on 01 December 2002
- 2588. Breaking Apart Your Source
- (RPG)
- It's time to start using /COPY!For years, I've been teaching RPG and RPG IV to programmers, and one question I always ask is, "Are you using /COPY?" Well, the answer will probably be no surprise to you, ...
- Created on 19 November 2002
- 2589. XML for Dummies, Idiots, and People Like Me Who Just Don't Kno
- (Web Languages)
- ... How Do I Read and Manipulate XML? While the description of XML thus far may provide some interesting concepts, I would hate to have to get data out of an XML document using RPG or Cobol. The W3C saw ...
- Created on 17 November 2002
- 2590. Case Study: Jacada's Studio for iSerie
- (Case Studies)
- ... developer's perspective, there is always an underlying reliance on the green-screen itself. In addition, many of the tools and techniques require RPG and COBOL developers to learn new programming languages ...
- Created on 17 November 2002
- 2591. Case Study: Jacada's Studio for iSerie
- (Case Studies)
- ... a developer's perspective, there is always an underlying reliance on the green-screen itself. In addition, many of the tools and techniques require RPG and COBOL developers to learn new programming ...
- Created on 17 November 2002
- 2592. IBM Pitches WebSphere Express to Mid-Market Organizations
- (Analysis of News Events)
- ... traditional workstation and Web tools used by iSeries programmers. These include VisualAge for RPG, CODE, the WebFacing tool, WebSphere Studio Site Developer Advanced (the follow-on tool for both VisualAge ...
- Created on 17 November 2002
- 2593. The Way We Word: Record-Level Access Revisited!
- (Microsoft)
- ... is very like establishing a keylist in RPG. You can use all of the key fields or the first few. If you use more than one, you have to go in order, following the defined key. For example, if your file is ...
- Created on 17 November 2002
- 2594. Weaving WebSphere: Shedding Light on Eclipse
- (Development Tools)
- ... intended to eventually completely replace the older set of programs that made up the WebSphere Development Tools (WDT), such as CODE/400 and VisualAge for RPG. Already they have replaced VAJ, WebSphere ...
- Created on 10 November 2002
- 2595. SQL vs. OPNQRYF--The Battle Continues
- (Business Intelligence)
- ... AS/400 and iSeries for those of you whose world began with AS/400), we lived with "just" logical files and RPG. Then, IBM decided to put a command interface (CL command) around the dynamic database component. ...
- Created on 05 November 2002
- 2596. The Land of the /free
- (RPG)
- Use free-format ILE RPG to liberate your applications. In V5R1, ILE RPG (RPG IV) was given a facelift with the addition of a free-format coding option. This option allows ...
- Created on 03 November 2002
- 2597. Case Study: BOScom's Jadvantag
- (Case Studies)
- ... program for the AS/400 in CL and RPG. Then, it just took a couple of hours to set up the portal. Our physicians appreciated that they did not have to retrain their staff, who continue to sign on to the ...
- Created on 03 November 2002
- 2598. How Could Life Be Better?
- (RPG)
- Want flexibility? Improve your life by using C I/O instead of RPG opcodes! When thinking about an RPG application and the file I/O necessary to accomplish a given task, you can thank your lucky stars ...
- Created on 27 October 2002
- 2599. TechTip: Defining Prototypes in a /COPY File
- (RPG)
- When defining prototypes in a /COPY file, you may want to define return values or parameters LIKE some of the fields in an externally described file. This works fine if all the programs using the /COPY ...
- Created on 27 October 2002
- 2600. The Midrange Manager: What's in Your 2003 IT Budget
- (RPG)
- IT education should be.This is the time of year when many iSeries IT managers are reviewing or planning their budgets for 2003. Granted, some do it at other times of the year because of fiscal year planning, ...
- Created on 22 October 2002