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.
REFRESH CATALOG AT [ SERVERS ] server-name, ...
( catalog-name{ : | . }schema-name.table-name, ... )
[AS { TABLE | VIEW | ALIAS | SYSTEM TABLE |}
[ DEFER COLUMNS ]
;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 %. |
|
|
_ |
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(_).
|
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;