- 2251. Weaving WebSphere: Visual Studio vs. Eclipse (Round 1)
- (Development Tools)
- ... and I hope to bring you information that is as unbiased as one person can be. The good news is that regular readers of my columns already know my biases: the iSeries, RPG, JSP Model II, and Java, in about ...
- Created on 21 February 2006
- 2252. TechTip: JavaMail Is It!
- (Java)
- ... the JavaMail program on your iSeries box and how to use it to send email from within your RPG programs. It surpasses SNDDST in a number of ways: It is easy to use. It is easy to install. It can attach ...
- Created on 16 February 2006
- 2253. AJAX Isn't Just for Cleaning Dishes Anymor
- (Web Languages)
- Use AJAX to get squeaky clean browser-based applications.Until recently, moving to browser-based RPG IV applications has been limited because Web pages have to be reloaded or new pages need to be displayed ...
- Created on 14 February 2006
- 2254. Terminate the Teal Terminals
- (Commentary)
- ... new CIO may come in, review your applications, see your green-screens, and conclude that your department is hopelessly behind the times. And away go the iSeries and your RPG job! This is happening time ...
- Created on 14 February 2006
- 2255. Collaboration: Building the Application Team
- (Collaboration & Messaging)
- ... who remember them) The open-source movement Peer-to-peer file sharing (a la Napster) Wikis Blogs MMORPGs (massively multiplayer online role playing games) But even if I stick to the strictly business-oriented ...
- Created on 07 February 2006
- 2256. The Linux Letter: Open-Source Enterprise Databases
- (Linux / Open Source)
- ... interact with the database. DB2 has a plethora of them, including the traditional native access we've all used with RPG or COBOL. Other advanced enterprise DBMS features that are part of DB2 include triggers, ...
- Created on 07 February 2006
- 2257. 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
- 2258. 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
- 2259. 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
- 2260. 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
- 2261. 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
- 2262. 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
- 2263. 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
- 2264. 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
- 2265. 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
- 2266. 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
- 2267. 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
- 2268. 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
- 2269. 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
- 2270. 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
- 2271. 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
- 2272. 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
- 2273. 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
- 2274. 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
- 2275. 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
- 2276. 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
- 2277. 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
- 2278. 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
- 2279. 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
- 2280. 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
- 2281. 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
- 2282. 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
- 2283. 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
- 2284. 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
- 2285. 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
- 2286. 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
- 2287. 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
- 2288. 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
- 2289. 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
- 2290. 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
- 2291. 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
- 2292. 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
- 2293. 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
- 2294. 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
- 2295. 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
- 2296. 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
- 2297. 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
- 2298. 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
- 2299. 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
- 2300. 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