Power7 Webcast! Please join us On-Demand for Benefits of Migrating Now to Power7 presented by IBM i Power Systems marketing manager, Guy Paradise and Vision Solutions Services vice president, Peter Sa. In addition to learning about the significant IT and business benefits of migrating now to Power7, you will gain insight on how to smoothly make the upgrade without sacrificing your weekends, incurring data loss or business disruption.
Install SQuirreL SQL client to run interactive SQL on your IBM i.
Written by Tom Snyder
As you start using embedded SQL more frequently within your RPG code, you'll soon find that your SQL statements are becoming larger and larger and the interactive SQL tool on the green-screen starts becoming quite cumbersome. In this article, I will introduce Squirrel SQL, which is an open-source SQL client that gives you not only a better interface to your DB2 database, but also access to numerous other databases.
Upgrade your skills — and discover new ways to leverage the amazing IBM i — at the next RPG & DB2 Summit. Learn practical, use-it-today tips and techniques and get 1-on-1 advice from top experts Paul Tuohy, Susan Gantner, Jon Paris, Skip Marchesani, Scott Klement and others in a highly interactive, invigorating, fun environment. Hear the latest on RPG IV, DB2, embedded SQL, RPG & the Web, PHP, RDi, SQL tuning & more. Register by Feb 18 for just $1095 – save $300! Click to see the preliminary Session Grid.
Using an MD5 hash offers potential integration, performance, and security benefits.
Written by Michael Sansoterra
When developing modern applications or enhancing legacy ones, an RPG or DB2 routine may need to apply an MD5 hash to application data. Fortunately, IBM i/OS offers a machine interface operation called CIPHER to make the task of implementing MD5 relatively simple.