Thanks for the help.

What's needed on the client PC to query DB2?

With SQL Server we only have a ODBC driver on the client PC's. But with Oracle, we have to install their huge client software on each client.

Is DB2 client setup fairly easy?

Thanks,

Jerryt


>
>Yeah, almost all of our apps have some interfacing to the AS/400 (DB/2) to gather data or write back. I have used SQL Passthrough, remote views, and almost all of the SQLxxxx() functions (like SQLTABLES() and SQLCOLUMNS() to get metadata).
>
>>Our shop is thinking of getting a new I-frame server that supports our legacy system and also comes with DB2.
>>
>>Will I be able to query and update DB2 via VFP SQL pass through or VFP remote views?
>
>SQL Passthrough has some advantages, and SPT cursors can be made writable anyway. I still use remote views here and there, but only if I build them on the fly (using SELECT * to avoid the dreaded "Base fields no longer match view definition" error). I have not done transactions where I can commit or rollback on the server, and we have not messed with stored procedures much. But everything else is great, and performance is pretty good!
>
>Keep and ODBC/DB2 questions coming, and let us know your experiences with the i-Frame server...
>
>Thanks,
>JoeK