DB2 extract schema script 
Author Message
 DB2 extract schema script
hi all,

I was wondering if there is a simple way to extract a schema script (tables
only) from an IBM DB2 running on S/390. I don't know a lot about mainframe
servers and about DB2, so I fyou can help me I will appreciate.

Thank you for your help...

Jos



Thu, 01 Dec 2005 23:41:59 GMT
 DB2 extract schema script

I don't understand your question. What do you mean by a "schema script"?

Are you trying to get a list of all the schemas in a given DB2 subsystem in
OS/390? Where are you trying to extract the schemas to?

If you just want to display a list of the schemas in your DB2 subsystem, you
can go into SPUFI and try this query:
select distinct creator
from sysibm.systables

This will display the result in the SPUFI output file.

Rhino

Quote:

> hi all,

> I was wondering if there is a simple way to extract a schema script
(tables
> only) from an IBM DB2 running on S/390. I don't know a lot about mainframe
> servers and about DB2, so I fyou can help me I will appreciate.

> Thank you for your help...

> Jos



Fri, 02 Dec 2005 23:09:30 GMT
 DB2 extract schema script
If you have access to a control center (gui),
attach/connect to the host db,
right click on the schema object and then
use the Generate DDL menu.

If you have access to a db2 client outside the host, i suggest you use the
db2look command line tool.

If not, you can use the DCLGEN tool on the mainframe.

http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dsncrh12/2.16?ACT...
CHES&REQUEST=DCLGEN&TYPE=FUZZY&SHELF=dsnshh11&DT=20020822134552&searchTopic=
TOPIC&searchText=TEXT&searchIndex=INDEX&rank=RANK&ScrollTOP=FIRSTHIT#FIRSTHI
T

etc.

PM



Sat, 03 Dec 2005 00:53:36 GMT
 DB2 extract schema script
Hi Rhino,

sorry I haevn't been very accurate in my request. In fact what I want is to
connect to a schema and get the create table script for all the tables of
this schema.

but i think that PM has given me the answer.

Thanks for your help, I really appreciate.

regards

jos



Quote:
> I don't understand your question. What do you mean by a "schema script"?

> Are you trying to get a list of all the schemas in a given DB2 subsystem
in
> OS/390? Where are you trying to extract the schemas to?

> If you just want to display a list of the schemas in your DB2 subsystem,
you
> can go into SPUFI and try this query:
> select distinct creator
> from sysibm.systables

> This will display the result in the SPUFI output file.

> Rhino




- Show quoted text -

Quote:
> > hi all,

> > I was wondering if there is a simple way to extract a schema script
> (tables
> > only) from an IBM DB2 running on S/390. I don't know a lot about
mainframe
> > servers and about DB2, so I fyou can help me I will appreciate.

> > Thank you for your help...

> > Jos



Sat, 03 Dec 2005 02:45:10 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. DB2 Newbie needs help with DB2 5.2 ODBC: can browse schema, but get no data

2. schema script or DDL script

3. Extracting "Column Description" from schema

4. Extracting the Schema for a database - MSSQL 6.5

5. XML Extract from Mapping Schema

6. Extract metadata (schema)

7. Extracting database schema

8. table schema extract

9. Unix Based Schema Extract Utility - Again

10. Wanted: Unix Based Schema Extract Utility

11. Extract Table Schema

12. Extract Table Schema


 
Powered by phpBB® Forum Software