Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(1 Rating)
facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

FAQ: What is the PowerCenter Repository (pmrep) command to list relational connections?
Answer

The following two commands will fulfill this requirement:


pmrep executable command will be available in $INFA_HOME/server/bin directory.


1. pmrep ListConnections


Lists all connection objects in the repository and their respective connection types. A connection can be one of the following types:

  • Application
  • FTP
  • Loader
  • Queue
  • Relational

The ListConnections command uses the following syntax:

listconnections[-t (output includes connection subtype)]

 

-t is optional. Displays the connection subtype.

For example, for a Relational connection, connection subtypes include Oracle, Sybase, and Microsoft SQL Server. You can only view the subtype for connections that you have read permission on.


2. pmrep GetConnectionDetails


Lists the properties and attributes of a connection object as name-value pairs.

To use the GetConnectionDetails command, you need read permission on the connection object.

The GetConnectionDetails command uses the following syntax:

pmrep getconnectiondetails

-n <connection_name>

-t <connection_type>


The following table describes pmrep GetConnectionDetails options and arguments:


Option Argument Description
-n connection_name Required. Name of the connection to list details for.
-t connection_type Required. Type of connection

​​


More Information

Applies To
Product: PowerCenter
Problem Type: Product Feature
User Type: Administrator
Project Phase: Implement
Product Version: PowerCenter 10.2; PowerCenter 10.0; PowerCenter 10.1
Database:
Operating System:
Other Software:

Reference

Attachments

Last Modified Date:8/13/2020 10:06 PMID:17944
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)