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

2. TechTip: MERGE DB2 Data to SQL Server 2008

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

3. TechTip: Debugging Multi-Result Set DB2 Stored Procedures

Use Microsoft Access as a great testing utility. Stored procedures are great tools for easily delivering the results of one or more queries (aka result sets) to a client/server or Web application. (For a brief outline of this technique from th

4. TechTip: Panoply of Free Database Servers

Leverage your existing DB2 SQL skills to learn another database engine for free!

5. TechTip: Want to Give .NET a Try? Get Visual Studio 2005 Express Edition

Come up to speed on .NET programming at no charge.

6. DB2 Integration with SQL Server 2005, Part 2: CLR Integration

SQL Server developers can now write functions and stored procedures in a .NET programming language.

7. TechTip: SQL Server 2005 Linked Servers and Synonyms

Use synonyms to ease T-SQL code maintenance.

8. TechTip: Retrieve Multiple Result Sets from a Stored Procedure

Learn how using Java, C#, or Visual Basic for Applications (VBA).

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

10. Execute Remote Stored Procedures from the iSeries

Use SQL and Java to run remote jobs on other database platforms from the comfort of your iSeries.

11. TechTip: Using SQL with IFS Text Files, Part 2

Sometimes, you want to process a file one line at a time. That's when you want a UDTF.

12. TechTip: Using SQL with IFS Text Files, Part 1

Place the entire contents of a text file into a single column using a scalar UDF.

13. Query Remote Database Tables from the iSeries Using SQL and Java

Beginners, take heart. It's not that hard!

14. TechTip: Add Column Headings to Your Export Files

RTVCOLHDG is the perfect complement to CPYTOIMPF.

15. Using Dynamic SQL in CL: Part 2--Retrieving a Data Value

This utility allows you to retrieve unrelated bits of data from multiple files.

16. Using Dynamic SQL in CL: Part 1--Running Action Queries

Execute dynamic SQL statements anywhere.

17. Patch Those Leaky Interfaces

Use distributed transactions to ensure data integrity between the iSeries and SQL Server.

18. Retrieve DDS Source for a Physical or Logical File

Similar to RTVCLSRC, RTVDDSSRC rebuilds the source member from a physical file or logical file.

19. Return of the BLOB

Use SQL to exchange data with the OS/400 IFS using datalinks and BLOBs.

20. Invasion of the BLOBs

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

21. Crunching AS/400 Data with OLAP Cubes and Excel 2000

Online analytical processing (OLAP) is a big buzzword these days. Many IT professionals are talking about using OLAP to analyze trends in large amounts of data and the accompanying tool set required to do this. Perhaps you’ve heard about DB2 OLA

22. Launching SQL Statements Through Microsoft Access Pass-through Queries

In Client/Server programming, performance is usually a key issue. Microsoft Access has many ways to communicate with a database server including import, export, and linked table features. (For an overview of using these Microsoft Access features in a

23. Links, Imports, Exports: Using ODBC to Share OS/400 Data with Microsoft Access

Microsoft Access is a splendid tool for rapidly developing GUI forms and reports for users. It can be used to generate mailing labels, create charts, and allow users to inquire on the latest AS/400 data.But, how do you get your AS/400 data into Acces

24. More AS/400 Client/Server Programming with ADO and VBA

ActiveX Data Objects (ADO) is a great aid for client/server programmers. It not only provides a great way to access data, but it also affords easy access to AS/400 commands, programs, and data queues.In "AS/400 Client/Server Programming with ADO, Mic

25. AS/400 Client/Server Programming with ADO, Microsoft Excel 2000, and OLE DB

Let’s face it. In a world dominated by graphical PC interfaces, green-screen applications are things of the past. To effectively present AS/400 data, one needs to capitalize on the graphical strengths of PCs. With a basic knowledge of a PC langu