473,405 Members | 2,300 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

Display table structure graphically

Hello NG,

I'm quite new to using DB-2 and I wonder, if there's a tool to display/print the table structure graphically.

I seach the printed docs but I couldn't find anything.

Background: I have to take over a DB-2 project in quite a short time and I would like to have a quick overview over all tables.

Any hint ist greatly appreciated!
Best regards,

-Karsten.
--
Karsten P. Hoffmann 3M Deutschland GmbH
(no replies to the given email address please, it's just a spam collector :-) )
Oct 4 '06 #1
3 3105
Karsten P. Hoffmann wrote:
Hello NG,

I'm quite new to using DB-2 and I wonder, if there's a tool to display/print the table structure graphically.

I seach the printed docs but I couldn't find anything.
Download the DB2 Developer Workbench (free).
It has a schema-viewer where tables and their relations amongst each
other are shown. (shame lessly stolen from Rational).

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Oct 4 '06 #2
>"Karsten P. Hoffmann" <ka*****************@web.dewrote in message ..
>Hello NG,

I'm quite new to using DB-2 and I wonder, if there's a tool to
display/print the
table structure graphically.
The product is called DB2. Hopefully you are not referring to some other
product like dbase.

The major commercial products that will reverse engineer diagrams from the
actual schema definition are:

ERStudio - Embarcadero
ERWin - CA
PowerDesigner - Sybase

Visio also has some capabilities along these lines if you only want to view
the resulting schema diagram (it does not do forward engineering).
Oct 4 '06 #3
Karsten P. Hoffmann wrote:
Hello NG,

I'm quite new to using DB-2 and I wonder, if there's a tool to display/print the table structure graphically.

I seach the printed docs but I couldn't find anything.

Background: I have to take over a DB-2 project in quite a short time and I would like to have a quick overview over all tables.

Any hint ist greatly appreciated!
Best regards,

-Karsten.
The Aqua Data Studio product has 8 or ten different graphic displays of
whole or partial schemas. It is fairly inexpensive with impressive
support. A fully functional test version in downloadable from:
http://www.aquafold.com/

I am only a satisfied customer.

Oct 4 '06 #4

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

Similar topics

0
by: Dorthe Luebbert | last post by:
Hi, I am looking for a class to display trees graphically (SVG, Gdlib, whatever). It should look somehowlike this java driven example: ...
2
by: Stewart | last post by:
Hi Experts. Please put the code sample below into an html document and take a look at in NN6+. One span should be shown while the other is hidden. Clicking the button should reverse this. ...
2
by: Wayne Wengert | last post by:
I am trying to build an ASP.NET application which includes the capability to allow users to save pictures to a SQL Server 2000 database table and then later to display selected photos (usually JPG...
1
by: John Phelan-Cummings | last post by:
When I add the name of a new individual in a, bound form, it will not display that person’s name in a label control of a second unbound form. I have a scheduling program that I am working on. ...
4
by: rszebras | last post by:
I inherited a database (as a novice at Access) and need to modify it to make it more efficient, i.e., the assignment form needs to autopopulate with the client's name, address, phone number, etc.,...
24
by: Phil Latio | last post by:
Let's say I have a simple web application running with just two MySQL tables. The tables structure is as follows: Table: category category_id (PK) category_name parent_category (FK)...
12
by: active | last post by:
I've been looking on the Internet for a way to convert a DIB to a Bitmap without success. Now I'm wondering if that is the approach I should be taking. All I want to do is display the DIB or...
7
by: Dave | last post by:
I'm stuck on something and I've been trying to find some examples on it. I'm trying to show the data to my users as such: year1 year2 Q1 Q2 Q1 Q2 Smith my dataset...
0
by: remya1000 | last post by:
I have a field called Departments in my database. and I have 3 monitors. So when Page_Load, I need to check number of departments I have in database. And depends upon that number of departments I...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
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,...
0
Oralloy
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,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
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,...

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.