That's what I was afraid of. Thanks. David Logan Manager of Product Development, Pitney Bowes Business Insight http://centrus.com 4750 Walnut St, Suite 200 Boulder, CO 80301 W: (720) 564-3056
-----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Blaicher, Chris Sent: Wednesday, June 11, 2008 9:28 PM To: [email protected] Subject: Re: Can DB/2 use standard KSDS VSAM datasets? The short answer is NO. DB/2 only understands VSAM linear data sets formatted as DB/2 objects, data or index. I do not believe that their LOAD utility understands KSDS input, but I could be very wrong on that point. Chris Blaicher -----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of David Logan Sent: Wednesday, June 11, 2008 5:58 PM To: [email protected] Subject: Can DB/2 use standard KSDS VSAM datasets? We have a dataset that has a single (integer) key followed by a big block of binary data. We want access to this data via a DB/2 enabled program, using a SELECT statement. My question is this: Do we need to actually CREATE TABLE and load our data into the DB/2 internal formats, or can we just ask DB/2 to read the KSDS directly as a "two-field table"? (IMS allows this, for example.) Thanks! David Logan Manager of Product Development, Pitney Bowes Business Insight http://centrus.com <http://centrus.com/> 4750 Walnut St, Suite 200 Boulder, CO 80301 W: (720) 564-3056 C: (303) 818-8222 ---------------------------------------------------------------------- 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 ---------------------------------------------------------------------- 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

