MicroStrategy ONE

List DBConnection Properties statement

Lists current values for the properties of a DBConnection.

Copy 
LIST [ALL] 
 PROPERTIESFOR 
 DBCONNECTION "dbconnection_name";

where:

"dbconnection_name" is the name of the database connection for which to list properties, of type string.

Example

Copy 
LIST ALL PROPERTIES FOR DBCONNECTION "DBConn1";

ResultSet Columns

LIST ALL PROPERTIES FOR DBCONNECTION (DSN)

  • CHARSET_ENCODING: The character set for the database connection, such as "UTF8". Returned as a string.

  • UNIX_CHARSET_ENCODING: The character set for the database connection on a UNIX/Linux system, such as "UTF8". Returned as a string.

  • DEFAULT_LOGIN: The default login name for the database connection, returned as a string.

  • DRIVER_MODE: The mode of the driver for the database connection, such as "MultiProcess. Returned as a string.

  • EXEC_MODE: The execution mode of the database connection, such as "Synchronous". Returned as a string.

  • ID: The object ID of the database connection, returned as a string.

  • IDLE_TIMEOUT: The timeout for the database connection when idle, returned as an integer.

  • MAX_CANCEL_ATTEMPT: The maximum number of cancellation attempts allowed, returned as an integer.

  • MAX_CONNECTION_ATTEMPT: The maximum number of connection attempts allowed, returned as an integer.

  • MAX_QUERY_EXEC: The maximum number of queries allowed, returned as an integer.

  • NAME: The name of the database connection, returned as a string.

  • ODBCDSN: The data source name used by the database connection, returned as a string.

  • TABLE_PREFIX: The table prefix used by the database connection, returned as a string.

  • TIMEOUT: The timeout for the database connection, returned as an integer.

  • USE_EXTENDED_FETCH: Whether or not the database connection uses extended fetch, returned as a boolean value.

  • USE_PARAM_QUERIES: Whether or not the database connection can use parameter queries, returned as a boolean value.

LIST PROPERTIES FOR DBCONNECTION (Microsoft Analysis Service)

  • DB_CONNECTION_CATALOG: The database connection catalog, returned as a string.

  • DB_CONNECTION_DSI: The database connection DSI, returned as a string.

  • DB_CONNECTION_URL: The database connection URL, returned as a string.

  • DEFAULT_LOGIN: The default login name for the database connection, returned as a string.

  • DRIVER_MODE: The mode of the driver for the database connection, such as "MultiProcess". Returned as a string.

  • ID: The object ID of the database connection, returned as a string.

  • IDLE_TIMEOUT: The timeout for the database connection when idle, returned as an integer.

  • MAX_CANCEL_ATTEMPT: Maximum number of cancellation attempts allowed, returned as an integer.

  • MAX_CONNECTION_ATTEMPT: Maximum number of connection attempts allowed, returned as an integer.

  • MAX_QUERY_EXEC: The maximum number of queries allowed, returned as an integer.

  • NAME: The name of the database connection, returned as a string.

  • TIMEOUT: The timeout for the database connection, returned as an integer.