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

November 5, 2010 | Volume 7 Issue 44


TOP STORY: TechTip: How'd You Get Your SQL Server Data in My IBM i DB2 Data!?!
FEATURED ARTICLE: QuickLook: INPRO International TimeZoNe/400
NEWS HIGHLIGHT: ProData Announces Alliance with InterForm of Denmark
FORUM: Map Spool File Data to Overlay
TRIAL SOFTWARE: Free Trial of INPRO's TimeZoNe/400 (TimeZoNe Simulation Utility)
EVENT: ASNA Wings Webcast
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: How'd You Get Your SQL Server Data in My IBM i DB2 Data!?!

IBM DB2 Web Query integrates with Microsoft SQL Server.

robert_andrewsWritten by Robert Andrews

DB2 Web Query is a great tool for reporting and graphing data on IBM i. It has built-in capabilities that allow DB2 Web Query to access data on any IBM i Power System. This starts to bring the power of a federated database into IBM i. A federated database system is one in which a single system accesses data that resides on multiple database systems. In the past, data was often replicated from one system to another to allow this type of access. However, this leads to issues with data being out of date, out of sync, and out of control. To help extend federated database capabilities, DB2 Web Query introduced the Microsoft SQL Server adapter.


Sponsor - Business Computer Design
Reduce your PHP learning curve with WebSmart PHP for IBM i and multi-platform web development.

Watch a short video and see why WebSmart PHP is the fastest way for RPG, PHP and other programmers to develop web apps over DB2 and other databases. Its templates and wizards create HTML & PHP code for you and guide you through the process of creating professional looking Inquiry, Transaction Processing, and other apps in 5 minutes.

View the Video Now, Download a White Paper or a Free Trial.



Feature Article - Application Software
QuickLook: INPRO International TimeZoNe/400

Written by INPRO International

Override the computer's time based on the differential between the user's time zone and the system time zone.

Editor's Note: To download and try TimeZoNe/400 at no obligation, visit the MC Software Center.

TZN/400 V6.1.I (TimeZoNe/400 Simulation Utility) is a time zone tool that allows you to override the time based on the differential between the user's time zone and the system time zone through the year 3,000. It includes support for automatic rules-driven daylight-saving time (DST) around the world. It does this without costly LPAR support.The DDS/RPG/COBOL/ILE/Query/SQL called routines for TIME will now look to your users' time-zone offset. It takes the effort out of rewriting 9,000 modules and avoids expensive LPAR support.


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

MC Industry Events Calendar

November 10th to 11th:

AdvancedTCA Summit  Conference & Exposition

November 10th:

10:30 - 11:30 Vision Solutions: Uses and Features of Vision Repl ... Webcast / Webinar

November 11th:

12:30 - 13:30  How to get to the web with RPG and IBM i Webcast / Webinar

4:00 - 10:00  WMCPA Dinner Meeting Conference

November 15th to 19th:

The 400 School: Introduction to RPG IV Programming ... Webcast / Webinar

9:00 - 5:00  RPG IV Programming Workshop Conference

9:00 - 5:00  RPG IV Programming Workshop Seminar

November 16th:

3:00 - 4:00  ASNA Wings Webcast Conference

4:00 - 4:30  StarQuery Webinar: Affordable End-User Friendly Bu ... Webcast / Webinar 

November 17th & 24th:

10:30 - 11:30  Vision Solutions: Uses and Features of Vision Repl ... Webcast / Webinar


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