Beside Oracle, we have db2 mainframe and db2 udb on aix. I've asked asomeone working with DB2 mainframe and there is spufi which is like sqlplus and DB2 Interactive wich is more like the command center on db2 udb.
I'll more details tomorrow. --- Thomas Day <[EMAIL PROTECTED]> a écrit : > > 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 > <[EMAIL PROTECTED]> > <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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). ===== Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __________________________________________________________ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
