Is this what you are looking for?

SELECT 'EXPORT TO <target directory>'
||STRIP(NAME)||'.IXF OF IXF',
'MESSAGES <target directory>'
||STRIP(NAME)||'IXF.MSG SELECT * ',
'FROM '||STRIP(CREATOR)||'.'||STRIP(NAME)||';'
FROM SYSIBM.SYSTABLES
-- optional WHERE clause criteria would be something like:
-- WHERE DBNAME = '<remote db name>'
-- WHERE CREATOR = 'remote tb creator>'
-- WHERE TSNAME IN ('<remote tsname>', '<remote tsname>'...etc...)
;

Run this, capture the results in a flat file (using WinSQL or SPUFI) and
then run the result set from the target server - you must have DB2
Connect EE installed on the target server and mainframe connections
configured.

You can build LOAD statements basically the same way but I believe you
must provide a column list - requires a small program such as
EasyTrieve.

Rick

-----Original Message-----
From: Praveen Chengalathu
[mailto:db2udbdba-ezmlmshield-x21185345.[Email address protected]
Sent: Thursday, February 24, 2005 10:15 AM
To: LazyDBA Discussion
Subject: RE: Data extract tool for DB2/zOS

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



---------------------------------------------------------------------
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