Oracle-L: Re: OT: Getting data out of DB2...any DB2 DBAs out there?

From: Thomas Day <tday6_at_csc.com>
Date: Wed, 13 Nov 2002 12:35:50 -0800
Message-ID: <F001.00502AC8.20021113123550@fatcity.com>

I used to use SPUFI (SP?) with TSO/MVS but that was many years ago. I would hope that there's something better.

                                                                                                                   
                    "Grabowy,                                                                                      
                    Chris"               To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>       
                    <cgrabowy            cc:                                                                       
                    @fcg.com>            Subject:     OT: Getting data out of DB2...any DB2 DBAs out there?        
                    Sent by: root                                                                                  
                                                                                                                   
                                                                                                                   
                    11/13/2002                                                                                     
                    02:15 PM                                                                                       
                    Please                                                                                         
                    respond to                                                                                     
                    ORACLE-L

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: Thomas Day
INET: tday6_at_csc.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 - 14:35:50 CST