SQL-92 View

From: Gerben Wieringa

Date: 1 Feb 2005

Hi everybody,

Windows
OE10.0A

we have a system with two databases, every night a script builds a new
datawarehouse-database from these two databases. (will be used by
BusinessObjects)
It does this by deleting the old database en dumping the two
databases. It loads the df's, the data etc.

Now we would like to add a VIEW to this database. With the
SQL-explorer this can easily be done. However, when the database is
deleted the view is gone as well. So i'm looking for a solution to
solve this problem:
- it doesn't get dumped when i dump all data and definitions.
- dumping/loading SQL-views from the Data Administration doesn't help,
it's a SQL-92 view.
- i /can/ dump the view with the SQLSCHEMA utility

- but how do I load the SQL-92 view without user-interaction so that
it can be scripted?

Searching the PEG and the knowledge base hasn't helped me so far.
Any ideas? (maybe a different solution for the problem?)

TIA

-- 
G e r b e n   W i e r i n g a

VCD Automatisering
The Netherlands

Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs, and the Universe trying
to produce bigger and better idiots. So far, the Universe is winning.
- Rich Cook