| Title: | DB Integrator Public Conference |
| Notice: | Database Integration - today! Kit/Doc info see note 36 |
| Moderator: | BROKE::ABUGOV |
| Created: | Mon Sep 21 1992 |
| Last Modified: | Fri Jun 06 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 1171 |
| Total number of notes: | 5187 |
Is it possible to define tables to DBI that are made up of only certain
fields of the tables in the source database? Or must we define the
entire table as it is in the database? Our customer wants to limit
what the PC users see and only present a few of the fields in certain
tables instead of the entire table. Is this possible?
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 1059.1 | Define VIEWS | BROKE::SERRA | You got it, we JOIN it....DBI | Thu May 23 1996 14:40 | 13 |
create a view in DBI. this 'local' view will be stored in the DBI
catalog and would be limited to the columns of the underlying table
that you want to present to the end user.
Or, you can create the view(s) in the underlying database and only import
the view to the DBI catalog.
hope this helps
steve
| |||||
| 1059.2 | Oh yeah, that would it work! | ORAREP::CHOWDA::ORR | Thu May 23 1996 17:10 | 6 | |
Yes, it helps plenty. In fact, it such a nice and simple answer, that
I'm embarrased that I didn't think of it!
Thanks again...
Elaine
| |||||