Table of Contents

Search

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

SQL Commands

SQL Commands

You can use modifiers at the end of SQL commands to modify the tables in the Data Vault.
REGISTER
To register the table, add REGISTER to the CREATE TABLE command.
Use the following syntax:
CREATE TABLE <table-name> (column definitions) [REGISTER];
PURGE
To physically delete the compressed data files belonging to a table, add PURGE to the DROP TABLE command.
Use the following syntax:
DROP TABLE <table-name> [PURGE];
PARTITION - Register
To register partitions for a table, specify the partition information in the INSERT INTO command.
Use the following syntax:
INSERT INTO <table-name> PARTITION ‘path1_arch’[:’path1_upd’] … ‘pathN_arch’[:’pathN_upd’];
PARTITION - Unregister
To remove the registration for certain partitions, specify the WHERE criteria for the partitions in the
DELETE FROM
command.
Use the following syntax:
DELETE FROM <table-name> PARTITION WHERE {VPART_ID = fileId}|{VPART_ID IN ( fileId1, …, fileIdN )} [PURGE];
PARTITION - Online or Offline
To set the status of specific partitions to online or offline, specify the WHERE criteria for the partitions in the UPDATE command.
Use the following syntax:
UPDATE <table-name> SET PARTION {ONLINE|OFFLINE} WHERE {VPART_ID = fileId}|{VPART_ID IN ( fileId1, …, fileIdN )};
EXPIRED BY
To delete specific records from a table based on the value in a column, add EXPIRED BY <column name> to the DELETE FROM command.
Use the following syntax:
DELETE FROM <table-name> EXPIRED BY <column-name>;
FROM FILE
To update a table, add FROM FILE 'update-file-path' to the UPDATE command.
Use the following syntax:
UPDATE <table-name> FROM FILE 'update-file-path';
PURGE TABLE
To physically delete the rows that were logically deleted by the DELETE FROM <table-name> EXPIRED BY command, use the PURGE TABLE command.
Use the following syntax:
PURGE TABLE <table-name>;