Running Scripts

Through PeopleSoft Data Mover, you can run DDL, DML, and SQL scripts created with the following tools:

  • PeopleSoft Data Mover (DMS scripts).

  • Build SQL functionality in Application Designer (SQL scripts).

  • Platform-specific SQL utilities (SQL scripts).

Note:

You can also schedule PeopleSoft Data Mover scripts using PeopleSoft Process Scheduler. This can be useful in scheduling audit routines or extracting data from the PeopleSoft database. Additionally, logs and data files generated by PeopleSoft Data Mover can be posted to the report repository in PeopleSoft Process Scheduler so that they can be viewed either through Process Monitor or Report Manager.

Note:

DMS scripts which contain characters outside of the US ASCII range should be saved in UTF-8 encoding.

When running scripts through PeopleSoft Data Mover, keep the following items in mind:

  • Turn off the SQL Trace utility to run PeopleSoft Data Mover scripts.

    If SQL Trace is enabled, disable it on the Trace tab in PeopleSoft Configuration Manager before you run the script. You can also enter the SET NO TRACE statement within scripts. This disables SQL Trace for the DMS script even if it is enabled in PeopleSoft Configuration Manager.

  • Records defined using the PeopleSoft Data Mover EXPORT and IMPORT commands can have a maximum of 500 columns, and they can have multiple long columns within the limitations for long columns set by the database platform.

    Check with the database vendor for restrictions on the number of long columns allowed for the platform.

  • On DB2 UDB platforms, locks can occur on system catalogs.

    Do not run unattended PeopleSoft Data Mover sessions. Close the session as soon as all scripts terminate.

  • To run a SQL script, you must open it by selecting File, Open so that the SQL runs properly.

    Do not copy and paste SQL from another source into PeopleSoft Data Mover.

    Note:

    If you plan to import or export files greater than 2 gigabytes (GB) on UNIX, you must enable large file support at the operating system level.

To run a script:

  1. Select File, Open.

  2. Select one of the following types of script to run.

    • PeopleSoft Data Mover files (.DMS).

      These are the files created using PeopleSoft Data Mover.

    • Query files (.SQL).

      These are the files created using the Build SQL functionality in Application Designer or using a query tool specific to a relational database management system (RDBMS), such as PL/SQL on Oracle.

    • All files.

      Select to view all available files in a directory. Only .DMS and .SQL files are valid file types for PeopleSoft Data Mover.

      Note:

      SELECT commands are not supported. When performing upgrades, use the SQL utility for the platforms to run .SQL scripts, not PeopleSoft Data Mover.

  3. Select File, Run.

    You can monitor the script's progress in the output pane, which reveals any error messages and displays the message Script Completed when processing has ended.