MC Systems Insight
MC Power Technology Manager
MC RPG Developer
MC Power Developer
MC TNT Tips 'n Techniques
MC AIX Expert
MC Linux Expert
MC Mobile on Power
This Week @ the MC Press Bookstore

June 4, 2010 | Volume 7 Issue 22


TOP STORY: TechTip: Do You Understand the DB2 for i Environment Settings?
FEATURED ARTICLE: Cast Your Vote in COMMON Europe's Global Survey
NEWS HIGHLIGHT: Bug Busters Announces New Releases of Both Menu and HA Systems
FORUM: Select Spool File from OUTQ
EVENT: Inexpensive i-series and ERP Document Archiving with Compleo Archivor
BLOG: System i Management Tips

Manage Subscription | Contact Us

Sponsor - T.L. Ashford & Associates
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.

Also, be sure to download the new white paper: Bar Code / RFID Label Printing, Don't get caught in the integration trap.


Feature Article - TechTip
TechTip: Do You Understand the DB2 for i Environment Settings?

Learn how to configure a DB2 for i SQL session, and discover the essential differences between DB2 for i and other relational databases.

Written by Michael Sansoterra

There are many non-IBM i developers out there who have opportunities to develop applications that interact with the i and its DB2 data store (aka AS/400, iSeries, i5, System i). These developers are many and varied and can include .NET and Java developers, Visual Basic and VBA developers, and Web and SQL developers of many stripes. Generally, these folks already have some level of experience with SQL. Basic SQL is generally portable among databases, but because of the unique nature of DB2 for i, developers need to understand some introductory concepts before tackling a DB2 for i project. This TechTip introduces a few important concepts essential for the i SQL environment.


Feature Article - Analysis
Cast Your Vote in COMMON Europe's Global Survey

Make sure your voice is heard and become eligible to win an iPod nano.

chris_smithWritten by Chris Smith

A reader casually asked why I began the MC TNT article earlier this month with a quotation from Hamlet. Obviously, word of COMMON Europe's upcoming conference in Stratford upon Avon, UK, the birthplace of Shakespeare, escaped him!


MC Industry Events Calendar

June 7th to June 11th:

ASNA Visual RPG for .NET Programming – Intermediat ... - Seminar

June 8th:

Symtrax: Compleo for SAP--Production Report Bursti ... - Webinar

June 10th:

LANSA: Modernization without Boundaries - Webinar  

June 15th:

ASNA System i Application Modernization: An Execut ... - DALLAS 

June 16th:

ASNA System i Application Modernization: An Execu ... - CHICAGO

June 17th:

ASNA System i Application Modernization: An Execu ... - ATLANTA

June 21st to June 25th:

SemTech 2010--Semantic Technology Conference - Conference

June 22nd:

Symtrax: Inexpensive i-series and ERP Document Arc ... - Webinar

June 24th:

LANSA: Modernization without Boundaries - Webinar


Have an event you want to list?  Send the information to today.


In the News

Support MC Press - Visit Our Sponsors

Forums Sponsor



 Search Sponsor




MC Industry Blogs

BLOG: System i Management Tips from Vision Solutions, Inc.


Latest Posting: 3/26/10 Additional ways to see the contents of a user space (*USRSPC)


01/29/10 How to determine the jobs or objects responsible for generating journal entries in a journal receiver?

12/17/09 How to search for text in a file at the member level

11/20/09 Simplify replication of devices between two systems by matching hardware resource names

10/21/09 Know the impact of using the ENDJOBABN command

10/2/09 How to rapidly set up a network printer using IBM Personal Communications