- 2201. Command Prompting 101
- (CL)
- Calling programs with parameters gets easier.Have you ever called an RPG or CL program from a command entry program, passed parameters to it, and had a problem receiving the parameter's data? This problem ...
- Created on 04 July 2006
- 2202. TechTip: Validating HTML Forms with Message Subfiles
- (Web Languages)
- ... Sheets (CSS), and a CGI-RPG program. If you think this sounds interesting, please read on.The CGI-RPG program is about 650 lines and because I have limited space here, I will not go into detail about every ...
- Created on 29 June 2006
- 2203. Is It Time for Free-Format?
- (RPG)
- I'm beginning to be willing to give it more of a chance.There are two primary reasons that I've not been a strong advocate for the free-format RPG IV syntax that was introduced with OS/400 V5R1: Most people ...
- Created on 20 June 2006
- 2204. Time Is Running Out
- (RPG)
- ... There is also an occasional reference to system *DTS format. The problem you have as an RPG IV programmer is that this format cannot be easily converted to a true RPG-style timestamp (Z data type) or ...
- Created on 20 June 2006
- 2205. Product Review: BCD's WebSmar
- (Product Reviews)
- ... process to create Web programs, a repository for business and presentation rules and database relations, and legacy code conversion tools to help migrate existing RPG logic and display file DDS to Web ...
- Created on 14 June 2006
- 2206. The Linux Letter: Open Source Meets the Phone System
- (Linux / Open Source)
- ... ones (like the RPG programs of old). Asterisk@Home Let's assume that you are interested in Asterisk, that you can see some potential places where it might be useful to you, but that you are uninterested ...
- Created on 13 June 2006
- 2207. TechTip: Meet a Powerhouse BIF: %replace!
- (RPG)
- The %replace BIF is loaded with character-string functions.Built-in functions are becoming common in the world of RPG IV programming, especially since the advent of free-format RPG. BIFs %eof and %found ...
- Created on 08 June 2006
- 2208. Simplified RC4 or AES Encryption
- (IBM i (OS/400, i5/OS))
- ... is available for free download at rpgiv.com/downloads. Here's how to do RC4 encryption using Qc3EncryptData and Qc3DecryptData: H BNDDIR('QC2LE') H DFTACTGRP(*NO) H OPTION(*NODEBUGIO:*SRCSTMT) ...
- Created on 06 June 2006
- 2209. TechTip: Retrieve Multiple Result Sets from a Stored Procedure
- (General)
- ... Incidentally, while this sample stored procedure is written in SQL, the same thing can be accomplished by writing stored procedures in a high-level language such as RPG or COBOL using embedded SQL.So ...
- Created on 25 May 2006
- 2210. High Availability: Designing for iSeries Journaling
- (IBM i (OS/400, i5/OS))
- ... to be canceled in process if the user feels the transaction is erroneous. There are numerous methods to take advantage of commitment control within i5/OS, including using SQL-based applications, RPG, COBOL, ...
- Created on 23 May 2006
- 2211. Get a Clear Picture of Your Database
- (System Administration)
- ... of Re-engineering RPG Legacy Applications and The Programmer's Guide to iSeries Navigator as well as the self-teach course “iSeries Navigator for Programmers.” He is also one of the quoted industry experts ...
- Created on 23 May 2006
- 2212. Data Structure Templates
- (RPG)
- ... C endif C endfor In this example, the CGI functions included free in RPG xTools are used to extract data from an HTML Web page. Assuming an online shopping ...
- Created on 16 May 2006
- 2213. If You Can Read This...
- (IBM i (OS/400, i5/OS))
- it's not encrypted.This week at RPG World in Las Vegas, nearly 200 attendees are upgrading their skills, learning new techniques, hearing about the direction of RPG and System i5, and connecting with their ...
- Created on 16 May 2006
- 2214. Weaving WebSphere: AIRPort Now Arriving
- (Development Tools)
- ... you'll see that there is nothing in the AIRPort Model I approach specific to JSP as opposed to RPG-CGI or PHP. In fact, you can easily use a combination of these techniques as needed (the only issue being ...
- Created on 16 May 2006
- 2215. System i5 Gains Integration and Collaboration Offerings
- (Analysis of News Events)
- ... goodies. The release includes XML parsers that iSeries developers can embed in their RPG, COBOL, C, and C++ applications. It also sports an Extensible Style Language (XSL) transformer that translates XML ...
- Created on 14 May 2006
- 2216. Women in IT Speak Out
- (General)
- ... to the science and math fields and decided in high school, where she was already learning RPG, that she wanted to be a programmer. She was one of the few women she knew who had these interests. "I always ...
- Created on 14 May 2006
- 2217. TechTip: Debugging CGI Programs
- (RPG)
- Do it with either the Apache Web server or the original AS/400 HTTP Web server.This TechTip will show you how to debug CGI programs in a green-screen environment. Before we start, I expect a few things ...
- Created on 11 May 2006
- 2218. Collaboration: Portal and AJAX
- (Web Languages)
- ... are Java programs that run in a Java Virtual Machine (JVM), while CGI programs are any other language (Perl, PHP, RPG, Python, you name it). "But what about JavaServer Pages (JSPs)?" you ask. ...
- Created on 09 May 2006
- 2219. V5R4 SQL Enhancements
- (SQL)
- ... ILE RPG. In this article, we'll explore these changes and see how they'll make your life easier. Special Registers and Scalar and Aggregate Functions In V5R4, a new set of functions has been added to ...
- Created on 09 May 2006
- 2220. Product Review: BOSaNOVA Launcher/400
- (Product Reviews)
- ... with all OS/400 and i5/OS versions since V4R2 and works with all iSeries programming languages, including, among others, RPG, CL, COBOL, and C, as well as 4GLs. It also supports all standard SQL commands, ...
- Created on 08 May 2006
- 2221. AJAX: The Java Killer?
- (Web Languages)
- The king is dead; long live the king.I recently wrote an article on Asynchronous JavaScript and XML (AJAX) as it applies to the iSeries and RPG. Since then, I've been researching AJAX to the extent that ...
- Created on 02 May 2006
- 2222. Computer Naming for Dummies
- (Commentary)
- ... I am certainly no whiz when it comes to product naming myself, although I think I did come up with some good ones over the years, including Visual RPG, Midrange, Q38, iSockets, and RPG xTools. However, ...
- Created on 02 May 2006
- 2223. TechTip: System Catalogs
- (RPG)
- Once you understand them, programming becomes simpler.A system catalog is essentially a database file that i5/OS maintains behind the scenes and then uses to track objects and other information on the ...
- Created on 27 April 2006
- 2224. Weaving WebSphere: EGL Revisited
- (Development Tools)
- ... I also want to attach directly to a DB2 database on the System i as well as call RPG programs, all of which require a bit more setup than in the tutorial. No Language Is an Island Well, they shouldn ...
- Created on 25 April 2006
- 2225. Tips and Techniques: Use JOBDs to Store Library Lists
- (RPG)
- ... subprocedure in RPG xTools for a few years, but I never thought about using the JOBD object as a storage media for library lists. This concept works perfectly in practice. Create a job description and ...
- Created on 18 April 2006
- 2226. Copying Data to MS Excel
- (Microsoft)
- ... can be integrated into RPG IV, provided you have strong Java and RPG IV subprocedure/prototyping skills. If you're a hacker and can decipher MS technical specifications, consider looking at the OpenOffice ...
- Created on 18 April 2006
- 2227. The System i Strategy for New Customers
- (Commentary)
- ... traditional System i developer community. Many traditional System i programmers would prefer to see RPG given a new name as a scripting language and have IBM actively develop and promote the language ...
- Created on 09 April 2006
- 2228. Tips and Techniques: Converting Subroutines to Subprocedures
- (RPG)
- The trickiest part to writing subprocedures is just getting started.(Author's Note: This technique came from On-Line Streaming Video RPG IV Training, where you can find more tips like this one.) One barrier ...
- Created on 04 April 2006
- 2229. Case Study: Linoma Software's Surveyor/40
- (Case Studies)
- ... for doing all of the necessary RPG, Visual Basic, and Web server programming, including all of the enterprise programming on the more than 30 servers—both iSeries and other platforms—that the company has. ...
- Created on 04 April 2006
- 2230. Piracy, Bootlegging, and Copying
- (Commentary)
- ... I love the System i5 market, and specifically I love all the cool inventions one can create with RPG IV and OS/400 APIs. This is an exciting platform, no matter what those Linux weenies say. If IBM gave ...
- Created on 04 April 2006
- 2231. TechTip: The Call Hierarchy View in WDSC
- (Development Tools)
- Every day, it seems I learn new features of WDSC, and almost immediately I wonder how I was able to live without some of them. Today's example is a fairly obscure little piece of Java coding magic. RPG ...
- Created on 23 March 2006
- 2232. Oh, Those Pesky Character Sets
- (RPG)
- But finally, there's a solution. Did you know that national language support, or character sets (CCSIDs), behave differently than you might expect? If you have an RPG IV source member that you compile ...
- Created on 14 March 2006
- 2233. Tips and Techniques: Encrypting Text
- (RPG)
- You have multiple methods to choose from.Encrypting data in RPG IV is becoming more and more necessary. IBM supplies two methods for encrypting text: The CIPHER MI instruction—This instruction has been ...
- Created on 14 March 2006
- 2234. TechTip: Constants Are Your Friends
- (RPG)
- The question is when, where, and how to use them.In that past few weeks, I have had several (sometimes heated) discussions regarding constants. Mostly, the discussions have revolved around when and how ...
- Created on 09 March 2006
- 2235. Converting Between Character Sets
- (RPG)
- ... than the one used by QtqIconvOpen. iconv() converts data. iconv_close() destroys the conversion environment. QtqIconvOpen creates a conversion environment using a more RPG-friendly conversion ...
- Created on 28 February 2006
- 2236. iSockets for Web Services
- (General)
- Easily call CGI and Web services from within RPG IV with iSockets and the XML-INTO opcode.With the advent of V5R4, RPG IV can be used to do basic parsing of XML natively. The new XML-INTO opcode, while ...
- Created on 28 February 2006
- 2237. The Excitement and the Challenge of Marketing i5
- (Commentary)
- ... does teach RPG skills because we still have a big "custom base" of clients that have custom RPG applications and who are looking for skills to keep upgrading those applications. But we teach both RPG and ...
- Created on 26 February 2006
- 2238. TechTip: What Are Model Files?
- (CL)
- ... to eliminate the CL driver program altogether. Consider this RPG F-spec that uses DSPOBJD's model file QADSPOBJ: FQADSPOBJ IF E K disk extfile('QTEMP/QADSPOBJ') usropn The RPG compiler ...
- Created on 23 February 2006
- 2239. Product Review: BCD's WebSmar
- (Product Reviews)
- ... (HTML, CSS, JavaScript, Flash, etc.) and the server-side component (a robust programming environment that uses a language similar to free-format RPG for writing your application logic). In addition, the ...
- Created on 22 February 2006
- 2240. 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
- 2241. 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
- 2242. 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
- 2243. 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
- 2244. 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
- 2245. 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
- 2246. 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
- 2247. 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
- 2248. 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
- 2249. 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
- 2250. 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