- 2251. Latest iSeries Software Release Has Much to Offer
- (Analysis of News Events)
- ... for RPG and COBOL—Last week's announcement included the debut of WebSphere Development Studio Client (WDSC) for iSeries 6.01. This point release includes a wizard that can transform ILE RPG and ILE COBOL ...
- Created on 05 February 2006
- 2252. Selecting and Deploying Portals
- (IT Infrastructure - Other)
- ... your own custom code to form bridges to other technologies (for example, to access SQL Server from WebSphere or to call an iSeries RPG program from .NET). With the portal frameworks, at least the vendor-specific ...
- Created on 31 January 2006
- 2253. TechTip: More iSeries PDF Wizardry
- (Document Management)
- ... into the pdf directory. Copy all the CLLE, CMD, and RPG programs into a source file and compile as usual. If you need to recompile all the above classes, run the ADDWMXPDFJ, CONCATPDFJ, and SCS2ITEXTJ ...
- Created on 26 January 2006
- 2254. iSockets: The Cool, New, Free Way to Do Web Services
- (RPG)
- ... I built RPG xTools, a set of nearly 200 subprocedures that make doing complex API calls or day-to-day RPG IV tasks easier. Enter iSockets iSockets is a service program that contains about a dozen ...
- Created on 17 January 2006
- 2255. Tips and Techniques: Compare and Ignore Case
- (RPG)
- It's as simple as my CompNoCase() subprocedure or C's memicmp(). For years, I hoped IBM would provide RPG IV programmers with the ability to compare two fields while ignoring upper/lowercase. Eventually, ...
- Created on 17 January 2006
- 2256. Use AJAX for Bright and Shiny Web Apps, Part 2
- (Web Languages)
- ... Show sample uses of that black box These steps assume some degree of familiarity with writing server-side code for Web applications using any Web server language, such as CGIDEV2 (RPG CGI), PHP, ASP, ...
- Created on 10 January 2006
- 2257. The Honeymoon Is Over
- (RPG)
- ... ILE compilers are two-phase compilers. The old RPG III compiler was essentially a single-phase compiler. So the compiled program was created directly from the source code. It's relatively easy to insert ...
- Created on 03 January 2006
- 2258. Happy New Year (Sort Of)
- (Commentary)
- ... and RPG IV is release-fragmented to the point that it is nearly impossible to teach an "RPG IV" course. You have to teach "RPG IV at V5Rx" (insert your release for the "x"). And now, the biggest frustration. ...
- Created on 03 January 2006
- 2259. TechTip: Overloading Indicators
- (RPG)
- Use this technique to reduce the number of required screen indicators."As IBM continues to enhance RPG to allow reducing the use of indicators, we as RPG developers should also be looking for ways to decrease ...
- Created on 29 December 2005
- 2260. Converting Data
- (RPG)
- ... first suggestion is to use the RPG xTools ToAscii() and ToEbcdic() subprocedures. They use a higher-speed and less-restrictive method to do the conversion than the alternative method I'll present here. ...
- Created on 20 December 2005
- 2261. Weaving WebSphere: EGL First Look
- (Development Tools)
- ... can create an entire application in one source file, which is certainly different from what we're used to in either in the green-screen world of DDS and RPG or the Web world of JSP and servlets. But ...
- Created on 11 December 2005
- 2262. Fun with Binding Directories
- (RPG)
- ... member from within CL programs. The source member must already exist, and the name must be correct. It does no error checking. The WRTSRCREC CL command and the RPG IV command processing program is listed ...
- Created on 06 December 2005
- 2263. Is Forced Encryption Another Y2K-Style "Public Works" Project
- (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 06 December 2005
- 2264. Vendors Seek to Simplify SOAs
- (Analysis of News Events)
- ... about ILE RPG support and will report on the company's answer once I receive it. Where's Microsoft? While SCA and SDO received ringing endorsements from several software market leaders last week, Microsoft ...
- Created on 04 December 2005
- 2265. TechTip: Checking for User-Changed Screen Data
- (RPG)
- ... I want to check for user-entered change in my RPG program. Here's an example: D* User Field Change Control D S1 DS D S1WO D S1WO2 D S1NO D S1DESC D S1LOCATION D S1REQLOC D S1@WO // Option 1=Add fields...D S1@NO D S1@DESC D P1 S like(S1) ...
- Created on 01 December 2005
- 2266. Product Review: Harkins Audit Software's Real-Time Program Audi
- (Product Reviews)
- ... that "audit-enables" RPG code. What this means is that it examines the source code and embeds auditing statements within it. The resulting expanded code is placed into a new file in order to ...
- Created on 30 November 2005
- 2267. Lazy Coding: A Programmer's Guid
- (Commentary)
- ... resources as possible! Be creative! For example, if a programming language has the ability to activate 99 indicators, as in the old RPG language model, turn them all on or off, randomly, with no particular ...
- Created on 20 November 2005
- 2268. TechTip: More Source Debugger Facts
- (CL)
- ... using CRTBNDRPG or CRTRPGMOD. Several keywords used in these commands control debugging options. First, the OPTION keyword can be used to control whether breakpoints are generated for input and output ...
- Created on 17 November 2005
- 2269. Variable Scope: Global vs. Local Variables
- (RPG)
- Do you know how and when to use each?Some people get slightly confused about the difference between declaring fields in the mainline calcs of their RPG IV source code and declaring variables inside subprocedures. ...
- Created on 15 November 2005
- 2270. Tips and Techniques: Displaying the Console
- (RPG)
- ... the console's seemingly endless ability to scroll text on the screen and return to command entry without stopping--a "wait a minute" command, if you will. Well, once again, it's RPG IV to the rescue...well, ...
- Created on 15 November 2005
- 2271. Geac Agrees to Billion-Dollar Acquisition
- (Analysis of News Events)
- ... as quickly as many of its rivals. In 2003, Geac did convert the code base to ILE RPG and enabled the applications to work with IBM's WebSphere middleware. However, the company found itself pressed for funding ...
- Created on 13 November 2005
- 2272. Weaving WebSphere: PTFs in WAS and Beyond
- (Development Tools)
- ... Group PTFs usually add features and fix leading-edge problems with things like SQL or WebSphere. If you run vanilla RPG applications, you might never apply a group PTF. But if you're doing extensive ...
- Created on 13 November 2005
- 2273. TechTip: The DSPREL Command
- (RPG)
- Are you having trouble getting in-depth information about your files? I had a problem. I needed to access a physical file that holds sales order information, but I needed it in a specific sequence. ...
- Created on 10 November 2005
- 2274. Living the Active (Server Pages) Lifestyle?
- (General)
- ... that use your iSeries database. I once created a complete application in a half a day using ASP that would've taken me a week of programming time in RPG. For more details and examples of creating ASP applications ...
- Created on 06 November 2005
- 2275. SORTA with Key Fields
- (RPG)
- Sorting arrays by field name is possible.RPG IV has a little-known feature that allows you to sort an array by any given location. "How?" you may ask. The answer: data structures. That's right; if you ...
- Created on 01 November 2005
- 2276. Tips and Techniques: Converting to Uppercase
- (RPG)
- ... we want to translate, so I had to use a nested %SUBST to make it work correctly. There are always multiple ways to do things in RPG IV. Finding the best solution is up to you. Bob Cozzi is a programmer/consultant, ...
- Created on 01 November 2005
- 2277. IBM Purchases DataPower Technology
- (Commentary)
- ... of the AS/400. On the AS/400, software consisted of the operating system and RPG. Neither could run on non-IBM boxes. The RPG compiled code communicated to hardwired terminals connected to the CPU using ...
- Created on 30 October 2005
- 2278. TechTip: LPAR and Dynamic Resource Movement
- (IBM i (OS/400, i5/OS))
- ... And this is the response from the API: Interpreting this reply requires a process called "parsing," which can be done in many ways: You can do it with RPG ...
- Created on 27 October 2005
- 2279. Type in the Data Type or You're Fired
- (RPG)
- ... are comfortable using them or when a shop standard is in place that advocates either. With RPG IV, using long variable names is nearly as easy as in any other programming language. Granted, we have our ...
- Created on 18 October 2005
- 2280. It's Time for a Na
- (RPG)
- ... Why not just use the DLYJOB CL command? Well, using CL commands in general is becoming more and more taboo lately. I think this is due to two advances: RPG IV's EXTFILE keyword on the File specification ...
- Created on 18 October 2005
- 2281. TechTip: A Couple Cool Cross Joins
- (SQL)
- ... 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 DMC's iSeries-based ...
- Created on 06 October 2005
- 2282. Declare Two Files with the Same Format
- (RPG)
- It's easy if you use qualified input field names. With OS/400 Version 5 Release 1, IBM introduced QUALIFIED data structures into RPG IV. This functionality gives the programmer the ability to refer to ...
- Created on 04 October 2005
- 2283. Tips and Techniques: Move Off of Resulting Indicators
- (RPG)
- ... that replaced the function of those old resulting indicators and opened RPG IV up to much more readable code. In fact, if IBM hadn't done this, creating the /FREE syntax would have been very difficult. ...
- Created on 04 October 2005
- 2284. TechTip: Little-Known Source Debugging Tricks
- (RPG)
- You can never have too many tricks up your sleeve when you're chasing bugs.One of my coworkers was having a strange problem the other day, and we were using the source debugger to trace down the cause. ...
- Created on 29 September 2005
- 2285. Case Study: BCD's WebSmar
- (Case Studies)
- ... using Web-based systems that are back-ended with RPG applications running on redundant IBM eServer iSeries Model 720s. These systems, developed with WebSmart from Business Computer Design, while conveniently ...
- Created on 26 September 2005
- 2286. WDSC and CVS
- (Development Tools)
- ... an RPG generator, and it writes the RPG code. Simple enterprise-level preferences identify whether to connect via Web Services or something like MQ Series. All pieces can be debugged via WDSC, and all ...
- Created on 25 September 2005
- 2287. TechTip: Spooled Files and PDF, Appendix B
- (Document Management)
- ... file in your iSeries. I assume you already installed the SCS2PDF utility and you already have your zlib c modules available in /pdf/zlib directory. Before running the REXX script, replace RPGDIR = 'QSCS4WEB' ...
- Created on 22 September 2005
- 2288. The Wheels Are Turning
- (RPG)
- ... CRTUSRSPC CL commands included with TAATOOLS and RPG xTools. So if you own either of those, you can use them. But remember, we want to reinvent the wheel here to prove a point. I was able to create ...
- Created on 20 September 2005
- 2289. Hex to Character Conversion Revisited
- (RPG)
- ... MI instructions back in the 1980s. It wasn't until IBM introduced System/C back in the mid 1990s that it became practical to use them outside of MI, but now with RPG IV's ability to call C and MI runtime ...
- Created on 20 September 2005
- 2290. Product Review: LANSA's LANSA 200
- (Product Reviews)
- ... using a LANSA template; RDML is generated under the 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. ...
- Created on 18 September 2005
- 2291. TechTip: PREPARE to DECLARE
- (SQL)
- ... a snippet of embedded SQL code from an ILE RPG program. C/Free SQL_Txt = 'SELECT CNAME, CADD1, CADD2, CADD3, CCITY, CSTTE' + ', CZIPC FROM CUSTOMERS WHERE STAT= '+ Qt + 'A' + Qt; C/END-Free C/EXEC SQL C+ PREPARE SQL_STMT FROM :SQL_Txt C/END-EXEC C/EXEC SQL C+ DECLARE Stmt CURSOR FOR SQL_STMT C/END-EXEC C/EXEC SQL C+ OPEN Stmt C/END-EXEC ...
- Created on 15 September 2005
- 2292. Case Study: Nutech Systems' Screen Mapper
- (Case Studies)
- ... Mapper is a series of RPG callable APIs that allow an RPG program to send keyboard input to another iSeries program. Screen Mapper updates target applications by calling existing programs and simulating ...
- Created on 12 September 2005
- 2293. Case Study: BCD's WebSmar
- (Case Studies)
- ... team at Draper began developing code with WebSmart by sharing tips with each other. These programmers, all with 10 to 20-plus years of RPG coding and little PC or HTML development to their credit, quickly ...
- Created on 11 September 2005
- 2294. Weaving WebSphere: WDSC6, Take One
- (Development Tools)
- The first thing we will look at is how WDSC6 enhances the RPG development experience?and it's not looking good. "Pay no attention to that man behind the curtain!" --The Great Oz We're in what ...
- Created on 11 September 2005
- 2295. 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
- 2296. 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
- 2297. 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
- 2298. 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
- 2299. 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
- 2300. 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