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

Conference ilbbak::ibi_focus

Title:FOCUS, from INFORMATION BUILDERS
Moderator:ZAYIUS::BROUILLETTE
Created:Thu Feb 19 1987
Last Modified:Mon May 05 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:615
Total number of notes:1779

329.0. "{ what goes on here ? }" by TOLKIN::SWEENEY () Tue Mar 27 1990 12:56

    
    
       I'm having no luck using AUTORDB against a database
       created in TEAMDATA.
    
       The relation is TDA$PRODUCTS and exists in TEAMDB.RDB when I 
       do a rdo show relations, however AUTORDB comes back with
       "ZERO RECORDS RETRIEVED FROM RDB FILE AND/OR
       RELATION NAME NOT FOUND"
    
       I have tried to use a logical name for the DB as well as
       the relation with the same results.
    
       Any ideas ? 
    
    
       Thanks
    
       Chris
T.RTitleUserPersonal
Name		DateLines
329.1Probably uses RDB $RELATIONSPLOP::COYLETue Mar 27 1990 14:5213

    Chris,

         If you get into RDO and do a show relations all, you will see a
relation called RDB$RELATIONS.  My guess is that there is also one for 
teamdata relations and that FOCUS is only looking at the RDB$RELATIONS
relation when runnning the AUTORDB procedure.


                                              KC
329.2autordb.fex requires patch ....TOLKIN::SWEENEYThu Mar 29 1990 14:3336
************
File SYS$SYSDEVICE:[FOCUS]AUTORDB.FEX;2
  103                  IF RELNAME CONTAINS '&SRELNAME'
  104   ON TABLE HOLD AS IXTEMP
******
File SYS$SYSDEVICE:[FOCUS]AUTORDB.FEX;1
  103                  IF RELNAME IS '&SRELNAME'
  104   ON TABLE HOLD AS IXTEMP
************
************
File SYS$SYSDEVICE:[FOCUS]AUTORDB.FEX;2
  118   IF RELNAME CONTAINS '&SRELNAME'
  119   IF IDX_UNIQUE EQ 1
******
File SYS$SYSDEVICE:[FOCUS]AUTORDB.FEX;1
  118   IF RELNAME IS '&SRELNAME'
  119   IF IDX_UNIQUE EQ 1
************
************
File SYS$SYSDEVICE:[FOCUS]AUTORDB.FEX;2
  215                   '$'|' FIELD='''|FNAME|''', ALIAS='''|FLD_NAME|''''|TYPE||',$'
  216                   ELSE  ' FIELD='''|FNAME|''', ALIAS='''|FLD_NAME|''''|TYPE||',$';
  217   ACCEPT/I1=IF ANAME EQ ' ' THEN 1
******
File SYS$SYSDEVICE:[FOCUS]AUTORDB.FEX;1
  215                   '$'|' FIELD='|FNAME|', ALIAS='|FLD_NAME||TYPE||',$'
  216                   ELSE  ' FIELD='|FNAME|', ALIAS='|FLD_NAME||TYPE||',$';
  217   ACCEPT/I1=IF ANAME EQ ' ' THEN 1
************

Number of difference sections found: 3
Number of difference records found: 4

DIFFERENCES /IGNORE=()/MERGED=1/OUTPUT=SYS$SYSDEVICE:[FOCUS]PAM.LIS;1-
    SYS$SYSDEVICE:[FOCUS]AUTORDB.FEX;2-
    SYS$SYSDEVICE:[FOCUS]AUTORDB.FEX;1