Re: Restore SQL collection to a different name?

[R Bruce Hoffman <bruce.hoffman@xxxxxxxxxxxxxxxxx>]

On Wed, 2005-04-06 at 14:26, David Gibbs wrote:

> New collection, yes ... *NOT* a new schema (I consider the schema to be
> the database structure).  A collection (as I understand it) is simply a
> container for all the associated data, access paths, and other related
> bits of database information.  In other SQL systems it's simply called a
>  database.

Not on the iSeries David. The iSeries is a database. One database. And
one instance. The schema name was mapped to libraries. Collection was
the name given to libraries in the build process, but has been
supplanted by schema... you can now CREATE SCHEMA instead of CREATE
COLLECTION. Mutiple instances (IIRC) became supported with IASPs.

You connect to databases. You qualify to shemas.

-- 
"Bigamy is having one wife too many. Monogamy is the same."
-- Oscar Wilde