create views
Jane Vohden asked whether a view can be created in one database over tables in another. Andrew Hamm saw no reason why not; Brett Randall confirmed yes, provided both databases have the same logging mode. Flavio Gattari added that in IDS 9.21 the tables must not have BLOB columns or the error 'not implemented yet' appears. Answered.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Can you create a view in one database that looks at a table(s) in another database? Thanks. - Jane ------------------------------------------------- Jane Vohden Database Administrator Fairbanks North Star Borough --------------------------------------------------
Jane Vohden wrote in message <957n9s$lhn$1@news.xmission.com>... > >Can you create a view in one database that looks at a table(s) in another >database? Can't see why not. What does the SQL manual say in the CREATE VIEW pages?
Jane Vohden wrote: > > Can you create a view in one database that looks at a table(s) in another > database? > Thanks. - Jane > > ------------------------------------------------- > Jane Vohden > Database Administrator > Fairbanks North Star Borough > -------------------------------------------------- Yes. See (other) Brett's post for syntax. The two databases will need to have the same logging mode. Brett Randall
Jane Vohden ha scritto nel messaggio <957n9s$lhn$1@news.xmission.com>... > >Can you create a view in one database that looks at a table(s) in another >database? >Thanks. - Jane > >------------------------------------------------- >Jane Vohden >Database Administrator >Fairbanks North Star Borough >-------------------------------------------------- > 1) the two databases must have same logging mode 2) in IDS 9.21 (IDS2000) involved tables must NOT have BLOB columns; if they have, yuou would get the error "not implemented yet" in response (IDS 9.21 does not allow remote access to tables with BLOB columns) flavio gattari