1. Is Working with the .NET Tribe a Secret to Surviving in Paradise?

LANSA's Open for .NET solution is designed to help make integrating Microsoft applications and IBM data a trouble-free experience. By Chris Smith Ever roll into work and think you're actually in Gabon on the set of Survivor? Eve

2. TechTip: Creating Local OLAP Cube Data Files with DB2 Data

Give users offline access to DB2 data in a versatile pivot table format. By Michael Sansoterra In "Crunching AS/400 Data with OLAP Cubes and Excel 2000," I outlined how to use the Pivot Table wizard with Excel 2000 (and higher

3. Employ Best Practices When Integrating Disparate Data

Disparate data can inhibit value creation, but data integration best practices allow organizations to fully leverage the inherent value in their information resources. By John Gay Silos of disparate data plague many companies. The reaso

4. MySQL and IBM i: Where Does MySQL Fit in a DB2 World?

DB2 is the only database many of us have ever known.  This article shows you how you can broaden your database options. By Joe Pluta If you're an i programmer, you've been using DB2 from the beginning of your career (unless

5. TechTip: Simplify Report Development with DB2 Web Query Business Views

Get rid of those long lists of fields! By Gene Cobb If you have been using DB2 Web Query for report and graph development, you may have discovered that the database field list in the development tools (Report Assistant, Graph Assistant,

6. Making Better Use of DB2 Web Query with *LIBL

Search the library list when accessing and querying a referenced database object such as a physical file or SQL view. By Gene Cobb In a previous article titled "Maximize SQL Query Engine (SQE) Usage of Your DB2 Web Query Reports,&q

7. Exploit IBM DB2 for i Database Development with JDBC 4.0

Learn how to exploit enhanced BLOB/CLOB support, SQL XML data type, and better connection management. By Jarek Miszczyk If you were, like me, watching closely the evolution of the JDBC specification, you probably noticed how it morphed

8. Finding SQL Server Mode Connecting Jobs

Now it's much easier to understand QSQSRVR usage and isolate QSQSRVR-related problem domains and origins. By Scott Forstie IBM DB2 for i customers are accustomed to seeing SQL server mode job activity, otherwise known as QSQSRVR pre

9. Accessing i Data from MS SQL Server

It's one thing to access SQL Server data from the System i, but it's another thing to access System i data from SQL Server. By Joe Pluta Heterogeneous data is one of the hallmarks of today's IT. Whether due to disparities in

10. Tech Tip: Converting Legacy Date Fields to DB2 Web Query Dates, Part II

Extend your legacy date fields to support a richer set of date values and improve the performance of your reports. By Gene Cobb In my previous TechTip, "Converting Legacy Date Fields to DB2 Web Query Dates, Part I," I describe

11. How Will IBM DB2 Web Query for System i Benefit Your Shop?

 Learn about the new IBM query and reporting tool for the i5/OS market. By Gene Cobb If you have been following recent IT industry trends, you may have noticed that there has been a lot of activity in the area of Business Intelligence

12. V6R1 SQL Query Engine Delivers on Its Promise

Learn how to prepare for the new DB2 for i5/OS query engine. By Jarek Miszczyk With V6R1 DB2 for i5/OS, the transition of SQL workloads from Classic Query Engine (CQE) to the new SQL Query Engine (SQE) has been basically completed. So far, t

13. V6R1 DB2 for i5/OS Highlights

New capabilities allow designers and programmers to continue to produce new and exciting applications. By Jim Flanagan Because DB2 for i5/OS is embedded within i5/OS, application designers and programmers likely expected that with the V

14. V6R1 Breathes New Life into DB2 for i5/OS .NET Provider

Learn how to exploit ADO.NET 2.0 enhancements, DAAB, distributed transactions, and more. By Jarek Miszczyk Over the last couple of years, I wrote several articles and white papers that dealt with Microsoft .NET Framework integration wit

15. With Perseverance and Luck, You Can Conquer the DB2 Web Query Install

You have to be running at least V5R4 to load DB2 Web Query, and there are some PTFs to install. But help is just a phone call away. By Chris Smith Those folks at Centerfield Technology certainly are on their toes. An opportunity arises

16. Maximize SQL Query Engine (SQE) Usage of Your DB2 Web Query Reports

Ensure top-notch DB2 Web Query reports by using QAQQINI, exit points, database monitors, and Visual Explain. By Gene Cobb In July of 2007, IBM announced DB2 Web Query for System i, a product positioned as a query and reporting tool for the

17. Auto Backup for MySQL Automates Backups to Avoid Data-Loss Nightmares

Auto Backup for MySQL Professional Edition 2.1 from SwordSky Software promises to save database administrators and Web masters from unexpected data loss.

18. Book Review: DB2 9 Fundamentals

Whether you want to obtain an IBM certified DB2 professional certification or simply become well-rounded in the fundamental concepts of DB2 and general database theory, this is your book.   Roger E. Sanders has created one of today

19. SQL Triggers and Other Trigger Enhancements in V5

Are you aware of everything you can do with triggers in i5/OS or OS/400? One of IBM's better-kept secrets in V5R1 is the significant new trigger function provided in the OS/400 release. This ranges from SQL triggers, which provide a high

20. Can MySQL Become YourSQL?

A joint announcement that rocked the boat.

21. Bridge the Legacy-to-Java Transition with DB2 for i5/OS Distributed Transactions

Learn how to share transactions and locks, avoid orphaned transactions, and more.

22. Make DB2 Data Downloads Easy with Start CGI SQL Session (STRCGISQL)

Turn a multi-step process into a one-step process.

23. DB2 Integration with SQL Server 2005, Part I: Linked Server Enhancements

Check out SQL Server 2005's new features that simplify integration with other databases.

24. Improve Your Productivity with Significant Enhancements in DB2 SQL

Master nested compound statement handlers, implicit name qualification, and other advanced programming techniques.

25. Data Access, Database Engines, and Persistence

DB2, SQL, ODBC, JDBC, EJB, JDO, and SDO--Joe guides you through the acronym soup of database technologies.

26. Cut Your Development Effort with DB2 Development Add-in for .NET

Learn how to efficiently use the Stinger Add-in for .NET with DB2 for iSeries.

27. The Power and Magic of LPG

Explore the strategy of Local Predicate Generation for Queries within DB2 UDB for iSeries V5R3.

28. Securing Your Data Warehouse

Thwart the threat of unauthorized internal and external access.

29. What Now, Oracle?

Oracle's takeover of PeopleSoft is "relational."

30. .NET Integration with DB2 UDB for iSeries

Microsoft's .NET Framework is gaining acceptance among solution developers who traditionally rely on Microsoft development tools. Some of these developers want to take advantage of the robust transaction support, tight security, reliable messaging

31. Using iSeries ODBC Driver in a Linux Partition

Optimize the access to your DB2 UDB for iSeries database from a Linux partition.

32. Cut Your Migration Time from Oracle to DB2 UDB for iSeries

With IBM's DB2 Migration Toolkit for iSeries, you'll save time and effort.

33. Remote Journaling and Data Recovery

Remote journaling provides some options for getting back that lost data.

34. What's New with DB2 in V5R2

SQL enhancements and compatibility highlight what's coming in DB2 UDB for iSeries.

35. Using SQL Server 2000 Analysis Services & the iSeries--Part II

Read data from an OLAP database.

36. The Good OLE (DB) Days

Use ADO and OLE DB to create a Web-based Query tool for the iSeries.

37. Random Access DB Performance Comparisons

Howard measures the load your database can carry in different environments.

38. Empowering Your Database

By using the built-in features of DB2/400, you can move code to data for more robust applications.

39. Access DB2/400 Data from Notes with JDBC

Learn the versatility and power of using JDBC access in your Domino agents.

40. Invasion of the BLOBs

BLOBs can be a valuable addition to your client/server environment.

41. Focus on Database Management

If I were to ask you how the System/36 and native AS/400 differ, you’d probably mention that the AS/400 lets you define files externally to programs. You might also mention that DB2/400 logical files are more powerful than S/36 alternate indexes

42. OS/400 Can Balance Your DB2/400 Data Across Multiple Disks!

Most AS/400 and iSeries boxes have multiple disk units. Some machines, like the one that I work on, have not only multiple disk units but also multiple types of disk units. Since the AS/400 and iSeries hardware uses a scatter load algorithm to physic

43. QMF for Windows for AS/400, Version 7.1

With Java-based query, QMF is a powerful new tool for the high-performance AS/400e.

44. Access DB2/400 Data with LS:DO

LotusScript Data Objects let you use DB2/400 data in Domino applications.

45. The Hidden Power of Query, Part 2

Link your Query/400 reports together for total flexibility.

46. The Hidden Power of Query, Part 1

It?s amazing what you can do with Query/400!

47. Data Warehousing and the Web

Every day, e-businesses collect huge amounts of data from their e-commerce Web sites. The raw data alone has little value, so how can an e-business effectively leverage the data from its site? It can identify and collect the information that managem

48. Pirouette Like a Pro with Virtual Pivot Tables

Create sophisticated reports with this cool SQL reporting technique.

49. QMF Comes to the AS/400

Version 7.1 of Query Management Facility (QMF) for Windows for AS/400 will become generally available on September 29 of this year. Are you excited? If not, should you be?QMF is not new; it's been around since 1983 in the IBM mainframe world. QMF for

50. Implementing DB2 UDB for AS/400 UDFs

User-defined functions are the missing link to extending and customizing SQL.