Table of Contents

Search

  1. Preface
  2. Understanding the Repository
  3. Using the Repository Manager
  4. Folders
  5. Managing Object Permissions
  6. Local and Global Shortcuts
  7. Team-Based Development with Versioned Objects
  8. Labels
  9. Object Queries
  10. Team-Based Development with Deployment Groups
  11. Copying Folders and Deployment Groups
  12. Exporting and Importing Objects
  13. Exchanging Metadata
  14. Copying Objects
  15. Metadata Extensions
  16. Appendix A: MX Views Reference
  17. Appendix B: PowerCenter Reports Reference

Repository Guide

Repository Guide

REP_SESSION_CNXS

REP_SESSION_CNXS

This view contains information about connections associated with reusable sessions.
The following table lists reusable session connection information in the REP_SESSION_CNXS view:
Column Name
Datatype
Description
SUBJECT_AREA*
VARCHAR2 (240)
Folder name in which the session is stored.
SUBJECT_ID*
NUMBER
Folder ID.
SESSION_NAME*
VARCHAR2 (240)
Name of the session.
SESSION_ID*
NUMBER
Session ID.
IS_TARGET
INTEGER
Specifies whether the connection is the target or the source.
0 = source connection; 1 = target connection; 22 = multi-group external procedure template extension; 25 = flat file lookup extension.
CONNECTION_NAME
VARCHAR2 (240)
Name of the connection.
CONNECTION_ID*
INTEGER
Connection ID.
SESSION_VERSION_NUMBER*
NUMBER
Version number of the session.
*Indicates that the column is a key column.

0 COMMENTS

We’d like to hear from you!