http://www-1.ibm.com/servers/eserver/iseries/access/toolkit/

I think the asterisk is the problem. Try :

DELETE FROM <TABLE> where <conditions>

Get a copy of Client Express Toolkit (FREE) to see some samples of executing Select statements against a DB2 database.

Select <fieldname1>, <fieldname-n> from [Servername].<DatabaseName>.<LibararyName>.<TableName> where <conditions>

Best of luck. 

The Client Access Express driver should work, as long as the AS/400 is using the same version ( could be up to V5R3M0 ).

Set up a valid DSN using the...

Wouldn't the logins be lost in this process?

Found my answer in an INSTEAD OF INSERT trigger.

Try this snippet:

EXEC msdb.dbo.sp_get_composite_job_info NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL

Thank for the assitance. However, I'm not getting the first record back in a member's history if there is more than 1 record in a member's history

The package you are attempting to open may have been created with a later version of DTS.  Try installing the client tools for SQL Server 2000 abd try again.

Try adding the port number to the connection string.