CA TPX Batch - example - How to find where the session Label (Session Description) has been overridden with blanks at the profile or user level?

Document ID : KB000011256
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

Trying to find situations where the application exists in the ACT (Application Characteristics Table) but user has overridden the Label at the profile level with blanks. The user may or may not have also provided a Label override.

Question:

How to find where the session Label (Session Description) has been overridden with blanks at the profile or user level?

Environment:
TPX 5.4
Answer:

For USER fields, check on a value of ' ' (a single blank within quotes)

For PROFILE variables, check for a value of ________ (eight underscore characters)

From the TPX Batch Administration Guide:

Specifying Variables Without Assigned Values

Profile Variables

You can also specify a blank value in order to specify profile variables that have not been assigned a value. To do this, always 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

You can specify a blank value in order to specify user variables that have not been assigned a value. To do this, always specify a single space (' '), regardless of the length of the variable. Using a variable with a blank value as extraction criteria will only select user records if the variable has not been assigned a value at the system, application, profile, or user level.

 

So to check for blank Label fields, run two reports; one against USER session data and another against PROFILE session data. For example:

//BATCHADM EXEC TPX,VNODE='*BATCH*' 
//EXTFILE  DD UNIT=SYSDA,SPACE=(CYL,(1,1)),DISP=(MOD)    
//RPTFILE  DD SYSOUT=*
//EXTFIL2  DD UNIT=SYSDA,SPACE=(CYL,(1,1)),DISP=(MOD)                   
//RPTFIL2  DD SYSOUT=*   
//SYSIN DD *                                                            
C                                                                       
C                                                                       
C
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                              ' ))

NOTE: The above example can also be found in the attached zip file.

Additional Information:

TPX 5.4 Batch Administration - Extracting Data - Specify Variables Without Assigned Values

File Attachments:
TEC476509.zip