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

Conference azur::mcc

Title:DECmcc user notes file. Does not replace IPMT.
Notice:Use IPMT for problems. Newsletter location in note 6187
Moderator:TAEC::BEROUD
Created:Mon Aug 21 1989
Last Modified:Wed Jun 04 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:6497
Total number of notes:27359

841.0. "3rd Party Front-end Reporting Tools?" by LTLKNG::TAZBOY::ZIGLER (Tom Zigler DTN:432-7541) Mon Mar 25 1991 13:30

    Suppose a customer purchases the DECmcc BMS V1.1 software.  He then
    wishes to utilize the EXPORT FM to export historical data into the VAX
    Rdb/VMS database.  However, suppose he wishes at this point to use some
    other 3rd party user front-end, such as FOCUS, to generate the actual
    reports and graphs.  Does the DECmcc BMS V1.1 software provide him with
    sufficient information to enable him to extract the desired data for
    reporting purposes WITHOUT utilizing VAX DATATRIEVE and VAX DECgraph?
    
    I need to clarify our official position on this point for potential
    DECmcc BMS V1.1 customers.  
    
    Please advise.
    
    			\Thanks in Advance
T.RTitleUserPersonal
Name
DateLines
841.1Use anything that can access RdbBSYBEE::EGOLFJohn C. Egolf LKG2-2/T02 x226-7874Mon Mar 25 1991 17:418
	Tom,

	Once you've  EXPORTed  the data to Rdb, you can use *ANY* tools
	to move it elsewhere.  You can write a Cobol program or a Bliss
	program, you can use  any tool that can access Rdb.  You do not
	have to use DTR.

	JCE
841.2Documentation?LTLKNG::TAZBOY::ZIGLERTom Zigler DTN:432-7541Tue Mar 26 1991 17:4314
    Re: .1
    
    Yes, but does the documentation provide the end user with the necessary
    and sufficient information to be able to know HOW to apply the third
    party front-end user interfaces?  For example, is there VAX Rdb/VMS
    schema information necessary to know and provided in the documentation
    to allow me to access the Rdb data using a third party database access
    tool such as FOCUS?  I have gotten the impression from other replies in
    this conference that it took some doing for folks to figure out how to
    use even DECdecision, for instance.
    
    Please advise.
    
    			\Thanks in Advance
841.3No documentation about structure of relationsTOOK::R_LANEThu Mar 28 1991 12:2035
> For example, is there VAX Rdb/VMS schema information necessary to know and
> provided in the documentation to allow me to access the Rdb data using a
> third party database access tool such as FOCUS?

The current Exporter documentation does not provide the information about
the created relations (tables).

There are a few problems associated with having to provide the information
about the relations in the Exporter documentation.  The Exporter creates
the relations "dynamically" based on entity attribute information in the
MCC dictionary.  The data in the MCC dictionary is subject to change. 
Also, the Exporter creates a relation for each class of entities (NODE4,
NODE4 LINE, NODE4 CIRCUIT, ...).  There would have to be quite a lot of
documentation to cover all the possibilities.

It's quite easy for a user to determine the structure of the relations
created by the Exporter using the available database access tools.  For
example, using interactive SQL, the user can determine the structure of a
relation as follows:

    $ SQL
    SQL> DECLARE SCHEMA FILENAME <file spec>;
    SQL> SHOW TABLES

        ... tables (relations) in database are listed ...

    SQL> SHOW TABLE <table name>

        ... displays table structure ...

    where <file spec> is the file specification for the Rdb database and
    <table name> is the name of the relation.

---
Roy
841.4document .3 and the algorithm usedTOOK::DITMARSPeteFri Mar 29 1991 09:375
I got a brief verbal description (from Sam) of the algorithm that Exporter uses 
to create the table definitions dynamically.  If it doesn't already, the 
documentation should contain the method for determining the structures 
(as given in .3) and maybe the explanation of how the tables are 
constructed (as dictated by Sam).