Data Mover Script Commands

This section discusses the valid PeopleSoft Data Mover commands that you can include in PeopleSoft Data Mover scripts.

PeopleSoft Data Mover commands are platform-independent and are unique to PeopleSoft Data Mover. You can use PeopleSoft Data Mover commands for importing, exporting, and other tasks, such as controlling the run environment, renaming fields and records, administering database security, and denoting comments.

The following table describes the PeopleSoft Data Mover commands and the ways that you can indicate comments:

Command	Description
ENCRYPT_PASSWORD	Encrypt one or all user passwords (operator and access) defined in PSOPRDEFN for users.
EXPORT	Select record information and data from records and store the result set in a file. You can use the generated export file as input for migrating to another platform. This file is portable between ASCII and EBCDIC character sets, and also supports double-byte characters.
IMPORT	Insert data into tables using the information in an export file. If a tablespace or table does not exist, this command creates tablespace, table, and indexes for the record, using the information in the export file, and inserts the data.
REM, REMARK, and --	Indicate comment statements.
RENAME	Rename a PeopleSoft record, a field in one record, or a field in all records.
REPLACE_ALL	This is a variation of the IMPORT command. If a table already exists, use this command to drop the table and its indexes from the database. It then does the following: creates the table. creates any triggers. inserts the data. creates indexes.
REPLACE_DATA	This is a variation of the IMPORT command. Delete data in existing tables and insert the corresponding data from the export file.
REPLACE_VIEW	Recreate specified views found in the database.
RUN	Run a specified .DMS file from within a PeopleSoft Data Mover script. The file cannot contain nested RUN commands.
SET	When a command is followed by valid SET parameters, it forms a statement that establishes the conditions under which PeopleSoft Data Mover runs the PeopleSoft Data Mover and SQL commands that follow.
SET_IGNORE_IMPORT_ERRORS	(Optional) If this command is set, then all errors produced by IMPORT, REPLACE_DATA, and REPLACE_ALL will be ignored and processing will continue until the end of the data file or last import command. Any failed records will be shown in the Data Mover log if it is run from the Data Mover GUI or the import output if it is run from the command line.
SET IGNORE_ERRORS	(Optional) If this command is set, then all errors produced by the SWAP_BASE_LANGUAGE command are ignored. Otherwise, the system stops on errors.
SET IGNORE_SPLCHARS	(Optional), If this command is set with option ON, then special character, such as colon would not be used as bind variable. The carriage returns and spaces in a SQL string are not skipped and gets inserted into the database as it is written in the DMS script. Default value is OFF.
SET BASE_LANGUAGE	Swap individual language tables. You should swap individual tables only when there is an error with any of the tables after the SWAP_BASE_LANGUAGE command.
SWAP_BASE_LANGUAGE	Swap all the language tables from PSRECDEFN.