- 2351. What Is the "Environment"
- (RPG)
- ... system. The job level environment is great for passing data between different types of programs. For example, it is extremely easy to pass data to the environment from within RPG IV and have that data ...
- Created on 05 April 2005
- 2352. Tips and Techinques: The VARY Keyword
- (RPG)
- ... Today, it is structurally similar to a variable-length field in RPG IV. A 2-byte integer, as it is called today, is appended to the front of the value. In RPG IV, there are two ways to receive this ...
- Created on 05 April 2005
- 2353. The iSeries: The Once and Future King
- (Commentary)
- ... later was a bullet point talking about "Java, .NET, RPG, or COBOL." RPG, folks! And even COBOL! The fact that RPG is actually on an IBM slide is cause for great cheer. And it wasn't a fluke, as ...
- Created on 27 March 2005
- 2354. TechTip: Access Packed Data in "Flat Files" with a Table Functio
- (SQL)
- ... In addition 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 ...
- Created on 24 March 2005
- 2355. Tips and Techniques: Sending Output via Remote OUTQs
- (CL)
- ... local printer. Imagine how dumb I felt after asking a few questions of some colleagues on the RPG newsgroups and email lists. Remote OUTQs You can actually do what I wanted to do by simply creating ...
- Created on 15 March 2005
- 2356. The Best Resume Gets the Interview
- (General)
- ... major accomplishments, etc. Here's an example:Summary of Experience: Over 15 years experience in programming, analysis, and systems design Excellent skills with RPG IV, RPG LE, RPG400 Software experience ...
- Created on 13 March 2005
- 2357. Weaving WebSphere: Careers in WDSc
- (Development Tools)
- ... t mean nobody uses it. Another SQL-related skill is something called "embedded SQL," also known as SQLRPG or RPG-SQL. With embedded SQL, you "embed" SQL statements directly into yo ...
- Created on 13 March 2005
- 2358. Make Your Career Shockproof
- (General)
- ... you are not actively seeking a new position. "If you see one ad for RPG and 10 for Oracle, that's a pretty good indicator of where the demand is," said Langieri. One problem is recognizing when a "hot new ...
- Created on 06 March 2005
- 2359. TechTip: Spooled Files and PDF, Part Three
- (Document Management)
- ... article. Now, download the code that accompanies this article; copy the SCS2ITEXT.class into the pdf directory; copy all the CLP, CMD, and RPG programs into a source file; and compile as usual. To get ...
- Created on 03 March 2005
- 2360. Back Up to the IFS
- (IBM i (OS/400, i5/OS))
- ... *NONE is specified, it is assumed that the stream file does not exist. To make this command work, I had to choose between CL and RPG IV. Since CL doesn't have built-in search capabilities, I decided ...
- Created on 01 March 2005
- 2361. Tips and Techinques: Create a Command Parameter That Accepts Commands
- (CL)
- ... have the tools to make it happen. Bob Cozzi is a programmer/consultant, writer/author, and software developer. His popular RPG xTools add-on subprocedure library for RPG IV is fast becoming a standar ...
- Created on 01 March 2005
- 2362. Data Access, Database Engines, and Persistence
- (DB2)
- ... of its languages accessed the same database (which we now know as DB2/400) via the same sorts of operations: RPG opcodes like SETLL, READE, and CHAIN or their COBOL counterparts. But as the AS/400 has ...
- Created on 27 February 2005
- 2363. IBM Launches New Initiative to Engage iSeries Partners
- (Analysis of News Events)
- ... At the same time, it acknowledges the strategic role that ILE RPG and the other ILE languages play in modernized iSeries applications. For the first time, the Roadmap also includes space for the modernization ...
- Created on 27 February 2005
- 2364. TechTip: Calling SQL from REXX
- (SQL)
- ... conjunction with program variables in your REXX program, much as you would in SQLRPG programs. This makes REXX very powerful for system management functions. I can use an OS/400 command to create an output ...
- Created on 24 February 2005
- 2365. Case Study: BCD's ProGen WebSmar
- (Case Studies)
- ... custom RPG and Web-based applications for more than 50 customers in Maryland, Pennsylvania, West Virginia, and Virginia. The majority of MCCI's customers are small and medium-sized businesses.Mason is a ...
- Created on 20 February 2005
- 2366. Don't Just Paint My Wall
- (RPG)
- ... are a few examples that illustrate some of the characteristics of quick fixes: Hard-Coding Values in RPG Code Hard-coding values has long been a problem with RPG in general. It wasn't until the 1990s ...
- Created on 15 February 2005
- 2367. Tips and Techniques: Date Values
- (RPG)
- RPG + CL = Better Date ManipulationOne of the cool things about CL (even though I rarely, if ever, use it anymore) is that it is extendable. But one thing it does badly is date manipulation. Effectively, ...
- Created on 15 February 2005
- 2368. IBM Workplace: More than Just Notes on Steroids
- (Commentary)
- ... information from the databases constructed by IT required considerable expertise? IT used compilers like RPG and advanced tools like Query to open the doors to the data. That changed with the arrival of ...
- Created on 13 February 2005
- 2369. Weaving WebSphere: The Data Perspective
- (Development Tools)
- ... also requires 5722ST1, so if you're compiling (not just running!) programs with embedded SQL (SQLRPG or SQLRPGLE), you also have Query Manager. STRSQL Query Manager leads us right into STRSQL. STRSQL ...
- Created on 13 February 2005
- 2370. TechTip: MOVEing Character to Numeric, the Free-Format Way
- (RPG)
- Without MOVE in free-format, use built-in functions!Those of us who "grew up" on RPG find it strange that there would be a need for character-to-numeric built-ins, since good old MOVE has done the job quite ...
- Created on 10 February 2005
- 2371. The Linux Letter: DB2
- (Linux / Open Source)
- ... not use the esoteric DB2 data types (such as data links). They are simply straightforward business applications. Furthermore, most of the applications are written in RPG (and a smattering of COBOL), further ...
- Created on 06 February 2005
- 2372. TechTip: Spooled Files and PDF, Part Two
- (Document Management)
- ... as in Figure 1. Figure 1: Create the required subdirectories. (Click images to enlarge.) Now, you can download the utility and move the RPGLE and REXX sources into the QSCS2PDF and all the .c and ...
- Created on 03 February 2005
- 2373. When Was I Born?
- (RPG)
- ... is located in library QSYSINC in the QRPGLESRC file in member QUSRJOBI. A data structure named QOBJI030000 is included in the normal poor-quality IBM format--meaning that the names are obscure, from-to ...
- Created on 01 February 2005
- 2374. Tips and Techniques: Converting Time
- (APIs)
- ... 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 widely used RPG programming book for more ...
- Created on 01 February 2005
- 2375. Lies, Liars, and Benchmarks
- (System Administration)
- ... the IT industry, and then I'm going to try to relate them to the world of midrange computers and specifically to the iSeries, RPG, and native DB2/400. I'll explain a little bit about what benchmarks do and ...
- Created on 30 January 2005
- 2376. Web Building with BCD's WebSmart and Nexus Porta
- (Web Languages)
- ... the company's two other Web development and deployment products, Nexus Portal and RPG/DDS to Web Conversion Tool (RDW). When asked about its iSeries market advantages, BCD draws a comparison to WebSphere, ...
- Created on 23 January 2005
- 2377. Product Review: Web Building with BCD's WebSmart and Nexus Porta
- (Product Reviews)
- ... WebSmart and the company's two other Web development and deployment products, Nexus Portal and RPG/DDS to Web Conversion Tool (RDW). When asked about its iSeries market advantages, BCD draws a comparison ...
- Created on 23 January 2005
- 2378. IBM Finally "Gets" Web Smar
- (Analysis of News Events)
- ... quickly create new Web apps while enabling them to extend existing RPG apps to the Web. It's a good alternative for iSeries shops that need to get their applications onto the Web but don't have the time ...
- Created on 23 January 2005
- 2379. Copying Data Faster
- (RPG)
- ... directly by prototyping the MI instruction. In RPG IV, the prototypes would appear as follows: D cpybla PR ExtProc('cpybla') D pTarget * Value D pSource * Value D nSrcLen 10I 0 Value D cpyblap PR ExtProc('cpyblap') D pTarget * Value D nTgtLen 10I 0 Value D pSource * Value D nSrcLen 10I 0 Value D cPadChar 1A Value ...
- Created on 18 January 2005
- 2380. Tips and Techniques: Subsetting WRKACTJOB
- (CL)
- ... command and using the page up/down keys to search for the job you're interested in. Bob Cozzi is a programmer/consultant, writer/author, and software developer. His popular RPG xTools add-on subprocedure ...
- Created on 18 January 2005
- 2381. Microsoft Makes Bids for PeopleSoft and SAP Customers
- (Analysis of News Events)
- ... That includes ASNA's Visual RPG for .NET, an RPG development tool that compiles to Microsoft's .NET intermediate language assemblies. As a result of this announcement, it is now easier for iSeries customers ...
- Created on 16 January 2005
- 2382. Weaving WebSphere: Happy New Year!
- (Development Tools)
- ... JTOpen package allowed us to access RPG programs and other QSYS objects directly from Java, but the continued extensions of RPG in V5R3 make it extremely easy to invoke Java objects from RPG programs. ...
- Created on 09 January 2005
- 2383. TechTip: Spooled Files and PDF, Part One
- (Document Management)
- ... and gives permission to anyone to prepare files in which the content conforms to PDF, I now present SCS2PDF, a simple but complete utility entirely written in RPG that converts iSeries spooled files into ...
- Created on 06 January 2005
- 2384. Tips and Techniques: Eliminate Function Key Response Indicators
- (RPG)
- ... byte in position 369 of the workstation data structure (WSDS). Using the *INKx indicators is one of the worst things you can do in RPG IV, so we won't bother with that technique. So that leaves the WSDS ...
- Created on 04 January 2005
- 2385. Execute Remote Stored Procedures from the iSeries
- (General)
- ... example, we'll have the iSeries execute a simple stored procedure on an SQL Server machine and return the results to an RPG program. This method is so transparent that you won't be able to tell whether the ...
- Created on 02 January 2005
- 2386. Should Companies Copyright Their Code?
- (Commentary)
- ... a brilliant new RPG program that successfully predicts the magnitude, the location, and the exact date and time of future earthquakes, based upon the number of angels that can be observed on the head of ...
- Created on 19 December 2004
- 2387. Character-Set This!
- (RPG)
- ... was the last time you used a compiler listing at all? RPG programmers worldwide largely use SEU to edit RPG. A few use more contemporary tools such as CODE/400 and CodeStudio, and even fewer use WDSc. ...
- Created on 14 December 2004
- 2388. Tips and Techniques: Delete Old Spool Files
- (RPG)
- ... To view this source member online or to download it directly, follow this link. The RPG IV source code for the DLTOLDSPLF program is listed below: H BNDDIR('XTOOLS/RPGLIB' : 'QC2LE')H OPTION(*SRCSTMT:*NODEBUGIO)H DFTACTGRP(*NO) ACTGRP('XTOOLS') ***************************************************** ** An example program that uses the RPG xTools. ** ** ----------------------------------------------- ** ** Delete Old Spool Files ** ***************************************************** ** See also... ** QCMDSRC(DLTOLDSPLF)D DltOldSplf PRD nDaysOld 5U 0 OPTIONS(*NOPASS)D szUsrPrf 10A OPTIONS(*NOPASS)D DltOldSplf PID nDaysOld 5U 0 OPTIONS(*NOPASS)D szUsrPrf 10A OPTIONS(*NOPASS) /INCLUDE XTOOLS/QCPYSRC,cprotos /INCLUDE XTOOLS/QCPYSRC,utils /INCLUDE XTOOLS/QCPYSRC,listsD MySplf S LIKE(RTK_SFL0200) ** How long before we delete the SPLF?D DFTExpired C Const(14)D szUser S 10A Inz(*USER)D today S D Inz(*SYS)D crtDate S D DatFmt(*ISO)D nExpired S 10I 0D nDays S 10I 0D nSplf S 10I 0D nPos S 10I 0 ...
- Created on 14 December 2004
- 2389. IBM vs. Microsoft in the Midrange
- (Analysis of News Events)
- ... AIX (UNIX), Linux, and Windows, all in a single footprint. It is a consolidation box designed to minimize the complexities of running IT. It can run legacy RPG and Fortran applications just fine, and it ...
- Created on 12 December 2004
- 2390. Weaving WebSphere: An Internet Christmas
- (Development Tools)
- ... typically several hundred pages long. They tend to cover a range of topics associated with a single general subject. One of the most popular of these has been Who Knew You Could Do That With RPG IV? A ...
- Created on 12 December 2004
- 2391. TechTip: Using SQL's Common Table Expression Functionalit
- (SQL)
- ... to breaking an RPG program into reusable modules). SQL queries can also reuse a CTE (like reusing an RPG module) by referencing the expression multiple times. Let's look at a simple example to help explain ...
- Created on 09 December 2004
- 2392. The Linux Letter: Coming to a Network Near You
- (Linux / Open Source)
- ... security to happen below the application level, where it will be more effective. As an analogy, consider the difference between trying to enforce security via your RPG programs (the application layer) ...
- Created on 05 December 2004
- 2393. TechTip: Preventing Record Lock, Part 3
- (RPG)
- ... This program retrieves the last record sent to the RPG program's program message queue and then reissues it as an informational message so that it can easily be displayed on the screen using common message ...
- Created on 02 December 2004
- 2394. Let's Build a Procedur
- (RPG)
- Take that next step toward writing true RPG IV code.Procedures (or "subprocedures," as are they are called in RPG IV) are the fundamental building blocks of all RPG IV applications. If you are not regularly ...
- Created on 30 November 2004
- 2395. Tips and Techniques: Qualifying Database Field Names
- (RPG)
- ... way to access the fields of the CUSTMAST file is through the qualified name syntax. Bob Cozzi is a programmer/consultant, writer/author, and software developer. His popular RPG xTools add-on subprocedure ...
- Created on 30 November 2004
- 2396. Execute Bound Procedures Dynamically
- (RPG)
- ... executing alternate versions of bound procedures. I recently needed to figure out how to do three things with ILE RPG: Configure an application with 100 or more parameters whose values vary by U.S. ...
- Created on 28 November 2004
- 2397. Service-Oriented Architecture (SOA)
- (General)
- ... talked to an RPG program running on the S/38 via terminal emulation. Basically, the RPG program on the S/38 had a single 256-byte input field and a corresponding 256-byte output field. The PC in the field ...
- Created on 28 November 2004
- 2398. TechTip: Display Colors in a 5250 Session
- (Networking)
- ... NON-DISPLAY,VA Figure 4: COLOR RPGLE program source Figure 5: This is the source member created by COLORCOM. You can copy individual lines to your own member to have color comments. ...
- Created on 18 November 2004
- 2399. What's New in V5R3 of iSeries Access for Window
- (System Administration)
- ... RPG or COBOL programs) and work with OS/400 and i5/OS system screens. Since the emulator runs natively on Windows, it provides maximum performance (compared to a browser-based solution), has keyboard mapping ...
- Created on 14 November 2004
- 2400. Case Study: BCD's WebSmar
- (Case Studies)
- ... much easier for us to pick up the WebSmart platform." He adds that other products didn't meet his expectations either: "We also looked at Seagull's products to create programs from RPG code-- these were screen-scraper-type ...
- Created on 14 November 2004