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

By Michael Sansoterra

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.

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

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

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

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

Featured Products

Catapult, the multi award winning automated iSeries report distribution & document management tool. Automatically distribute spool files or PC files. Reports can be formatted as PDF, RTF, HTML, TXT or even as an XLS spread sheet and may be emailed, printed, faxed or archived to any network drive.

Learn more about Business Computer Design Int'l, Inc. and its products here.

T.L. Ashford's award winning BARCODE400 software is the labeling answer for the iSeries. With this versatile and easy to use software you will be designing and printing labels in minutes. Compliance labeling is a snap using templates provide by TL Ashford.

Learn more about T.L. Ashford & Associates and its Barcode and RFID solutions here.

Want to feature your company products? Click here or call (208) 726-6822 for information.