Chapter 12 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.

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 is displayed.
3. Select the ASA Proxy Tables or ASE Proxy Tables extended model definition and click OK.
   
   The extended model definition is displayed in the list.
4. Click OK.

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

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:

• BasePackage:
  
  
  • Generation template - for generating proxy tables.
• DataSource:
  
  
  • Connection information custom 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 Database Connection tab of the data source property sheet.
  • GenerateAsProxyServer extended attribute - when set to true, defines the data source model as the proxy remote server.
  • [various templates] - used for proxy table generation.
• Model:
  
  
  • Proxy Servers and Tables generated files - to generate proxy server and table script files.
  • Menu – provides a contextual menu for building data sources and commands in the Tools menu for rebuilding data sources and generating proxy tables.
  • BuildProxyTableDataSourcesand GenerateProxyTables methods - used in the menu.
  • [various templates] - required for proxy server and proxy table 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 that the model replica is not the child of another table via a reference link.
  • [various templates] - required for proxy table, remote server and access definition creation syntax.

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