Refresh catalog - connect_cdc_mimix_share - 5.8

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
ft:lastEdition
2024-02-12
ft:lastPublication
2024-02-12T15:11:59.486869

Usage

Queries the catalog to add descriptions of “available” tables to the model definition. Available tables are those that have not yet been explicitly used in a distribution definition.

Syntax
REFRESH CATALOG AT [ SERVERS ] server-name, ...
   ( catalog-name{ : | . }schema-name.table-name, ... )
   [AS { TABLE | VIEW | ALIAS | SYSTEM TABLE |}
   [ DEFER COLUMNS ]
;
Note: TABLE is the default and SERVERS is an optional keyword.
Parameters

Parameter

Description

catalog-name{ : | . }schema-name.table-name

Use a string in this format to filter the list of tables in the catalog by database (if applicable), owner, and table. You can use the wildcards described below instead of specific object names.

[AS { TABLE | VIEW | ALIAS | SYSTEM TABLE }

Use to specify the type of catalog object to be queried.

DEFER COLUMNS

If this parameter is specified, the REFRESH CATALOG statement returns table names, but it does not fetch the column names and types (and indexes). That column information is later retrieved if the table is defined as a shared table or is used in a default table mapping. As a result, time is not spent fetching columns of tables that will not be distributed.

Use wildcards

Wildcard

Usage

Example

%

Returns all tables with any characters following the %.

Note: Requires double-quotes enclosing the text that contains %.

  • "%"."%"."%"Returns all tables in all catalogs.

  • Mycat."%"."%"Returns all tables in catalog Mycat.

  • "%"."%"."emp%"Returns all tables with a tablename beginning with "emp."

_

Accepts any value for a single character.

Mycat.Myschema.Table_Returns all tables with the explicitly given letters and an additional character value for the underscore(_).

 

Note: Both wildcards may be used together.
Example
refresh catalog at UDB95 ( "QADBA"."DTS%");
refresh catalog at SERVERS AS03,UDB ( "QA%"."T%") DEFER COLUMNS;
refresh catalog at SERVERS AS03 ( "QA%"."T%") AS ALIAS;
refresh catalog at Informix ( "qatest":"qadba"."dts1");
refresh catalog at ms2008 ( "qatest"."dbo"."cust%") AS VIEW;