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

October 10, 2008 | Vol 5 Issue 40


In This Issue:

Feature Article - TechTip
TechTip: MERGE DB2 Data to SQL Server 2008

Data replication chores are a snap with the new MERGE T-SQL statement.


Released in August 2008, SQL Server 2008 is the latest incarnation of Microsoft's flagship database platform. While there are some cool new features for developers, there is one for DB2 developers that deserves special mention: the new Transact SQL (T-SQL) MERGE statement. MERGE will be useful to any IBM i (aka AS/400, iSeries, System i) shop that needs to replicate DB2 for i (formerly known as DB2 for i5/OS and DB2/400) data to SQL Server. This includes shops that use SQL Server for reporting, data warehousing. and application data sharing.


Feature Article - Application Software
Plan to Recover Files Before They're Lost

Everyone loses data sooner or later, but preparation can serve as inexpensive insurance.

chris_smith.jpgBy Chris Smith

Have you ever noticed how some of the most interesting stuff winds up in your junk email folder?


Emails come in from all over the world and wind up right there in your personal email junk folder. These messages, written usually in variants of English, though I have seen some in Chinese, promise everything from great jobs, where you will have to work only two or three hours a day, to relationships with lonely women who supposedly got your name somewhere, to flawless replica watches, to human growth products designed to make you more appealing in a world where size matters.


Advertorial - Help/Systems
Partner TechTip: Automate System i Messages

Message automation eliminates the "noise" in managing your System i.

tom_huntington.jpgBy Tom Huntington

Do you monitor the QSYSOPR message queue manually? Do you want to develop a list of responses to messages in your system's message queues? Do you want to consolidate your console workstations? Do you need to monitor your HA product?


The System i (iSeries) is message-driven. Application failures, security errors, system management issues, hardware problems, print errors--just about everything generates error messages to QSYSOPR.


Support MC Press - Visit Our Sponsors


Forums Sponsor


 Popular Forums




Search Sponsor

 Popular Searches