- 2301. Tell Me Your Processor Group
- (IBM i (OS/400, i5/OS))
- ... Abstract software for a client. (ASC's Abstract and ProData's DBU are two tools, along with RPG xTools, that I normally request that my clients install if they don't have them, but many already ...
- Created on 06 September 2005
- 2302. Tips and Techniques: Displaying Dates in Excel
- (Microsoft)
- If you've had formatting issues, read on.What? Isn't this an RPG column? It sure is. But copying data from the iSeries to CSV format for reading in MS Excel is extremely widespread throughout the iSeries ...
- Created on 06 September 2005
- 2303. TechTip: Education Opportunities from the iSeries Application Initiative
- (General)
- ... application development languages, from RPG to Java, with one of the most powerful databases available built right in and state-of-the-art software development tooling. Well, that's nice, but how do ...
- Created on 01 September 2005
- 2304. Rational's WDSC V6 Produc
- (Development Tools)
- ... EJB to RPG business logic connecting to a DB2/400 database. You could run on a roomful of Windows machines, a cluster of Linux boxes, or a single iSeries. This would be the killer development app that ...
- Created on 28 August 2005
- 2305. Installing and Updating System Firmware
- (IT Infrastructure - Other)
- ... before that, he worked in architecture and development for P5 and pSeries P4 firmware and the AIX operating system. Before joining IBM in 1984, he developed applications in RPG. Stephen can be reached ...
- Created on 28 August 2005
- 2306. Product Review: ASNA's DataGat
- (Product Reviews)
- ... databases without any code changes. DataGate for SQL Server allows RPG programmers to access Microsoft SQL Server data through native RPG file IO using familiar RPG operation codes such as CHAIN and ...
- Created on 17 August 2005
- 2307. Are You Proactive or Sedentary?
- (RPG)
- ... on the email lists, on the RPG IV forum at RPGIV.com, at RPG World, and elsewhere. Compare that to over 500,000 systems installed worldwide, and you're talking about one half of 1%; that percentage isn' ...
- Created on 16 August 2005
- 2308. Tips and Techniques: '00208' Is Possible in Free-Format
- (RPG)
- ... results in szText containing '00208'. (Note: The 'X' edit code is an RPG-specific edit code and is not available if you're using DDS or other editing tools, such as the "Edit" APIs.) If you want to ensure ...
- Created on 16 August 2005
- 2309. So You've Moved to an i5 Platform
- (IBM i (OS/400, i5/OS))
-
... for P5 and pSeries P4 firmware and the AIX operating system. Before joining IBM in 1984, he developed applications in RPG. Stephen can be reached at
This email address is being protected from spambots. You need JavaScript enabled to view it. Schmieding is an IBM Certified ... - Created on 14 August 2005
- 2310. TechTip: Simple Error Handling in Embedded SQL
- (SQL)
- ... what to do in case of one of the errors: CONTINUE--Continue with the next statement in your program GOTO (or GO TO) label--Go to a point in the program indicated by "label." In RPG, that would be a label ...
- Created on 11 August 2005
- 2311. Weaving WebSphere: We're off to See the Wizar
- (Development Tools)
- ... model. Gone is the nearly 100% RPG or COBOL product with huge, monolithic green-screen applications. Today's world requires a multi-language, Web-based environment where your products work not only with ...
- Created on 07 August 2005
- 2312. TechTip: Using *PSSR: The Good, the Bad, and the Ugly
- (RPG)
- ... you first. One of the examples given in the RPG ILE reference uses the SCAN opcode with a starting scan location of zero, as shown below: C 'B' scan field:zero The code above will ...
- Created on 04 August 2005
- 2313. Reprogramming the SysReq Key
- (RPG)
- ... writer/author, and software developer of the RPG xTools, a popular add-on subprocedure library for RPG IV. His book The Modern RPG Language has been the most widely used RPG programming book for nearly ...
- Created on 02 August 2005
- 2314. Subroutines vs. SubProcedures
- (RPG)
- ... This is also an opinion (a foolish opinion in my opinion, but an opinion nonetheless). If RPG had had subprocedures since its early days, IBM would not have created subroutines. Why? Because subprocedures ...
- Created on 02 August 2005
- 2315. Case Study: BCD's WebSmar
- (Case Studies)
- ... A few years ago, despite numerous distractions, the opportunity to go forward presented itself. Together, they formed JJ Able & Company. Both men had extensive experience in using RPG and COBOL to develop ...
- Created on 31 July 2005
- 2316. Performance and Parameters
- (RPG)
- We need to pay attention to the way we declare parameters. When I wrote the RPG xTools, I included a procedure that converts DB2/400 files to comma-separated values (CSV) format. Originally, I used this ...
- Created on 19 July 2005
- 2317. Product Review: Product Review: LANSA's LANSA 200
- (Product Reviews)
- ... hood. Given the developer's choices of native OS language, LANSA will then generate, say, RPG ILE or C/C++ code for iSeries, Windows, UNIX, or Linux. On the front-end, once again based on choices made ...
- Created on 11 July 2005
- 2318. Weaving WebSphere: Debugging iSeries HLLs in WDSc
- (Development Tools)
- ... dialog presented to create a file called QSOURCE. Right-click on the newly created source file and select New > Member. Create an RPGLE member called MATH (this will bring up an empty RPG editor). ...
- Created on 10 July 2005
- 2319. TechTip: Some Uses for Recursion
- (RPG)
- You've heard about it, but have you figured out how to use it?You've all read about recursion by now, but have you found uses for it? I'm going to discuss a couple of uses I've found. What Is Recursion, ...
- Created on 07 July 2005
- 2320. Convert Case Revisited and Updated
- (RPG)
- Try the QlgConvertCase API method.The need to convert lowercase to uppercase or vice versa has long been an issue in the RPG world. With the APIs available to RPG developers today, creating a subprocedure ...
- Created on 05 July 2005
- 2321. It's Summer, But Do You Know What Day of the Week It Is
- (RPG)
- ... to work on over the summer. It's called Zeller's congruence. Have you heard of it? Go to google.com and enter "Zeller's congruence" and see what turns up. It's always amazed me that RPG IV does math formulas ...
- Created on 05 July 2005
- 2322. Java Turns 10 at JavaOne
- (Analysis of News Events)
- ... Ironically, this is what many forward-thinking iSeries developers have been advocating for several years, albeit with technologies such as RPG that predate Java. These choices add up to one thing: For ...
- Created on 03 July 2005
- 2323. Where Programmers Come From
- (Commentary)
- ... that have a mystical meaning for them. Take, for instance, RPG. The Origins of RPG: A Different Kind of Creation Myth RPG is a programming language. Its true origins are now lost to history, but programmers ...
- Created on 03 July 2005
- 2324. Multilingual in an ILE World
- (RPG)
- ... in turn had a single entry point). However, the EPM was originally just meant as a proof of concept, and retrofitting it to RPG and COBOL was deemed unfeasible. Instead, the EPM was retired and a new concept, ...
- Created on 26 June 2005
- 2325. TechTip: Improving Free-Format Readability
- (RPG)
- Use this utility to get control of your free-format code.One of the great things about coding RPG programs in free-format is the pure fact that the rigid spacing requirements of RPG are gone. This fact, ...
- Created on 23 June 2005
- 2326. An Introduction to ILE Activation Groups
- (RPG)
- ... the functionality that you use ILE for. For example, an ILE RPG program compiled to use the default activation group cannot contain any subprocedures. The default activation group is used by all non-ILE ...
- Created on 19 June 2005
- 2327. Local User Groups: Out of Date or Coming of Age?
- (General)
- ... SAP shops, some went Microsoft) and the diverse interests of the target audience (old-fashioned RPG coders who weren't interested in the new, versus some folks focused on WebSphere, some on Java, etc.), ...
- Created on 19 June 2005
- 2328. Tips and Techniques: Getting Started with Procedures
- (RPG)
- Add a procedure to an existing RPG IV program.Writing a procedure can be fun, as I showed you in my article "Let's Build a Procedure." But getting started can be confusing and a little scary. In this short ...
- Created on 14 June 2005
- 2329. Apple Falls Far from the Tree
- (Commentary)
- ... Integration--Application programs could be developed using a language mix best suited to perform each required function. No longer were programmers limited to using RPG or COBOL exclusively. Reusability--Code ...
- Created on 12 June 2005
- 2330. Weaving WebSphere: Can WDSc Help Me with ILE?
- (Development Tools)
- Does WDSc's tooling for iSeries languages like RPG and CL match up to its Java support? "When I was younger, so much younger than today, I never needed anybody's help in any way." --John Lennon ...
- Created on 12 June 2005
- 2331. The Linux Letter: A Perl-Handled Knife
- (Linux / Open Source)
- ... MAXIMUM NBR OF CONSECUTIVE ESTIMATES/; $record_type = $NEW_CONNECTS if /^ +NEW CONNECTS AND RECONNECTS/; # Now look for what we RPG programmers would call a detail line. if (/^d/) { # detail lines start with the account number ...
- Created on 05 June 2005
- 2332. Tips and Techniques: Does Your File Exist on the IFS?
- (RPG)
- ... This C prototype doesn't do us much good in RPG. We need to convert it to an RPG IV prototype. Illustrated below is the RPG IV prototype for the access() procedure. D access PR 10I 0 ExtProc('access') D szIFSFile * Value OPTIONS(*STRING) D nAccessMode 10I 0 VALUE ...
- Created on 31 May 2005
- 2333. Extend iSeries Data to Microsoft Excel Efficiently and Transparently
- (Web Languages)
- ... case, .NET Web Services are an excellent option. Web Services can take advantage of your existing RPG programs and business logic to deliver data from iSeries to Excel or any other business application. ...
- Created on 29 May 2005
- 2334. Java: The "I" of the Tige
- (Java)
- ... our packed or zoned decimal fields in RPG. Better support for formatting and parsing these values has been added, making it much easier to write business arithmetic in Java (one of my personal negative ...
- Created on 29 May 2005
- 2335. TechTip: Populate Files on the iSeries from Oracle or SQL Server
- (DB2)
- And do it with RPG or CL.This TechTip explains how the iSeries can read data directly from DBMSs like Oracle and populate files on the iSeries. These files can then be used by native RPG applications for ...
- Created on 26 May 2005
- 2336. Case Study: BCD's WebSmar
- (Case Studies)
- ... it needs to keep these modern, clean, and well-lit facilities running, Kwik Trip relies on a Web-based extranet built by its own RPG developers with WebSmart, a leading Web application development tool ...
- Created on 22 May 2005
- 2337. TechTip: It's Easy to Join If You Know How to Chai
- (General)
- Confused about joins? Read on for clarification.RPG programmers are quite familiar with the CHAIN op code. COBOL programmers are equally as familiar with the random READ by key. However, many iSeries programmers ...
- Created on 19 May 2005
- 2338. Tips and Techniques: Inline Array Initialization
- (RPG)
- ... runtime or compile-time data), this article is for you. The first method to accomplish array initialization (aside from the legacy methods in RPG) is easy if you're OK with pointers. It doesn't require ...
- Created on 17 May 2005
- 2339. Dispelling the Myths of Java and WebSphere on the iSeries
- (Java)
- ... should you consider Microsoft .NET or keep trying to stretch your RPG dollar? Your first goal needs to be a change in mindset. To the dismay of some, categorizing something as "WebSphere on the iSeries" ...
- Created on 15 May 2005
- 2340. TechTip: No KLIST? What Do I Do Now?
- (RPG)
- New options are available to replace KLIST in free-format RPG IV.Many RPG IV programmers are starting to code in free-format but are still wondering how to handle the factor-1 search argument used in CHAIN, ...
- Created on 12 May 2005
- 2341. Weaving WebSphere: May Finds WDSc Ready to Bloom
- (Development Tools)
- ... an architecture, there are only two choices for most iSeries shops: JSP Model II and RPG CGI. I've spent a lot of time recently discussing the relative merits of these two architectures. I'm highly biased ...
- Created on 08 May 2005
- 2342. Hiding Email Addresses on Your Web Page
- (RPG)
- Outfox those dirty little "sniffer" programs.If you're like me, you receive a lot of unwanted postal mail, and yes, a lot of unwanted email. For me, posting my email address on MCPressOnline.com, RPGIV.com, ...
- Created on 03 May 2005
- 2343. Tips and Techniques: Removing Unwanted Messages from the Joblog
- (CL)
- ... had a response like the one we had for FTPSNDFILE was way back in 1984 when I published the Display Database File (DSPDBF) command. That RPG III program allowed you to view and change any database file, ...
- Created on 03 May 2005
- 2344. Java...Huh...Yeah...What Is It Good For?
- (Java)
- RPG rocks, Java jumps, but it's the combination of the two that really works. I've been getting a little Motown-ish lately. My little boy loves the stuff; he's got great taste in music. And given the rather ...
- Created on 24 April 2005
- 2345. FTP Made Easier
- (CL)
- ... can download the source from my RPGLab Web site. The command definition source code for the FTPSNDFILE command is reproduced below, but the RPG IV source of the command processing program is a bit too ...
- Created on 19 April 2005
- 2346. Third-Party Software
- (Commentary)
- Here's what you revealed in the last poll.In the last issue, we surveyed our readership and asked what keeps you from buying third-party programming tools such as utilities, add-ons for RPG IV, WDSc, or ...
- Created on 19 April 2005
- 2347. IT Hiring and Salary Trends for 2005
- (General)
- ... so they are designated as Not Applicable (NA). I feel it is safe to say that at least four out of five of the listings by recruiters are for the same openings. In other words, out of 295 RPG jobs nationwide, ...
- Created on 17 April 2005
- 2348. System Sentinel: Practical Exit Point Security
- (Security - Other)
- ... native security. This involved signing on and navigating to the "change department number" program through menu options. Then, on executing this RPG program, the relevant files were updated in the background.To ...
- Created on 17 April 2005
- 2349. Weaving WebSphere: Rationalizing the IBM Development Tools
- (Development Tools)
- ... integrate it in with WDSc. Theoretically, mind you. But you wouldn't get any support for testing, say, native RPG programs. So there's clearly a rift here. The larger problem to me is the fact that the ...
- Created on 10 April 2005
- 2350. TechTip: Spooled Files and PDF, Part Four
- (Document Management)
- ... REXX files in the correct sequence in order to create the CLE program TIFF2PDF, and compile all the RPG, CMD, and CLLE as usual. Try It If you already produce AFP reports, just run the AFP2PDF command ...
- Created on 07 April 2005