PeopleSoft HRMS System Configuration Insight (PSFTHRMSSCI)

To exclude tables in script-based extraction:

  1. Edit the ExtractPSFTHRSCI_DB2.cmd file.
  2. Comment the object's select query for which you don’t want to extract in the ExtractPSFTHRSCI_DB2.cmd file. Rewrite the query as shown bellow. Please refer the example given below.

    For example: 

    db2 export to "%2\PSACCESSPRFL.txt "of modified by nochardel "SELECT
'' FROM SYSIBM.SYSDUMMY1"
REM db2 export to "%2\PSACCESSPRFL.txt "of DEL modified by nochardel "SELECT 
''||'$$$$!@**'||'@B$R@C!I#D#'||'$$$$!@**'||TRIM(CHAR(SYMBOLICID))||'$$$$!@**'
||TRIM (CHAR(VERSION))||'$$$$!@**'||TRIM(CHAR(ACCESSID))||'$$$$!@**'
||TRIM(CHAR(ACCESSPSWD))||'$$$$!@**'||TRIM(CHAR (ENCRYPTED))||'$$$$!@**###' 
FROM PSACCESSPRFL"