Manage all aspects of database function sets
Available Sub Commands
delete
Delete an existing database function set.
Delete Arguments
Arguments | Description |
|---|---|
-h [ --help ] | Display this message. |
-n [ --name ] arg | The name of an existing database function set. |
Metadata Repository Login Arguments
Argument | Description |
|---|---|
--meta-dsn arg | ODBC DSN of the metadata repository. |
--meta-dsn-arch arg (=32) | The architecture of the ODBC DSN. Valid values are 32 and 64. Defaults to 32 if not specified. |
--meta-user-name arg | Username for the ODBC DSN. |
--meta-password arg | Password for the ODBC DSN. |
--meta-database arg | Database used by the ODBC DSN. |
--td-wallet | The supplied password will be treated as a TDWallet string. |
--dimension-space arg | A named area of the RDBMS to store DSS tables (Oracle, SQL Server and DB2). |
--index-space arg | A named area of the RDBMS to store the metadata (DB2 only). |
--meta-space arg | A named area of the RDBMS to store the metadata. |
--meta-index-space arg | A named area of the RDBMS to store the metadata indexes and constraints (Oracle, SQL Server and PostgreSQL). |
--meta-con-string arg | ODBC connection string for the metadata repository when using Advanced Connect. This arg will override the values stored in the RED Profile if provided. Accepts RED tokens $DSN$, $USER$ and $PASSWORD$. |
--red-profile arg | Path to the RED Profile file to be used with Advanced Connect, usually necessary for data warehouse actions when Advanced Connect is in use. |
duplicate
Duplicate a database function set.
Duplicate Arguments
Argument | Description |
|---|---|
-h [ --help ] | Display this message. |
--existing-name arg | The name of an existing database function set to duplicate. |
--new-name arg | The name to use for the new database function set. |
Metadata Repository Login Arguments
Argument | Description |
|---|---|
--meta-dsn arg | ODBC DSN of the metadata repository. |
--meta-dsn-arch arg (=32) | The architecture of the ODBC DSN. Valid values are 32 and 64. Defaults to 32 if not specified. |
--meta-user-name arg | Username for the ODBC DSN. |
--meta-password arg | Password for the ODBC DSN. |
--meta-database arg | Database used by the ODBC DSN. |
--td-wallet | The supplied password will be treated as a TDWallet string. |
--dimension-space arg | A named area of the RDBMS to store DSS tables (Oracle, SQL Server and DB2). |
--index-space arg | A named area of the RDBMS to store the metadata (DB2 only). |
--meta-space arg | A named area of the RDBMS to store the metadata. |
--meta-index-space arg | A named area of the RDBMS to store the metadata indexes and constraints (Oracle, SQL Server and PostgreSQL). |
--meta-con-string arg | ODBC connection string for the metadata repository when using Advanced Connect. This arg will override the values stored in the RED Profile if provided. Accepts RED tokens $DSN$, $USER$ and $PASSWORD$. |
--red-profile arg | Path to the RED Profile file to be used with Advanced Connect, usually necessary for data warehouse actions when Advanced Connect is in use. |
export
Export an existing database function set from a metadata repository to a file.
Export Arguments
Argument | Description |
|---|---|
-h [ --help ] | Display this message. |
-n [ --name ] arg | The name of an existing database function set. |
-f [ --file-name ] arg | The name of a file that a database function set will be written into. |
Metadata Repository Login Arguments
Argument | Description |
|---|---|
--meta-dsn arg | ODBC DSN of the metadata repository. |
--meta-dsn-arch arg (=32) | The architecture of the ODBC DSN. Valid values are 32 and 64. Defaults to 32 if not specified. |
--meta-user-name arg | Username for the ODBC DSN. |
--meta-password arg | Password for the ODBC DSN. |
--meta-database arg | Database used by the ODBC DSN. |
--td-wallet | The supplied password will be treated as a TDWallet string. |
--dimension-space arg | A named area of the RDBMS to store DSS tables (Oracle, SQL Server and DB2). |
--index-space arg | A named area of the RDBMS to store the metadata (DB2 only). |
--meta-space arg | A named area of the RDBMS to store the metadata. |
--meta-index-space arg | A named area of the RDBMS to store the metadata indexes and constraints (Oracle, SQL Server and PostgreSQL). |
--meta-con-string arg | ODBC connection string for the metadata repository when using Advanced Connect. This arg will override the values stored in the RED Profile if provided. Accepts RED tokens $DSN$, $USER$ and $PASSWORD$. |
--red-profile arg | Path to the RED Profile file to be used with Advanced Connect, usually necessary for data warehouse actions when Advanced Connect is in use. |
import
Import a database function set from a file.
Import Arguments
Argument | Description |
|---|---|
-h [ --help ] | Display this message. |
-f [ --file-name ] arg | The name of an existing file that contains the database function set. |
-d [ --default-dfs-path ] arg | The file system path where the default database function sets were installed. |
Metadata Repository Login Arguments
Argument | Description |
|---|---|
--meta-dsn arg | ODBC DSN of the metadata repository. |
--meta-dsn-arch arg (=32) | The architecture of the ODBC DSN. Valid values are 32 and 64. Defaults to 32 if not specified. |
--meta-user-name arg | Username for the ODBC DSN. |
--meta-password arg | Password for the ODBC DSN. |
--meta-database arg | Database used by the ODBC DSN. |
--td-wallet | The supplied password will be treated as a TDWallet string. |
--dimension-space arg | A named area of the RDBMS to store DSS tables (Oracle, SQL Server and DB2). |
--index-space arg | A named area of the RDBMS to store the metadata (DB2 only). |
--meta-space arg | A named area of the RDBMS to store the metadata. |
--meta-index-space arg | A named area of the RDBMS to store the metadata indexes and constraints (Oracle, SQL Server and PostgreSQL). |
--meta-con-string arg | ODBC connection string for the metadata repository when using Advanced Connect. This arg will override the values stored in the RED Profile if provided. Accepts RED tokens $DSN$, $USER$ and $PASSWORD$. |
--red-profile arg | Path to the RED Profile file to be used with Advanced Connect, usually necessary for data warehouse actions when Advanced Connect is in use. |
list-all
List all database function sets.
List All Arguments
Argument | Description |
|---|---|
-h [ --help ] | Display this message. |
Metadata Repository Login Arguments
Argument | Description |
|---|---|
--meta-dsn arg | ODBC DSN of the metadata repository. |
--meta-dsn-arch arg (=32) | The architecture of the ODBC DSN. Valid values are 32 and 64. Defaults to 32 if not specified. |
--meta-user-name arg | Username for the ODBC DSN. |
--meta-password arg | Password for the ODBC DSN. |
--meta-database arg | Database used by the ODBC DSN. |
--td-wallet | The supplied password will be treated as a TDWallet string |
--dimension-space arg | A named area of the RDBMS to store DSS tables (Oracle, SQL Server and DB2). |
--index-space arg | A named area of the RDBMS to store the metadata (DB2 only). |
--meta-space arg | A named area of the RDBMS to store the metadata. |
--meta-index-space arg | A named area of the RDBMS to store the metadata indexes and constraints (Oracle, SQL Server and PostgreSQL). |
--meta-con-string arg | ODBC connection string for the metadata repository when using Advanced Connect. This arg will override the values stored in the RED Profile if provided. Accepts RED tokens $DSN$, $USER$ and $PASSWORD$. |
--red-profile arg | Path to the RED Profile file to be used with Advanced Connect, usually necessary for data warehouse actions when Advanced Connect is in use. |
list-db-names
List all database names available for use in a database function set.
ListDBNames Arguments
Argument | Description |
|---|---|
-h [ --help ] | Display this message. |
Metadata Repository Login Arguments
Argument | Description |
|---|---|
--meta-dsn arg | ODBC DSN of the metadata repository. |
--meta-dsn-arch arg (=32) | The architecture of the ODBC DSN. Valid values are 32 and 64. Defaults to 32 if not specified. |
--meta-user-name arg | Username for the ODBC DSN. |
--meta-password arg | Password for the ODBC DSN. |
--meta-database arg | Database used by the ODBC DSN. |
--td-wallet | The supplied password will be treated as a TDWallet string. |
--dimension-space arg | A named area of the RDBMS to store DSS tables (Oracle, SQL Server and DB2). |
--index-space arg | A named area of the RDBMS to store the metadata (DB2 only). |
--meta-space arg | A named area of the RDBMS to store the metadata. |
--meta-index-space arg | A named area of the RDBMS to store the metadata indexes and constraints (Oracle, SQL Server and PostgreSQL). |
--meta-con-string arg | ODBC connection string for the metadata repository when using Advanced Connect. This arg will override the values stored in the RED Profile if provided. Accepts RED tokens $DSN$, $USER$ and $PASSWORD$. |
--red-profile arg | Path to the RED Profile file to be used with Advanced Connect, usually necessary for data warehouse actions when Advanced Connect is in use. |
modify
Modify an existing database function set.
Modify Arguments
Argument | Description |
|---|---|
-h [ --help ] | Display this message. |
-n [ --name ] arg | If supplied, then as well as updating the database function set from the XML file, it will be renamed to this value. |
-f [ --file-name ] arg | The name of an existing file that contains the database function set. |
Metadata Repository Login Arguments
Argument | Description |
|---|---|
--meta-dsn arg | ODBC DSN of the metadata repository |
--meta-dsn-arch arg (=32) | The architecture of the ODBC DSN. Valid values are 32 and 64. Defaults to 32 if not specified. |
--meta-user-name arg | Username for the ODBC DSN |
--meta-password arg | Password for the ODBC DSN |
--meta-database arg | Database used by the ODBC DSN |
--td-wallet | The supplied password will be treated as a TDWallet string |
--dimension-space arg | A named area of the RDBMS to store DSS tables (Oracle, SQL Server and DB2). |
--index-space arg | A named area of the RDBMS to store the metadata (DB2 only). |
--meta-space arg | A named area of the RDBMS to store the metadata. |
--meta-index-space arg | A named area of the RDBMS to store the metadata indexes and constraints (Oracle, SQL Server and PostgreSQL). |
--meta-con-string arg | ODBC connection string for the metadata repository when using Advanced Connect. This arg will override the values stored in the RED Profile if provided. Accepts RED tokens $DSN$, $USER$ and $PASSWORD$. |
--red-profile arg | Path to the RED Profile file to be used with Advanced Connect, usually necessary for data warehouse actions when Advanced Connect is in use. |
rename
Rename an existing database function set
Modify Arguments
Argument | Description |
|---|---|
-h [ --help ] | Display this message |
-n [ --name ] arg | If supplied, then as well as updating the database function set from the XML file, it will be renamed to this value. |
-f [ --file-name ] arg | The name of an existing file that contains the database function set |
Metadata Repository Login Arguments
Argument | Description |
|---|---|
--meta-dsn arg | ODBC DSN of the metadata repository |
--meta-dsn-arch arg (=32) | The architecture of the ODBC DSN. Valid values are 32 and 64. Defaults to 32 if not specified. |
--meta-user-name arg | Username for the ODBC DSN |
--meta-password arg | Password for the ODBC DSN |
--meta-database arg | Database used by the ODBC DSN |
--td-wallet | The supplied password will be treated as a TDWallet string |
--dimension-space arg | A named area of the RDBMS to store DSS tables (Oracle, SQL Server and DB2). |
--index-space arg | A named area of the RDBMS to store the metadata (DB2 only). |
--meta-space arg | A named area of the RDBMS to store the metadata. |
--meta-index-space arg | A named area of the RDBMS to store the metadata indexes and constraints (Oracle, SQL Server and PostgreSQL). |
--meta-con-string arg | ODBC connection string for the metadata repository when using Advanced Connect. This arg will override the values stored in the RED Profile if provided. Accepts RED tokens $DSN$, $USER$ and $PASSWORD$. |
--red-profile arg | Path to the RED Profile file to be used with Advanced Connect, usually necessary for data warehouse actions when Advanced Connect is in use. |
show
Show the contents of an existing database function set.
Show Arguments
Argument | Description |
|---|---|
-h [ --help ] | Display this message |
-n [ --name ] arg | The name of an existing database function set |
Database Function Set Arguments
Argument | Description |
|---|---|
| -h [ --help] | Displays a list of available sub commands and their description. |
Common Arguments
| Argument | Description |
|---|---|
-c [ --config-file ] <arg> | A configuration file that contains program options (format is INI file) |
| -o [ --output-mode ] <arg> | Either human, json or xml. |
| -l [ --log-level ] <arg> | Log level, 0-5 inclusive. 0=only fatal errors, 5=all logging messages. |