MicroStrategy ONE

List Database Connection Properties statement

Lists properties for a database connection to an Intelligence Server.

Copy 
LIST [ALL] 
 PROPERTIES FOR DATABASE CONNECTIONconnection_id;

where:

  • DATABASE CONNECTION connection_id is the ID of the database connection for which properties are to be listed, of type integer.

This statement can only be used with three-tier or four-tier project source names.

Example

Copy 
LIST PROPERTIES 
 FOR DATABASE CONNECTION 1;

ResultSet Columns

CONNECTION_ID: The ID of the database connection, returned as an integer.

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

DB_CONNECTION_STATUS: Status of the database connection, returned as an integer:

  • 0: Busy

  • 1: Cached

DB_INSTANCE_NAME: The name of the database instance associated with the database connection, returned as a string.

LOGIN: Login for the database connection, returned as a string.

USER_NAME: User name associated with the database connection, returned as a string.