By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,779 Members | 1,078 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,779 IT Pros & Developers. It's quick & easy.

Can I customize DB2 catalog with my own tables?

P: n/a
Hi,

Is there a way to create user tables when you do a CREATE DATABASE command
with DB2?
If so, how?

Thx
Chris
Nov 12 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
"Chris Gruber" <ch**********@ianywhere.com> wrote in message
news:d7**********@newswest.sybase.com...
Hi,

Is there a way to create user tables when you do a CREATE DATABASE command
with DB2?
If so, how?

Thx
Chris

Not within the create database command, but you can create as script that
creates user tables after the create database.
Nov 12 '05 #2

P: n/a
Thanks

Some databases, install scripts that get run when a CREATE DATABASE command
is issued.
Am I correct to assume that DB2 does not have this type of setup with
scripts used by CREATE DATABASE command?

Thanks Again
Chris
"Mark A" <no****@nowhere.com> wrote in message
news:Hf********************@comcast.com...
"Chris Gruber" <ch**********@ianywhere.com> wrote in message
news:d7**********@newswest.sybase.com...
Hi,

Is there a way to create user tables when you do a CREATE DATABASE command with DB2?
If so, how?

Thx
Chris

Not within the create database command, but you can create as script that
creates user tables after the create database.

Nov 12 '05 #3

P: n/a
Mark A wrote:
"Chris Gruber" <ch**********@ianywhere.com> wrote in message
news:d7**********@newswest.sybase.com...
Hi,

Is there a way to create user tables when you do a CREATE DATABASE command
with DB2?
If so, how?

Thx
Chris


Not within the create database command, but you can create as script that
creates user tables after the create database.

"create database trigger" now that one I haven't heard yet....

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #4

P: n/a
Chris Gruber wrote:
Some databases, install scripts that get run when a CREATE DATABASE command
is issued.
Am I correct to assume that DB2 does not have this type of setup with
scripts used by CREATE DATABASE command?

There are stored procedures which are executed during CREATE DATABASE,
but they are not externalized.

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #5

P: n/a
"Chris Gruber" <ch**********@ianywhere.com> wrote in message
news:d7*********@newswest.sybase.com...
Thanks

Some databases, install scripts that get run when a CREATE DATABASE
command
is issued.
Am I correct to assume that DB2 does not have this type of setup with
scripts used by CREATE DATABASE command?

Thanks Again
Chris


Not sure I know what you are talking about.

You can create a script which includes a create database command,
immediately followed by any other SQL that will create the objects you need.
So I don't see why you need anything else.

If you want to know about the create database command and all its options,
check the Command Reference Manual which can be downloaded for free from the
IBM website.
Nov 12 '05 #6

P: n/a
Ian
Chris Gruber wrote:
Thanks

Some databases, install scripts that get run when a CREATE DATABASE command
is issued.


Are you referring to Oracle, where, after you do 'create database' you
run separate scripts like 'catalog.sql', 'catproc.sql', 'catexp.sql',
etc?

If so, then the answer to your question is No. The CREATE DATABASE
command does all of this internally.
Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.