It's been a few years since I developed on the 400, but other ways that I retrieved data for both Windows and OS/2 were the following:
APPC (don't know if you have this skill set in house, but I thought I'd mention it) PC Support API (this was used for OS/2 clients, so you'll need to check to see if it's still used today and if so, if it's been ported to Windows). It's been a while for me and some of these ideas are probably outdated, but I'm just throwing them out there just in case they help in some way. -----Original Message----- From: dotnet discussion [mailto:[EMAIL PROTECTED]]On Behalf Of Christopher Castelot Sent: Thursday, May 02, 2002 4:30 PM To: [EMAIL PROTECTED] Subject: [DOTNET] Accessing AS400 data through ado.net Hi all, I work in an environment which has most inventory and distribution data on an AS400. The company also has an Oracle 8i database for client server apps and web based business. For all intents and purposes the Oracle database is a mirror of the 400. However, all data is entered on to the 400 and oracle is kept in sync through a series of updates. My project is to start loading product data for new sources directly to the AS400 (what has been a primarily manual process). I started out writing the application in .Net and would like to finish it that way. Here's the problem: 1) Using Client Access 5.1, Ado.Net, and the oledb provider IBMDA400 directly hitting the 400 takes nearly 3 hours to process 28,000 records. Unacceptably long. This same scenario in terms of processing except hitting the Oracle database takes 14 minutes to process the same 28,000 records. (MSDAORA as the provider.) If I use an Oracle Gateway (MSDAORA as the provider) the same processing takes 30 minutes. I would think that going through a gateway would be slower than going direct. The question is how can I optimize performance going directly to the 400? Although it is interesting that Oracle takes significantly less time it is also not an option. The gateway is only for selects, not inserts. And, most importantly, this project is dead on arrival if I can't get that processing time down to a reasonable time. Here's what I am doing? connectionString "Provider=IBMDA400.DataSource.1;Data Source=prod;User ID=*****;Password=******" cmdText "SELECT title AS result FROM tdmsdta01.dmm005 WHERE itnbr = '009335021X '" try { conn = NewConnection(); OleDbCommand cmd = new OleDbCommand( sSql, conn); conn.Open(); dr = cmd.ExecuteReader(); if (dr.Read()) { objReturn = dr.GetValue(0); } } catch Any hints would be greatly appreciated! Chris You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com. You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
