Hello.
I am using Apache derby database (Client network).
I see that when I create table it is created on an instance APP
(I don't know if instance is the correct word. sorry of my English).
I see that there are other instances (NULLID, SQLJ, SYS, etc).
Can I create an instance of my own in derby database, and how can I do
that
?
(One instance may be used for repository, another for Datawarehouse, ...)
Another thing :
If I create several databases for te above reason (repository may be on
another db), how can I join them, when I am connected to database1, and
want
to run a query that join both tables from database1 and database2 ?
Thanks :)
|
