Extract Mainframe Schema GUI

The Extract Mainframe Schema option of the HCO for SQL Server main window is the GUI used to interface with the Schema Extractor tool.

This tool maintains a catalog of mainframe and destination database connections. For each connection it records the provider used to access the connection and the connection parameters used by the provider.

Once a connection with the mainframe database is established, a list of available schemas is returned and populated in the right-hand section of the tool's window. You now select the schemas that you wish to extract, give the extraction a name, and execute the extraction. Upon successful completion, a database is created, which contains the schemas you selected. When the extraction completes, you can view the status from the Results tab.

Extraction Controls and Steps

These steps describe how to perform an extraction, and the corresponding Extract Mainframe Schema control.

  1. In the Database field, select the database that you wish to extract schema objects from. If there are no options to select, you need to create DSNs by using the Micro Focus for ADO.NET Connection Editor. See the topic Data Source Connections and Cataloging for details.

    Depending on your DSN settings, you will be prompted for a user ID and password.

    Once the connection completes, a list of schema objects will display in the right-hand section.

  2. From the Extract column of the returned schema table, check the objects you wish to extract.

    Tip: For optimal performance, limit the number of schemas selected to 10.

  3. In the Extract Name field, provide a name for the extraction (i.e. a name for the database that will contain the selected schemas).
    Local option Saves the extraction to your computer at the location as specified in the Options window, which is accessed from the Visual Studio menu Tools/Options/Micro Focus COBOL Tools/HCO for SQL Server. If using the stand-alone .exe to bring up the tools, Options appear under the Activities pane. The default location is: Documents and Settings\user-name\Application Data\Micro Focus\Net Express\6.0\HCOSS\Schemas
    Shared option Saves the extraction to a shared destination as specified in the Options window, which is accessed as described for the Local option.
  4. Click the Extract button.
  5. You are switched to the Results tab where you can verify that the schema database file was created.

    If you get a -551 SQL error extracting a table, you need to have your DB2 DBA grant you READ access to that system table.

You are now ready to use the Transfer List Manager tool to create a list of schemas from your newly extracted schema database.

Related Topics