Effective in version 6.3, you can query metadata columns in a table in the Data Vault. For example, to determine when records will be eligible for purge, you can create a Data Visualization report based on the retention columns of a table.

To query a metadata column, you must access the Data Vault through a JDBC connection. Add the

HIDEMETAFIELDS

parameter to the JDBC URL and set it to

0

. Use the following syntax:

jdbc:infafas://<host name>:<port number>/sds?HIDEMETAFIELDS=0

Previously, you could not access the metadata columns in tables archived to the Data Vault.