T.L. Ashford is “The Labeling Answer”® for the System i.
Ashford's Barcode400 has been the dependable choice for the industry since 1983. With Barcode400's newly enhanced Graphic Designer no “green screen” interaction is needed for label design. New features include: AFP/HP-compatible printing, easy-to-use graphics import tool, test print to desktop printer, simple font download tool, updated drivers and format listing reports. Even compliance labeling is made easy with design templates. Call 800-541-4893 to order your Fully-Functional, FREE Trial Software or visit us at T.L. Ashford & Associates.
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.
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.
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.