473,701 Members | 2,594 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Export DB2

Hello there,

I have access to a DB2 database through operation navigator. What I
would like to do is find a tool to export the database into create
table, insert into statements. Like what phpmyadmin does.

Is there a free tool for such a job?

Thanks
Jan 7 '08 #1
5 2499
On Jan 7, 3:28 am, Harris Kosmidhs <hkosm...@remov e.me.softnet.tu c.gr>
wrote:
Hello there,

I have access to a DB2 database through operation navigator. What I
would like to do is find a tool to export the database into create
table, insert into statements. Like what phpmyadmin does.

Is there a free tool for such a job?

Thanks
Take a look at recently released web based DB2 management console.
http://sourceforge.net/projects/db2mc/

cheers,
sanjuro
Jan 7 '08 #2
m
Harris Kosmidhs wrote:
Hello there,

I have access to a DB2 database through operation navigator. What I
would like to do is find a tool to export the database into create
table, insert into statements. Like what phpmyadmin does.

Is there a free tool for such a job?

Thanks
There is also a command line tool - db2look that will recreate the DDL
for a database.
Jan 7 '08 #3
"Harris Kosmidhs" <hk******@remov e.me.softnet.tu c.grwrote in message
news:fl******** **@volcano1.grn et.gr...
Hello there,

I have access to a DB2 database through operation navigator. What I would
like to do is find a tool to export the database into create table, insert
into statements. Like what phpmyadmin does.

Is there a free tool for such a job?

Thanks
If you are loading the tables into another DB2 database, then all you need
is export to IXF format, and then import using replace_create option. This
will create the table upon import. However, the foreign keys will not be
re-created in the new table. If you use import, then the "COMMITCOUN T 1000"
keyword is recommended.

If you want to automatically move all the tables in the database, then
db2move command will automate the export and import for you.
Jan 8 '08 #4
Mark A wrote:
"Harris Kosmidhs" <hk******@remov e.me.softnet.tu c.grwrote in message
news:fl******** **@volcano1.grn et.gr...
>Hello there,

I have access to a DB2 database through operation navigator. What I would
like to do is find a tool to export the database into create table, insert
into statements. Like what phpmyadmin does.

Is there a free tool for such a job?

Thanks

If you are loading the tables into another DB2 database, then all you need
is export to IXF format, and then import using replace_create option.
No, what I want is only the table in a text file with insert into
statements.

Why isn't there a simple tool for that? I examined
http://sourceforge.net/projects/db2mc/ but it was rather obfuscated to
install the php_ibm_db2 extension!
Jan 8 '08 #5
On 8 Jan., 09:23, Harris Kosmidhs <hkosm...@remov e.me.softnet.tu c.gr>
wrote:
No, what I want is only the table in a text file with insert into
statements.

Why isn't there a simple tool for that?
Take a look at http://jailer.sourceforge.net/
The tool is mainly intended for exporting referentially intact row-
sets, but you can also export single tables by removing all
association definitions after db-introspection, then choose the table
you want to export as the subject-table and '1=1' as condition.
Jan 8 '08 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

13
29503
by: DarkSpy | last post by:
many c++ compilers including "gcc" have not implemented the "export" keyword, but the comeau compilers made it (just i knew). i want to know about: is it too difficult to implement "export" keyword? if it is, i know the history that is without "export" keyword of C++ compilers with five years (sorry about my poor english :-) ), in five years still have no some idea to implement it ? my project and many C++ programmers need this important...
205
10640
by: Jeremy Siek | last post by:
CALL FOR PAPERS/PARTICIPATION C++, Boost, and the Future of C++ Libraries Workshop at OOPSLA October 24-28, 2004 Vancouver, British Columbia, Canada http://tinyurl.com/4n5pf Submissions
1
1850
by: Do Park via SQLMonster.com | last post by:
Hello all, I don?t often export data from a table. I am wondering how you export data from a table. I?d like to know how you export in real world. Do you export data from a table to a flat file or what type? There are many selections when you choose file type. When do you need to export data? How often? Do you use DTS rather than export wizard?
6
17062
by: maricel | last post by:
Is there anybody out there who have any idea why EXPORT is relatively slower when putting the output file on a network drive - map drive from onother PC compared to putting it on my local PC drive (faster). Is there any workaround or tuning config that is available? Your help would be highly appreciated. maricel
5
10600
by: David | last post by:
I am a little confused by DB2 Backup and Export. I used "db2 backup db QAS to /dev/rmt0" backuping 650GB database to a IBM LTO 3581 (1 drive) only 11 hours. But I used "db2 export to /dev/rmt0 of ixf messages MKPF.msg select * from mkpf" on the same 3581, and this table is only 5GB, but the export used 4 hours. What's the diffirent between Backup and Export? I mean except backup is used to backup whole database or tablespace, and export...
5
11034
by: Tim Eliot | last post by:
Just wondering if anyone has hit the following issue and how you might have sorted it out. I am using the command: DoCmd.TransferText acExportMerge, , stDataSource, stFileName, True after setting stDataSource and stFileName to the desired values. Most of the time it works, but occasionally, typically as code changes are being made to the module, the following message appears:
7
14366
by: Pat | last post by:
I would like to send the Print Preview of a MS Access form to a Snapshot file. The form contains an OLE graph. BACKGROUND A snapshot of a report is possible. If I could I would use a report to display the graph but it is not possible to send query parameters to an OLE graph on a report (or programatically change any properties of an OLE Graph). However with a Form you do have the ability to change the RowSource of
1
5343
by: chaitu | last post by:
Hi, Can anybody tell me what the error code for Export is. Like i get the message SQL3104N The Export utility is beginning to export data to file "/home/db2as/sqllib/bluee_tables1/DBCHECK.ixf". if it is beginning to export and
5
3433
by: JHNielson | last post by:
I have a somewhat simple question, but have been baffled by it for a while, and now I'm on a tight deadline - have to get it done within 24 hours. I am trying to export a set of files to my hard drive to then later be FTPd to a server. the file format should be "TITLE.yyyymmdd" where yymmdd is the date code for when the files are created. The files can't be .txt. But when I run the files as ".txt" the code runs just fine. when I...
8
18803
by: iheartvba | last post by:
Hi I am using Access 2007 and am trying to export a query to a fixed length text file. I tried using the following code to export the text file: DoCmd.TransferText acExportFixed, , "qryFFRDeFile", "C:\qryFFRDeFile.txt", True Access asks for a specification name, now here lies the challenge, how do I create an export specification I have tried the following 2 methods: In access 2007: Step1: I right clicked the query and chose export to...
0
8736
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8649
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9083
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8934
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6571
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4410
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3102
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2398
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2035
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.