Running the scripts using TOAD Through SQL*PLUS

Provide the source path and the destination path and execute script from Editor > Execute as Script.

Enter user name and password, for example, SYSADM@FINC and Infor1, and ensure that the destination folder is created.

• For example to run PSFT FI script using TOAD via SQL*PLUS @'C:\PSFTAI\ExtractPSFTFISCMAI.SQL' 'C:\PSFTFISQLPLUS' 'ENG' 'ENG' 'SYSADM' 'FINC' 'ENGLISH' 'ENGLISH'
  Note: C:\PSFTAI\ExtractPSFTFISCMAI.SQL is the location of SQL script and C:\PSFTFISQLPLUS is the location for extracted data.
• For example to run PSFT HR script using TOAD via SQL*PLUS

  @'C:\PSFTAI\ExtractPSFTHRMSAI.SQL' 'C:\PSFTHRSQLPLUS' 'ENG' 'ENG' 'SYSADM' 'PSHCM' 'ENGLISH' 'ENGLISH'

  Note:  C:\PSFTAI\ExtractPSFTHRMSAI.SQL is the location of SQL script and C:\PSFTHRSQLPLUS is the location for extracted data.

A command prompt window displays the status of the script.