In this document we will create a macro-enabled workbook and use a pre-built macro to import MultiValued data into a series of worksheets in the workbook.

The data will come from the sample CUST file in the GAXOLEDB account that is created when the FusionWare Direct Data Access Server (Direct DAS) is installed on your MultiValue system.

You will need to modify the connection string to reflect your system, and you can freely modify the COMMANDTEXT property and other code to process different tables.

We will use the FusionWare Direct OLE DB Provider to access this data.

This document describes how you can rapidly create a DataSet of your MultiValued data without having to map your data.  Starting with a TCL LIST/SORT command that produces the output that you want to retrieve, we show you how to go from that to a fully functional ADO.NET command that retrieves this data for you.  Note that although we focus on ADO.NET, the same command can be called from COM/COM+ using the FusionWare Direct OLE DB Driver, or from Java using the FusionWare Java Data Adapter.

This article provides examples and explains in depth, how Microsoft's DbDataAdapter Fill method converts nested IDataReader objects representing MultiValued data into a series of DataTable and DataRelation objects in a DataSet.

As a follow-up to Robert Houben’s blogs on our project to provide an open source Web store for IBM i using osCommerce, here are some of the goals and challenges we faced with this specific project and how we dealt with them.

We developed our first web middleware solution in 1994, and released it to our first customer in 1995.  In this blog entry we review of the standards and industry best practices that shaped the FusionWare Direct products and solutions for the Web.

Connecting to a MultiValue (PICK) database using FusionWare Direct ADO.NET provider from a WPF application using Visual Studio 2010.  Example code using the sample CUST file in the FusionWare Direct Data Access Server (Direct DAS) account. This is part two where we customize the Data Access Layer further to allow selective retrieval of data.

FusionWare Integration Corp. has added SQL Azure support to their popular mv2SQL product in a new offering they call mv2Cloud.  Here we discuss what this means for the MultiValue community.

I've been working with a user on replacing their current web store with one that actually integrates with their System i POS system. Their old one printed an order form off, and they had to pick up the printer output, manually check inventory, grab it, complete the order, then notify the customer. If anything went wrong, they had to notify the customer. It was all asynchronous, which is not what most customers expect from a web transaction.

I've just discovered another use for Twitter.

Many customers with green-screen applications struggle with integrating these systems with a web store.  The challenges are daunting and in some cases have caused customers to shelve these initiatives.  In this series of articles, we will look at the steps and decisions required in order to build out this kind of solution without breaking the budget, and within a reasonable timeframe.