HI, I worked in the past with a project to read db2 from open. I know how to do it. At least many years ago.
The question is if anybody think that people like it or it waste of time? Thanks, Shai On 1/23/08, Wayne Driscoll <[EMAIL PROTECTED]> wrote: > > 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 > ---------------------------------------------------------------------- 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
