Skip to content
CA TPX™ Session Management - 5.4
Documentation powered by DocOps

Specify Variables Without Assigned Values

Last update November 22, 2016

If you want to update or report records that have not been assigned a value, you can specify a blank value in the EXTRACT statement. 

Profile Variables

Some profile variables may not have assigned values. You can use a blank value to extract profile variables that have not been assigned a value. Specify a value of eight underscores, regardless of the length of the variable.

Note: This method can only be used to select profiles and profile sessions.

User Variables

Some user variables may not have assigned values. You can use a blank value to extract user variables that are not assigned a value. Specify a single space (' '), regardless of the length of the variable.

Note: A variable with a blank value as extraction criteria only selects user records if the variable has not been assigned a value at the system, application, profile, or user level.

Example: Check for User and Profile Variables Without Assigned Values

This example runs reports against user and profile session data to check for blank label fields:

EXTRACT GIVING(EXTFILE) USER AND MATCHING SESSIONS 
       (VSESLABL(' ')) 
SET RTITLE1 
' USER REPORT:' 
SET RTITLE2 
' USERID SessionID Label (VSESLABL)                      PROFILES' 
SET RTITLE3 
' ======== ========= =================================== ==========' 
REPORT GIVING(RPTFILE) USING(EXTFILE) 
(( ' &UIDXNAME' ' &UENTUSER' 
   ' &VSESLABL ' 
   ' &VUSR$PRF ' )) 
EXTRACT GIVING(EXTFIL2) PROFILE AND MATCHING SESSIONS 
       (WSESLABL(________)) 
SET RTITLE1 
' PROFILE REPORT:' 
SET RTITLE2 
' PROFILE SessionID Label (WSESLABL) ' 
SET RTITLE3 
' ======== ========= =================================== ' 
REPORT GIVING(RPTFIL2) USING(EXTFIL2) 
(( ' &PIDXNAME' ' &PENTUSER' 
   ' &WSESLABL                            ' ))

Was this helpful?

Please log in to post comments.