Output Schema of the LIST Command¶
This section lists the output of the of the
LIST commands when
executed from a JDBC or an ODBC client.
When these commands are executed from the “VQL Shell” of the Administration Tool, they return information that should only be used for debugging purposes and may change in the future.
The output schema of all the
LIST commands (
LIST DATASOURCES …) has only one column:
name, except for the
LIST JARS: returns the columns:
FUNCTIONS. The values of the columns
NULLif the jar does not contain a custom function. Otherwise, the output contains a row for each type of function of the jar:
FUNCTIONS_TYPE: indicates the type of the function:
FUNCTIONS: names of the functions contained in the jar.
LIST FUNCTIONS CUSTOM: contains the columns
SYNTAX. The command returns a row for each signature of each function. The
TYPEcolumn indicates if the function is an aggregation function or a condition function.
LIST ROLES: contains the columns
ROLES. The last column contains the list of roles granted to this role.
LIST DATABASES INFO: contains the columns
DESCRIPTIONand then a set of columns with various database configuration data.