

DDLEXPRT - Utility to export metadata from VW (OS/2)


  About ddlexprt.exe

  The utility runs stand-alone.  The exec is an extensive modification
  of the ddlutil from the desktop of the current product.  The modifications
  are made for the purpose of migrating existing metadata to the implemention
  on NT, and not intended as a replacement of ddlutil.   To run it, enter
  the following at a command prompt:
  A:> ddlexprt

  When you run this exec stand-alone, the look and feel will be exactly like
  ddlutil, but you should only exercise the functions described here.  We 
  offer no assurance that other functions on the menu will function the same
  way as their counterparts in ddlutil.

  The metadata must be exported in two steps.  

  (1) First export all objects related to information resources (databases,
      tables, columns etc).  Users, UserGroups etc. are exported along with
      these.  

      From the main window, select file/export, then DataGuide/2_Tag followed
      by InformationResources.  Enter password and tag file name as prompted.

  (2) Then export BusinessViews and related objects.  This includes BV alias,
      schedule, map, etc.

      From the main window, select file/export, then DataGuide/2_Tag followed
      by BusinessView_Information.  Enter password and tag file name as prompted.
      Since the purpose of this utility is to export all your metadata, you
      will want to select all security groups listed.

      Only business views in production or suspend mode are exported.
      To precisely represent the various relationships between objects, the 
      utility defines "relationship_objects" in addition to the meta objects
      found in the system.  These are exported as though they are part of the
      system.  



  Using DataGuide  

  You can use DataGuide to display the output (the user is assumed to be familiar
  with DataGuide's operating procedure).  Please note:

  (1) You must import the Information Resources tag file to DataGuide first.
      Objects in the BusinessView tag file references objects in this tag file.

  (2) Some relationships between objects are hierarchical ("contain" - in TAG
      language) but others are lateral ("link").  The former will be obvious
      in DataGuide display - you'll know you can expand it.  The latter can be
      seen by opening the object only.

  (3) Specify a path to the icon files contained in this diskette.  For example,
      if you choose to leave them on the diskette, then specify "a:"  as the
      path on DataGuide's import window.

  (4) No attempt was made to create new icons for this extension of the export
      utility.  Therefore, the display will show some VW icons used for objects
      in unfamiliar ways.  For example, icon for atomic BV is used for map.



  Specifics about the export:
  
  - The name of the SubSystem object is also exported as that of the Database
    (or ConnectResource) object.  This is in anticipation of changes in the
    NT implementation of the Visual Warehouse.  The hostDbName of the Database 
    object is exported as the property 'dbname'. 
  - Since all attributes of a schedule object are exported but a given schedule
    type may only use a subset of them, undefined attributes will contains the
    value '99'.



