[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::dbintegrator_public_public

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

1147.0. "DBI and dbkey lengths greater than 0" by DIGANT::GREEN () Tue Apr 08 1997 12:06

Hi All,

On page 11-8 of the Rdb Distributed Option Product Family User Guide (V7) it
says that DBI always returns a dbkey value greater than 0.

I've create a union view in DBI of two Rdb tables and the dbkey length of this
view is 0.  Is this a bug or a documentation error?

In the following example the first two relations are Rdb tables, the last 
is a DBI union view.

SQL> attach 'f /type=dbi/dbname=dbi_catalog';
SQL> select rdb$relation_name, rdbdbi$dbkey_type, rdb$dbkey_length
cont> from rdb$relations
cont> where rdb$system_flag=0;
 RDB$RELATION_NAME                 RDBDBI$DBKEY_TYPE   RDB$DBKEY_LENGTH
 DG_UNION_LEFT                                     1                  8
 DG_UNION_RIGHT                                    1                  8
 DG_UNION_VIEW                                     0                  0

Thanks,
Don
T.RTitleUserPersonal
Name		DateLines
1147.1Need union all view to see dbkeysBROKE::ABUGOVTue Apr 08 1997 14:569
    
    Hi Don,
    
    This assumes that it is possible to uniquely identify a row.  If you
    changed your view to a union all view (I assume you have a union view)
    then you will see dbkeys.  You can't use dbkeys in union views, you can
    in union all views.
    
    dan
1147.2Thanks - will report backBROKE::GREENTue Apr 08 1997 16:0411
    Hi Dan,
    
    Thanks.
    
    I think I'll have to revisit my test.  Yes, I used a union view.  But
    now that I look back at the customer's mail he claims he did a union
    all view.  
    
    Back to the drawing board.
    
    Don
1147.3100% correctBROKE::GREENTue Apr 08 1997 16:116
    Dan,
    
    Right as rain on the union all view.
    
    Thanks,
    Don
1147.4doc bug 476705BROKE::GREENWed Apr 09 1997 16:268
    Created a documentation bug for this.  Bug number is 476705.
    
    Mentioned that a DBI union view does have a dbkey length of 0.  Our
    doc says the opposite.
    
    Also mentioned that if someone has imported an Rdb view into DBI then
    you can also have dbkey lengths of 0.  I mention this in the doc bug 
    because it isn't mentioned in the doc.