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
5  2494 
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
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.
"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.
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!
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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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...
|
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
|
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?
|
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
|
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...
| | |
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:
|
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
|
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
|
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...
|
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...
|
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...
| | |
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,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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...
| | |
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
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
