DB2 Record Level Access With VB

[Guest.Visitor]

Good Morning, I'm attempting to write a VB program that will enable a user to manipulate 2 DB2/400 files (one for input, one for output). What is the best (and easiest) way to access AS/400 data using Visual Basic for such a purpose? So far, my only experience in this is using Client Access APIs to submit a job on the /400 and pass large amounts of data in batch mode. This application would be interactive with relatively small files (< 200 records). We are using Client Access V3R2M0 and OS/400 V4R4. I'd appreciate any help you can give me. Thanks.

[Guest.Visitor]

Gene, From what I have read, ADO/OLE DB is the way to go. The July 2000 MC had an article on it and in the article a reference is made to a Redbook by IBM on this subject http://publib.boulder.ibm.com/pubs/p...s/sg245183.pdf . Bill

[Guest.Visitor]

Thanks, Bill. I'll download the Redbook and check it out.

[Guest.Visitor]

Gene - I'm not sure just what the rules around here but the 'other magazine' has a web site where they devote a lot of resources to this sort of thing. http://www.as400network.com You will need to either have a subscription or pay a fee to see much of anything.