February 1, 2012 | Volume 11 Issue 3

ISSUE HIGHLIGHTS

TOP STORY: Practical RPG: Handling Abnormal Termination in Servers
FEATURED ARTICLE: Prompted SQL DDL Creation
NEWS HIGHLIGHT: IntelliChief Document Management Goes Mobile
WHITE PAPER: IBS and IBM Optimize ERP for Midmarket Distributors
FORUM: Get the Day of the Week, Full Text Date Values, and More Within RPG Using SQL
Manage Subscription | Contact Us

Sponsor - Business Computer Design
 
WebSmart is the fastest way to develop IBM i web applications. In under 1 hour you can download a free trial of WebSmart and have a fully functioning PHP or RPG web application to show your managers, even without prior web development experience! WebSmart is a proven (used by 1,000’s of developers), rapid IBM i & multi-platform Web Application Development tool for creating any type of web application for any business need.


Watch the video and learn how you can use WebSmart Program Templates to create web applications in minutes that give you a quick start.

 


Read More >>

Programming - RPG
 
Practical RPG: Handling Abnormal Termination in Servers

One of the hard parts of any server-based architecture is knowing when your server has been canceled; this article shows you how to address that.

joe_plutaWritten by Joe Pluta

I saw an email message in the midrange.com mailing lists the other day about the old standby for termination, the scope message. Scope messages are cool; using the QMHSNDSM API, you can identify a program to call when the job or call stack entry ends, and I'll address that another time. But I really like the CEERTX API. CEERTX is the ILE version of the concept and allows you to identify a procedure to be called if your call stack entry is terminated.


Read More >>

Sponsor - Profound Logic Software
 
Live Profound Logic and IBM Webinar: Five Things to Know About RPG Open Access!

RPG Open Access is now free of charge… but what does that mean to you? Is everything you’ve heard about modernizing with RPGOA true? Register for this LIVE webinar, and find out! Join IBM’s Alison Butterill and Profound Logic’s Brian May as they clear up common RPG Open Access myths. Learn why RPGOA is the best route for modernization and much more than just “screen scraping”! Register Now!


Read More >>

Programming - SQL
 
Prompted SQL DDL Creation

Not familiar with SQL CREATE TABLE syntax? No problem! There's a really easy way to create SQL DDL (Data Definition Language) statements.

sam_lennonWritten by Sam Lennon

IBM i developers are becoming more comfortable exploiting the power of SQL to retrieve and manipulate data. We regularly use the workhorse SELECT, UPDATE, and DELETE statements and can bang them out quickly with minimal syntax errors. Defining tables, indexes, constraints, and the like occurs less frequently, and consequently we are much less accomplished in the syntax.


Read More >>

Sponsor - The MC Press Bookstore
 
With RPG TnT: 101 Dynamite Tips ‘n Techniques, Bob Cozzi provides the solutions to dozens of technical dilemmas, gives you insights into resources formerly available only to a select few, and exposes RPG IV extensions that use his vast knowledge of System i MI instructions. Lift the code right out of the book and into your applications! RPG TnT provides a nearly endless supply of must-have solutions and simple yet powerful RPG tips and tools. Click now to learn more. >>
Read More >>

In the News

Read More >>
Support MC Press - Visit Our Sponsors

Forums Sponsor

POPULAR FORUMS
  1. News on IFSTOOL (2544 views)
  2. AS/400 RPG Programmer Analyst - Tampa, FL (Contract) (2117 views)
  3. I need to transfer a spool file(i.e. compile listing) to a PC file for editing (1851 views)
  4. Latest news on HSSFCGI (1663 views)
  5. Batch file in as400 (1452 views)
  6. Trigger bombing on program library (1213 views)
  7. Zip/Unzip now, don't wait for 7.1 (865 views)
  8. PHFA - 2 new Software Developer positions available (IBM i RPG ILE/Microsoft Dotnet) (507 views)
  9. The International Freedom of Expression Forum (484 views)
  10. A6005004 - Can't find console (327 views)

Forums

Search Sponsor

Search


Read More >>
   MC-STORE.COM