MicroStrategy ONE

List Connection Maps statement

Lists the existing connection maps in a project.

Copy 
LIST [ALL] 
 CONNECTION MAP FOR PROJECT "project_name";

where:

  • PROJECT "project_name" is the name of the project for which connection maps are to be listed, of type string.

Example

Copy 
LIST ALL CONNECTION MAP FOR PROJECT "3-Tier 
 Project";

ResultSet Columns

CONNECTION_MAP: The identifier for the connection map, returned as an integer.

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

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

DB_LOGIN: The name of the database login, returned as a string.

LANGUAGE: The language associated with the connection map, returned as a string.

USER: The name of the user associated with the connection map, returned as a string.