Let's explore the nuts and bolts of using embedded SQL: file type, syntax, and compiling.

Written by Tom Snyder

In a previous article, "Why Use Embedded SQL Within RPG?," I talked about why you would use embedded SQL in RPG. In this article, I will talk about how you could use embedded SQL within RPG. We'll start with an existing RPG program that is written with CHAIN and READ, and then we'll convert it to use embedded SQL.

Modernize Dated Green Screen Programs with BCD’s Presto You have a lot invested in your IBM i and in your green screen programs. Use BCD’s Presto to extract even more value from them:

• Satisfy users with an instant Web GUI

• Web enable ALL your IBM i screens

• Add rich web components to your existing screens

• No RPG, COBOL or DDS code changes. Start giving your

• users the modern screens they want today!

Learn More, Watch a Video or Download a 30-day Trial

Now that we've figured out how to receive them, how do we remove them if we want to?

Written by Bruce Vining

Last month, in "The API Corner: More on Message Handling," we looked at how to receive diagnostic messages (such as CPF3213 – Members for file more than maximum allowed) using the Receive Program Message (QMHRCVPM) API. The diagnostic message was needed in order to determine the underlying cause of an escape message (in our example, CPF7306 – Member not added) and then take the appropriate corrective action. The recovery action for CPF3213 was to change the file's MAXMBRS attribute to *NOMAX by using the Change Physical File (CHGPF) command and then adding the required member using the Add Physical File Member (ADDPFM) command. Both of these commands were run by the RPG application program using the Process Commands (QCAPCMD) API. However, after successfully adding the member, we noticed that the job log still contained the CPF3213 diagnostic message along with the two completion messages (CPC7303 – File SOMEFILE in library xxxxxx changed and CPC7305 – Member yyyyyy added to file SOMEFILE in xxxxxx) that were related to our handling of the initial CPF7306 error. Today's "API Corner" article looks at various options of how we can, if we want to, remove these messages.

Featured Products

WebSmart ILE lets you Modernize iSeries applications easier and has more integrated solutions to take you further! WebSmart is the easiest and most complete iSeries Web Application Development tool. WebSmart has everything you need to successfully develop new browser-based apps and modernize existing ones.

Whether you are part of a Fortune 100 or SMB organization, a one person shop or part of a larger team, you can immediately build new web applications or start transforming and modernizing legacy iSeries applications to real, professional-quality, database-driven Web applications. The PC based IDE is easy-to-learn, runs on HTTP Apache web server and does NOT need WebSphere. Create applications using Web Services, SOA, AJAX, XML, email, output to Excel, graphs. WebSmart offers these optional integrated solutions for complete modernization: • Clover Query • Free* Nexus Portal • Catapult • Free* RDW • SmartCharts (Free feature)

Learn more about Business Computer Design Int'l, Inc. and its products here.

T.L. Ashford's award winning BARCODE400 software is the labeling answer for the iSeries. With this versatile and easy to use software you will be designing and printing labels in minutes. Compliance labeling is a snap using templates provide by TL Ashford.

Learn more about T.L. Ashford & Associates and its Barcode and RFID solutions here.

Want to feature your company products? Click here or call (208) 726-6822 for information.