<aside> <img src="/icons/info-alternate_orange.svg" alt="/icons/info-alternate_orange.svg" width="40px" /> Author: Andy Dorfman

</aside>

Prepare External Objects

Create DMS file

d:\\temp\\update_psstatus.dms

set log update_psstatus.log;
update PSSTATUS set LASTCHANGEDTTM = %CurrentDateTimeIn;

Application Designer portion

Create Custom File Code (PSTYPECODEDEFN) #

Application Designer > Tools > Miscellaneous Definitions > File Type Codes

FILEREFTYPECODE:    'CUSTOM_SCRIPTS'
FILEREFPATH:        '%ps_cust_home%\\scripts'
DESCRLONG:          'LBC PS_CUST_HOME\\scripts folder'`

Create Custom Script File Reference

• Application Designer > New > File Reference

  File Name and Path: "Click on ... to select a file `D:\\temp\\update_psstatus.dms`"
  Binary:             'No'
  Database Platform:  'All'
  PeopleSoft Server:  'File Server'
  Operating System:   'All'
  

• Application Designer > File > Save As

  Save Name As:   'UPDATE_PSSTATUS_DMS'
  File Type Code: 'CUSTOM_SCRIPTS'
  

• Click OK to save

• Replace D:\\temp\\update_psstatus.dms with %FILEREFPATH%\\update_psstatus.dms

• Click OK to save again

• Click F7 to import File Reference Definition into the project

• Application Designer > File > Save Project

  Save Project Name As: 'LBC_IT0001'
  

• Click OK to save

• Application Designer > Tools > Project Properties

  Description:    'Testing CUSTOM_SCRIPTS File References'
  Comments:       'Testing description'
  Change Project: 'Check'
  Update ID:      'LBC_IT0001'
  Add: 
  

• Click OK