PublishMetadataToION macro

The PublishMetadataToION macro publishes Outbox Metadata to the ION Registry. This macro command is executed at System level.

For executing the macro, the value in the Command field for the macro definition must be specified in this format: 

PublishMetadataToION([Table Area], [Table Group Name], [Table Name], [Include User-Defined], [User-Defined Only], [Schema Prefix])
Note: The optional parameters are specified in [ ].

These parameters are used for the macro:

Parameter Name Description
Table Area The table area in which to publish the metadata to the ION Data Catalog.
Table Group Name The Table Group to publish metadata to the ION Data Catalog.
Table Name The Table to publish metadata to ION Data Catalog.
Include User-Defined Determines whether the metadata for user-defined tables must be published. Possible values:
  • Yes: User-defined tables are included
  • No: user-defined tables are not included
Note: If not specified, user-defined tables are not included.
User-Defined Only Determines whether the metadata for only user-defined tables is published. Possible values:
  • Yes: Only user-defined tables have the metadata published to ION Data.
  • No: All tables specified have the metadata published to ION Data.
Note: If not specified, all tables specified are published.
Schema Prefix Publish the metadata to ION Data Catalog using the specified prefix.
Note: If not specified, the prefix is set to <empty>.

This table lists examples of the PublishMetadataToION macro:

Requirement Syntax
Publish the metadata on all standard Outbox tables to ION Data Catalog. PublishMetadataToION("Outbox", "", "", "", "", "")
Note: The format of published table name is "SCP table name>”.
Publish the metadata on all user-defined Outbox tables to ION Data Catalog with prefix "UD". PublishMetadataToION("Outbox", "", "", "Yes", "Yes", "UD")
Note: The format of published table name is "SCP_UD_<table_name>".
Publish the metadata on all master data tables in Inbox to ION Data Catalog. PublishMetadataToION("", "Master_Inbox", "", "Yes", "", "")
Note: The format of published table name is "SCP table name>”.
Publish the metadata on the user-defined table "SUO_MY_PLAN" to ION Data Catalog. PublishMetadataToION("", "", "SUO_MY_PLAN", "Yes", "", "")
Note: The format of published table name is "SCP table name>”.
Publish the metadata on the user-defined table "SUO_MY_PLAN" to ION Data Catalog with prefix "INS1". PublishMetadataToION("", "", "SUO_MY_PLAN", "Yes", "", "INS1")
Note: The format of published table name is "SCP_INS1_<table_name>".