- 2401. Tips and Techniques: API Prototypes Potpourri
- (RPG)
- Free source code? That's something to be thankful for!Late last month, a discussion ensued on some of the online email lists regarding IBM's apparent inability to ship the prototypes for OS/400 APIs in RPG ...
- Created on 10 November 2004
- 2402. Weaving WebSphere: WebSphere and .NET, and What's a Longhorn, Anyway
- (Development Tools)
- ... few months, we've done a good job of cutting through the hype that hindered objective comparisons of Java, SQL, and RPG. Clearheaded analysis showed that each tool has its place. Some shops will never need ...
- Created on 07 November 2004
- 2403. TechTip: Preventing Record Lock, Part 2
- (RPG)
- ... to his technical skills (RPG IV, CL, OS/400, SQL, FTP, Query, VB, Net.Data), Kevin possesses the ability to communicate new and complex concepts to his students. He has been the primary instructor for ...
- Created on 04 November 2004
- 2404. Tips and Techniques: Checking for F3/F12 from an IBM Command
- (RPG)
- ... ALLOW(*IPGM *BPGM *IMOD *BMOD) You have two choices for the program to call when this command is run. You can use either the CL example listed below or the RPG IV program listed after the CL (but ...
- Created on 02 November 2004
- 2405. Client/Server Architecture
- (General)
- The best architecture for iSeries development is RPG business logic servers accessed by the client of your choice. That's it. The gloves are off. It's time to make a stand here. No more beating around the ...
- Created on 24 October 2004
- 2406. TechTip: Read Printer Output with Qshell
- (CL)
- Spool files are not for output only!Everybody knows that spool files contain output, right? Well, that's not necessarily true. SPOOL is an acronym meaning Simultaneous Peripheral Operations Online. Spooling ...
- Created on 21 October 2004
- 2407. Let's Write a Procedur
- (RPG)
- Should we use uppercase, lowercase, or mixed case?Exporting procedure names is a bit confusing. By default, RPG IV procedure names are exported with the name specified in positions 7 to 21 of the Procedure ...
- Created on 19 October 2004
- 2408. Tips and Techniques: Evaluate This!
- (RPG)
- "Variable not found." When will I learn? Time after time, I've used the ILE debugger to debug RPG IV applications, yet when I receive the following message, I'm at a loss as to what to do next: "Variable ...
- Created on 19 October 2004
- 2409. Case Study: BCD WebSmart
- (Case Studies)
- ... to an iSeries Model 810. The need for the upgrade, says Gossett, "...wasn't because of WebSmart; it was because of dealer utilization."Gossett, an RPG programmer by trade, says WebSmart's high points include ...
- Created on 17 October 2004
- 2410. The IBM Software Name Game
- (Commentary)
- ... got in your development shop is a bunch of older RPG programmers who are still struggling with the transition to J2EE or programmers who cut their teeth on procedural languages and are still wrestlin ...
- Created on 17 October 2004
- 2411. Weaving WebSphere: WDSC 5.1.2 JavaServer Faces--Fifty Ways to List Your Data
- (Development Tools)
- ... the "model" to use when developing applications. Until recently, the argument has centered on JSP Models I and II. For RPG programmers, it's probably easiest to explain these in reverse form: ...
- Created on 10 October 2004
- 2412. TechTip: Preventing Record Lock, Part 1
- (RPG)
- ... he also provides customers with project management, system design, analysis, and technical construction. In addition to his technical skills (RPG IV, CL, OS/400, SQL, FTP, Query, VB, Net.Data), Kevin possesses ...
- Created on 07 October 2004
- 2413. Tips and Techniques: A "Simple" CGI Progra
- (RPG)
- ... MOVIES and put the HTML in there. This technique does use HTML stored on the IFS. This CGI program requires the CGILIB, which is part of the RPG xTools. It can also be easily converted to use the popular ...
- Created on 05 October 2004
- 2414. A Few V5R3 CL Enhancements
- (CL)
- After all these years, CL gets some of IBM's attention. Last week was an interesting time for me. RPG World in Orlando was about to be another big success, echoing last year's record attendance, but then ...
- Created on 05 October 2004
- 2415. Reduce Indicator Usage
- (RPG)
- Have you considered using display attribute fields?As IBM continues to enhance RPG to allow reducing the use of indicators, RPG developers should also be looking for ways to decrease the use of indicators. ...
- Created on 03 October 2004
- 2416. Microsoft Computing: The iSeries in Your Windows Network
- (Microsoft)
- ... data. Using the APIs in, say, an RPG program gives you the same high level of control you've come to expect. These iSeries APIs read stream file data: Open Read Write Close __errno Each is referenced ...
- Created on 26 September 2004
- 2417. TechTip: Excel Flies Higher with JExcelApi
- (Microsoft)
- ... RPG, it relies on an open-source set of Java APIs written by the POI-Jakarta team. Because RPG starts the JVM the first time you call a Java method and then leaves the JVM on, this utility is very useful ...
- Created on 23 September 2004
- 2418. TechTip: Debugging Pointers
- (RPG)
- It's all in the pointer variables.In the debugger, you can see the data that a pointer is pointing to even if you don't have a variable that is based on the pointer. When debugging an RPG or COBOL program, ...
- Created on 16 September 2004
- 2419. Sorting and Searching Arrays Becomes More Manageable in V5R3
- (RPG)
- ... may be used with dynamic arrays. With the rise in new CGI programs and efficient storage utilization, using an array with a dynamic number of elements is becoming standard practice for RPG IV programmers. ...
- Created on 14 September 2004
- 2420. Tips and Techniques: Converting Date to Decimal to Date
- (RPG)
- ... This standard obviously came from the Y2K era and supports RPG III as well as RPG IV. RPG III does not recognize date data type values in database files, so using true date data types would not have been ...
- Created on 14 September 2004
- 2421. Weaving WebSphere: WDSc 5.1.2 Quick Look--EGL, the Next Generation
- (Development Tools)
- ... 3GL languages are languages like RPG and COBOL (and C and Java and Visual Basic) that have their own syntax, in which each line of code can generate dozens of lines of assembly language (and through calls ...
- Created on 12 September 2004
- 2422. TechTip: Accessing Packed Data in "Flat" File
- (SQL)
- ... A customer master file developed on the S/36 in RPG II would look something like the example shown in Figure 1. Figure 1: This Customer Master flat file came from RPG II. (Click images to ...
- Created on 09 September 2004
- 2423. Microsoft Releases Host Integration Server 2004
- (Commentary)
- ... or .NET server components. The TI project type includes multiple views (host, COM, .NET) as well as import/export wizards for COBOL and RPG host source code. In addition to WIP, TI offers a new approach ...
- Created on 05 September 2004
- 2424. TechTip: Download Physical Files Using Microsoft Excel
- (Microsoft)
- ... views of this data. The development staff often provides these views in the form of reports either by creating a high-level language program (RPG or COBOL) or by writing a query. iSeries shops have given ...
- Created on 02 September 2004
- 2425. Word Wrap: Green-Screen Pagination
- (RPG)
- ... writer/author, and software developer. His popular RPG xTools add-on subprocedure library for RPG IV is fast becoming a standard with RPG developers. His book The Modern RPG Language has been the most ...
- Created on 31 August 2004
- 2426. Tips and Techniques: ENTFLDATR
- (RPG)
- ... Figure 1: Here's a sample display file using the ENTFLDATR keyword. Bob Cozzi is a programmer/consultant, writer/author, and software developer. His popular RPG xTools add-on subprocedure library for ...
- Created on 31 August 2004
- 2427. TechTip: Use Prepared Statements with ADO to Access iSeries Data
- (Microsoft)
- ... primary responsibility is providing iSeries education, but he also provides customers with project management, system design, analysis, and technical construction. In addition to his technical skills (RP ...
- Created on 26 August 2004
- 2428. Linux: How Important Is It to the IBM i5?
- (Commentary)
- ... The answer is very sobering. RPG: Most AS/400 and iSeries boxes in use today run a mixture of legacy RPG code and ILE RPG, with a smattering of Java, COBOL, and C applications that were ported from ...
- Created on 22 August 2004
- 2429. Tips and Techniques: UPC or Item Number Entry Made Easy
- (RPG)
- ... scanner support to your applications; you just need to plug in the scanners. Bob Cozzi is a programmer/consultant, writer/author, and software developer. His popular RPG xTools add-on subprocedure library ...
- Created on 17 August 2004
- 2430. CGI and PHP: Alternatives to WebSphere
- (Web Languages)
- ... business decisions, and your mileage may vary. If you were to ask me what I think the theoretical "best" solution is, I would say that in most cases JSP Model II with an RPG back-end is the best, ...
- Created on 15 August 2004
- 2431. TechTip: Buffering--Friend or Foe?
- (System Administration)
- ... create a problem. Suppose your job has CL program A calling RPG program B to create a work file and RPG program C to process the work file and create a report.When program B ends and program C begins ...
- Created on 12 August 2004
- 2432. Weaving WebSphere: SSH, SSL, and Kerberos
- (Development Tools)
- ... issue on the mailing lists lately for everything from SQL vs. native I/O to Java vs. RPG. In this case, it means using the security mechanism that is appropriate for the job at hand. Kerberos and single ...
- Created on 08 August 2004
- 2433. Tips and Techniques: Trim Leading and Trailing Characters as Well as Blanks
- (RPG)
- RPG IV now provides important new trim function.In OS/400 V3R1, IBM introduced the %TRIM, %TRIML, and %TRIMR built-in functions. Effectively, these built-in functions delete trailing and/or leading blanks ...
- Created on 03 August 2004
- 2434. Move Data to Excel or CSV Format
- (RPG)
- ... of us, I recommend using CPYTOIMPF only when nothing else is available. The RPG xTools' CPYTOCSV command also creates CSV files for Excel or other applications. It stores these CSV files on the IFS. End ...
- Created on 03 August 2004
- 2435. Is Your Skill Set Starving?
- (Commentary)
- ... your knowledge of new technologies to meet the challenges of your job. Many of you feel that your basic RPG skills are sufficient: "They got me this far! They're good enough to get me where I'm going!" ...
- Created on 01 August 2004
- 2436. CGI, the Apache Web Server, and HTML Data Merging
- (RPG)
- ... use the prompts to manage that Web server. Since the focus of this series of articles has been CGI RPG IV programming, I am only interested in the configuration statements that relate to CGI programming. ...
- Created on 20 July 2004
- 2437. Tips and Techniques: Say Goodbye to Binary Fields
- (RPG)
- ... declare the so-called "integer" data type is not always intuitive. Below is a table that illustrates the cross-reference for I data types in RPG IV and other languages. Int 1 Int 2 Int ...
- Created on 20 July 2004
- 2438. Tips and Techniques: Dealing with /COPY and Embedded SQL
- (RPG)
- /INCLUDE solves problems with the SQL preprocessor.One of the most frequently asked questions I get is how to use the nested /COPY feature in RPG IV. This feature allows you to use /COPY to copy a source ...
- Created on 06 July 2004
- 2439. TechTip: Automatically Load Data into Excel
- (Microsoft)
- ... is providing iSeries education, but he also provides customers with project management, system design, analysis, and technical construction. In addition to his technical skills (RPG IV, CL, OS/400, SQL, ...
- Created on 01 July 2004
- 2440. Case Study: BCD's Nexus Porta
- (Case Studies)
- ... tractors and almost 8,000 trailers. Over the span of 18 months, Whitton occasionally discussed corporate portals with his staff of nine RPG programmers and one manager at weekly IT department meetings ...
- Created on 27 June 2004
- 2441. TechTip: Work with Data Returned from SQL SELECT Statements Using Cursors
- (SQL)
- At last, you can retrieve only the records that meet your criteria.How many RPG programs have been written that perform a data scan of an indexed file just to retrieve a subset of that information based ...
- Created on 24 June 2004
- 2442. Tips and Techniques: Processing Dates
- (RPG)
- Date formatting got easier with V5R3.Date processing continues to be a pain in the neck for many RPG programmers. RPG III still does not support true date fields, while RPG IV and DDS do. Consequently, ...
- Created on 15 June 2004
- 2443. Your First CGI Program
- (RPG)
- ... small-to-medium size AS/400/iSeries/i5 shops, it is just too big (read: bloated) to deal with. A few shops are choosing the right solution in my view, which is using CGI with RPG IV or JSPs. Both can ...
- Created on 15 June 2004
- 2444. The Linux Letter: Open-Source Web Serving
- (Linux / Open Source)
- ... programs, returning their output to the client's browser. These programs were typically written in C, particularly on UNIX servers. On OS/400, they were usually written in RPG and sometimes COBOL. On Linux, ...
- Created on 06 June 2004
- 2445. Case Study: ASNA's AVR for .NE
- (Case Studies)
- ... for Labatt are the AS/400 and ASNA's Visual RPG for .NET. Labatt has used ASNA's AS/400 technologies for years to connect Visual Basic (VB) to its AS/400s. Long a user of ASNA's COM-based products, Labatt ...
- Created on 06 June 2004
- 2446. Fixed Format: Is It an Addiction?
- (RPG)
- My name is Bob, and I'm a fixed-format programmer.We've been through these debates over and over. You know what I mean: those arguments that free format (/FREE) is somehow better than regular RPG IV. No ...
- Created on 01 June 2004
- 2447. Tips and Techniques: Copy Numeric Data to Character and Keep the Leading Zeros
- (RPG)
- ... This has led to numerous problems when attempting to move existing code to RPG IV's /FREE syntax. If you notice, the conversion tools do not convert MOVE/MOVEL operations to /FREE syntax, simply because ...
- Created on 01 June 2004
- 2448. IT Outsourcing or IT Out-Sorcery?
- (Commentary)
- ... for the new jobs that are growing in the rebounding U.S. economy. The Future of the RPG Contractor? But if the example of the U.S. Army's use of IT contracts is a measure of the kind of jobs that are ...
- Created on 30 May 2004
- 2449. Tangled Technology
- (General)
- ... language or C, when you were pretty much limited to a single language, or even early versions of RPG, when there were only so many ways of doing things. But nowadays, technology is bolting ahead by leaps ...
- Created on 30 May 2004
- 2450. TechTip: Using SQL with IFS Text Files, Part 2
- (SQL)
- ... of a table function must be pre-defined, but there is no limit to the number of rows that may be returned. RPG program ReadIFSFR is designed to serve as a table function that reads an IFS text file and ...
- Created on 23 May 2004