OT: Getting data out of DB2...any DB2 DBAs out there?

From: Grabowy, Chris <cgrabowy_at_fcg.com>
Date: Wed, 13 Nov 2002 11:15:59 -0800
Message-ID: <F001.0050282C.20021113111559@fatcity.com>

Off topic post, please delete if not interested.

I am trying to get data out of a DB2 database that I do not have access to. The original spec called for me to create a flat file, which they parse, and query the DB2 DB to get the specific requested data, and "spool" the requested data into a flat file, which is then FTPed back to me.

I would prefer to send them (in Oracle/UNIX terms) a shell script calling SQL*Plus that uses some SQL to get the data I need, which is spooled to a flat file. Since this is on MVS, I assume it will have to be some SQL wrapped in JCL. I just do not know of an equivilent SQL*Plus in DB2, since I don't even know how to spell DB2.

Since I will be proposing this approach, I was hoping to have an example JCL job in my proposal. So I was wondering if anyone has some example jobs that they would be willing to share?????

Many thanks!!

Chris

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Grabowy, Chris
  INET: cgrabowy_at_fcg.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Nov 13 2002 - 13:15:59 CST