I will agree with Walt, this is a non-trivial exercise. DB2 data is stored in a format that is not maintained with the data. You first need to locate the DBD for the database that contains the definition (which means you must have access to the DB2 directory datasets, and out to move through them), Then you need to locate the appropriate pages. Also, DB2 data can be compressed, which means you need to de-compress the rows, all the while dealing with issues such as code page translation, big<->little endian issue etc.
Wayne Driscoll Product Developer JME Software LLC NOTE: All opinions are strictly my own. -----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Walt Farrell Sent: Wednesday, January 23, 2008 12:02 PM To: [email protected] Subject: Re: DB2 queries without using MF. On Wed, 23 Jan 2008 08:27:45 -0600, Shai Hess <[EMAIL PROTECTED]> wrote: > Is it can be useful to develop in the PC, api for DB2? > > The API will use my MFNetDisk 3390 data and the response time will be very >very good from PC or any open systems platform? I won't comment on the usefulness, and I'll ignore the security questions that others have raised. However, I think that you would have a very large job ahead of you to figure out how to find the DB2 data on your disks, and interpret the internal format of the tables stored in those VSAM data sets. It's one thing to intercept I/O requests as DB2 writes records to DASD and write them to your emulated DASD. It's much harder, I believe, to interpret the data contained within those records and make any sense out of it. Especially with data as complex as DB2 tables. -- Walt ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
