By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,007 Members | 1,237 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,007 IT Pros & Developers. It's quick & easy.

export IBM UDB (7.2) database into DB2 Mainframe

P: n/a
Hi

I am trying to export a database and its data from UDB 7.2 or 8.1 to
Mainframe DB2. Is this possible? The last time I did this, i ended
up having to write insert statements for each row. Is there a
utilitity to accomplish this?

Thanks

John
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
John Turek wrote:
Hi

I am trying to export a database and its data from UDB 7.2 or 8.1 to
Mainframe DB2. Is this possible? The last time I did this, i ended
up having to write insert statements for each row. Is there a
utilitity to accomplish this?

Thanks

John


You posted this question in multiple newsgroups and did not indicate in which
newsgroup you expected an answer ...

Jan M. Nelken
Nov 12 '05 #2

P: n/a
jo********@gmail.com (John Turek) wrote in message news:<48**************************@posting.google. com>...
Hi

I am trying to export a database and its data from UDB 7.2 or 8.1 to
Mainframe DB2. Is this possible? The last time I did this, i ended
up having to write insert statements for each row. Is there a
utilitity to accomplish this?

Thanks

John

If you select the data on DB2 LUW and pipe the output to a file
without headers (see CLP options), the data will be in fixed column
postions, and can be ftp'ed and then loaded with the DB2 mainframe
load utility. Obviously you will have to manually create the control
cards to specify where each column starts and ends. Not sure about how
null data would be handled (null columns appear as a "-" on the select
statements output).
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.