PeopleSoft FISCM System Configuration Insight (PSFTFISCMSYSCI)

To exclude the tables in script-based extraction:

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

    Example: 

    
db2 export to "%2\ PSAUTHITEM.txt "of modified by nochardel
 "SELECT '' FROM SYSIBM.SYSDUMMY1"
REM db2 export to "%2\PSAUTHITEM.txt" of DEL modified by nochardel"SELECT
''||'$$$$!@**'||'@B$R@C!I#D#'||'$$$$!@**'||TRIM(CHAR(CLASSID))||'$$$$!@**'||
(CHAR(MENUNAME))||'$$$$!@**'||TRIM(CHAR(BARNAME))||'$$$$!@**'||TRIM(CHAR
(BARITEMNAME))||'$$$$!@**'||TRIM(CHAR(PNLITEMNAME))||'$$$$!@**'||TRIM(CHAR
(DISPLAYONLY))||'$$$$!@**'||TRIM(CHAR(AUTHORIZEDACTIONS))||'$$$$!@**###'
FROM TRIMPSAUTHITEM"