Table of Contents

Search

  1. Version 6.4.4
  2. Version 6.4.3 HotFix 1
  3. Version 6.4.3
  4. Version 6.4 HotFix 2
  5. Version 6.4 HotFix 1
  6. Version 6.4
  7. Version 6.3
  8. Version 6.2 Hot Fix 2
  9. Version 6.2 Hot Fix 1
  10. Version 6.2
  11. Version 6.1.1
  12. Version 6.1

Access Metadata Columns

Access Metadata Columns

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.


Updated October 14, 2019