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 >>

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. Rpg sql insert into qtemp table (2015 views)
  2. What is better, free code or traditional code ? (1744 views)
  3. cant ping workstation from system i (1412 views)
  4. was 7 nd server not starting (1246 views)
  5. SQL Error 802 Type 6 - Numeric Handling for Joins? (566 views)
  6. ODF Release April 28, 2012 (490 views)

Forums

Search Sponsor

Search


Read More >>
   MC-STORE.COM