473,327 Members | 2,118 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,327 software developers and data experts.

Exporting just schema/metadata (w/o data) in DB2

I was just wondering if we can export just the schema/metadata in DB2
(i.e. just the table and column information, without the data). Is
there an easy way to do this in DB2?

Thanks in advance.

Nov 12 '05 #1
2 2123
ga********@gmail.com wrote:
I was just wondering if we can export just the schema/metadata in DB2
(i.e. just the table and column information, without the data). Is
there an easy way to do this in DB2?


Have a look at the "db2look" tool.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Nov 12 '05 #2
If you are looking for a script to run, the db2look tool is best. If
you want to query it, the system catalog tables have it. Look at SQL
Reference Volume 1 Appendix D "Catalog Views". Of specific interest
would be SYSCAT.TABLES and SYSCAT.COLUMNS.

B.

Nov 12 '05 #3

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

Similar topics

1
by: Brett Selleck | last post by:
I would like to start collecting Metadata on my XML schemas. I have searched the web for a method of automatically extracting Metadata from an XSD file and have come up empty handed. Basically what...
0
by: microdevsolutions | last post by:
Hello I am wanting to cycle-through/parse the following XML and manipulate the values row by row via VBS and through DOM. This is not a problem however, as you can see the schema is before the...
1
by: TY | last post by:
Any tips on exporting my existing Q&A 4(DOS) to access 2002. I have the following options in Q&A, DIF Standard ASCII Fixed ASCII dBase II " III " IV Paradox 2.0/3.0
7
by: Sharon | last post by:
I have successfully loaded a DataSet object with a XML schema (XSD). Now I wish to populate the tables that was created in the DataSet. I have an XML file/string that contain all the needed data...
2
by: Anony Mous | last post by:
Hi, I've seen in previous posts that recommended practice for database backup is to run the dump utility twice. Once for schema only and a second time for data only (I think). Up to know,...
6
by: Kevin Chambers | last post by:
Hi all-- In an attempt to commit an Access MDB to a versioning system (subversion), I'm trying to figure out how to convert a jet table's metadata to text, a la SaveAsText. The end goal is to...
0
by: nevis | last post by:
Hi, Given a CSV or Excel document containing XML schema field names and test data, how can we generate an XML file populated with the test data, conforming to an XML schema? My guess is that there...
0
by: xman | last post by:
Anyone who uses SQL Server is familiar with the scripting capabilities that the Enterprise Manager or the SSMS offer. Being able to script an object or an entire database is great, however, often...
1
by: news.magnet.ch | last post by:
Hi all Probably an easy question for an oracle dba or even power user: I would like to copy the data warehouse schema on my laptop for testing and developing our application. - Unfortunately...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.