I remember trying this a few months back
1. Created a federated connection from DB2 V8.1 for Windows to DB2 V8.1 for z/OS
2. Created a nick name to the DB2/zOS table
3. Exported the data using db2 export to test.del of del select * from nick_name
This was the only free option which I could find :)
Cheers
-----Original Message-----
From: Matthew Estrellado
[mailto:db2udbdba-ezmlmshield-x46609374.[Email address protected]
Sent: 24 February 2005 15:06
To: LazyDBA Discussion
Subject: Data extract tool for DB2/zOS
Hi All,
Could somebody recommend a freeware tool to extract all DB2/zOS data
into a delimited flat file?
thanks
Matthew L. Estrellado
Siemens ICN
2571 Product Dr
Rochester Hills, MI 48309
248-853-4918
CONFIDENTIALITY NOTICE: This email contains information from the sender that may be CONFIDENTIAL, LEGALLY PRIVILEGED, PROPRIETARY or otherwise protected from disclosure. This email is intended for use only by the person or entity to whom it is addressed. If you are not the intended recipient, any use, disclosure, copying, distribution, printing, or any action taken in reliance on the contents of this email, is strictly prohibited. If you received this email in error, please contact the sending party by replying in an email to the sender, delete the email from your computer system and shred any paper copies of the email you printed.
Note to Patients: There are a number of risks you should consider before using e-mail to communicate with us. These risks are described in our Privacy Policy at http://henryford.com. Review that policy carefully before continuing to communicate with us by e-mail. For greater Internet security, our policy describes the Henry Ford MyHealth electronic communication process - you may register at http://henryford.com. If you do not believe that our policy gives you the privacy and security protection you need, do not send e-mail or Internet communications to us.
BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:Matthew Estrellado
TEL;WORK:4918
ORG:;Tech Staff
EMAIL;WORK;PREF;NGW:[Email address protected]
N:Estrellado;Matthew
TITLE:
END:VCARD
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page