Data Mover Commands Compared to SQL Commands

The following table shows the relationship between SQL and PeopleSoft Data Mover commands. DDL refers to data definition commands, which define the structure of a database. DML refers to data manipulation commands which define the contents of a database.

Function	Command Type	Supported SQL Commands	Data Mover Commands
Create tables, tablespaces, and indexes.	DDL	CREATE	IMPORT REPLACE_ALL
Create views.	DDL	CREATE	REPLACE_VIEW
Drop tables.	DDL	DROP	REPLACE_ALL
Modify tables.	DDL	ALTER	None
Modify PeopleSoft records.	DDL	None	RENAME
Delete all rows.	DDL	TRUNCATE	None
Insert rows.	DML	INSERT STORE	IMPORT REPLACE_ALL REPLACE_DATA
Delete rows.	DML	DELETE ERASE	REPLACE_DATA
Update rows.	DML	UPDATE	None
Encrypt rows.	DML	None	ENCRYPT_PASSWORD
Select rows.	Query	None	EXPORT
Save or don't save changes.	Transaction	COMMIT ROLLBACK	SET (when used with COMMIT or NO COMMIT)
Control or run other PeopleSoft Data Mover commands.	Environment	None	SET RUN
Denote an explanatory statement.	Comment	None	REM REMARK --