Chapter 14 DBMS-Specific Features

Understanding the ProxyTables extended model definition

For an external shortcut or replica to be used as a proxy table you need to attach the ProxyTable extended model definition to the model.

Steps To attach the ProxyTables extended model definition to an existing model:

  1. Select Model→Extended Model Definitions.
  2. Click the Import an Extended Model Definition tool.

    A selection dialog box appears.
  3. Select the ASA Proxy Tables extended model definition and click OK.

    The extended model definition appears in the list.
  4. Click OK.

Note   Select ProxyTables XEM at model creation
You can also select the ASA Proxy Tables XEM in the Extended Model Definitions page of the New dialog box

The ProxyTables extended model definition contains generation templates, extended attributes, custom checks and custom methods to support the definition of external proxy tables in Sybase ASA.

You can double-click the ProxyTables extended model definition in the Browser to display its properties in the resource editor. The following extensions must be defined in the Profile category to fully support proxy tables:

Metaclass Extension type Description
DataSource Connection information custom check This check verifies that the connection information is sufficient to connect to the database. You must specify the data source name, user login and password in the ODBC page of the data source property sheet.
  GenerateAsProxyServer extended attribute When set to true, defines the data source model as the proxy remote server.
  Different templates Used for proxy table generation.
Model Proxy Servers and Tables generated files Used to generate proxy server and table script files.
  Menu Contextual menu for building data source and command in the Tools menu for rebuilding data source and generating proxy tables.
  Methods BuildProxyTableDataSources and GenerateProxyTables Methods used in the menu.
  Templates Templates required for proxy servers and proxy tables script generation.
Shortcut Data source existence custom check Verifies that data sources are defined for the shortcuts.
Table Proxy table is child of reference custom check Verifies if the model replica are not child of another table via a reference link.
  Templates Templates required for proxy table, remote server and access definition creation syntax.

 

Copyright (C) 2005. Sybase Inc. All rights reserved.