PowerExchange for SAS User Guide for PowerCenter

10.5.1
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5
- 10.4.0

Back Next

Session and User Identification

The following are the PowerCenter session properties passed to the environment where SAS runs:

Name of the PowerCenter Integration Service that runs the corresponding workflow.

Name of the PowerCenter connection used to access the SAS machine.

Name of the SPI Server user who accesses the SAS environment.

You can use the values of these properties for conditional initialization logic in the SAS autoexec script.

The following system variables provide PowerCenter session property information to the SAS process:

Property	Available	Description
TBPC_PMSERVER_NAME	server	Name of the active PowerCenter Integration Service.
TBPC_CONNECTION_NAME	server	Name of the PowerCenter Integration Service connection.
TBPC_USER_NAME	client/server	Name of the connected PowerCenter user.
TB_SPI_USERNAME	client/server	Name of the SPI server user.

You can use the

sysget( )

SAS function to retrieve system variables.

For example:

/* Store system variables into SAS macro variables: */ 
srvname = sysget("TBPC_PMSERVER_NAME"); 
conname = sysget("TBPC_CONNECTION_NAME"
);
/* Use the SAS macro variables to code logic: */ 
............. 
............. 
/* End of logic */

When the PowerCenter Designer initiates a connection to the SAS machine, the system variables that are unavailable for client connections contains no meaningful information. The system variable values default to

Rename Saved Search

Table of Contents

PowerExchange for SAS User Guide for PowerCenter

PowerExchange for SAS User Guide for PowerCenter

Session and User Identification

Session and User Identification