Re: Create table LIKE another including Primary key...

How often do you give your constraints a name versus let the system
generate a name?
Why?

For example, you can do

CREATE TABLE ORDLINE...
constraint ordline_key primary key
constraint ordline_to_ordhead foreign key order_number references ordhead
order_number

or you can do it without naming the ordline_key constraint or the
ordline_to_ordhead constraint and just let the system come up with it's
own names.
I do not believe you can have two constraints with the same name in the
same schema. (Which must make duplication fun.)

I suppose "meaningful" names might help if you do some error trapping.
Like maybe check the status code on a write in RPG and echo back the
constraint name displayed.

Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.