Execute a script that contains a single SQL statement, multiple SQL statements, or even CL commands!

By Skip Marchesani

Several years ago, I began using what is now called the Run SQL Scripts function (also known as the SQL Script Center or Script Center in iSeries Navigator or System i Navigator, respectively) to demonstrate various SQL functions and to answer SQL syntax and function questions when I teach SQL-related topics. Now that the SQL Script Center is becoming more widely known and used, when I teach and use it for demonstrations, I am getting more and more questions about how it works.

The #1 RPG Resource: The Modern RPG IV Language, Fourth Edition. In this latest edition RPG expert Bob Cozzi takes his classic best seller to a whole new level. Close to 700 pages, this book covers all of the new functions and facilities available in V5R4 RPG IV while keeping the straightforward, no-nonsense style that has kept it a best-seller for almost 20 years. Get your copy today!

Still stuck with legacy date and time fields in your database and programs? Let RPG IV do the heavy lifting for you.

By Sam Lennon

In V5R3, date-handling is superb and calculations are straightforward. Fine, you say, but what about all those pesky character or numeric fields we still have to fight with from designs that originated before the date- and time-field data types were available? Those fields might have two- or four-digit years and might be in YMD order or MDY order or, outside the U.S. , even DMY order. What about them?