PeopleSoft DataMover — VS Code Extension
Syntax highlighting, hover documentation, and a purpose-built dark theme for PeopleSoft DataMover script files (.dms and .dmt).
Features
Syntax Highlighting
Full token-level highlighting for:
| Token |
Colour |
Commands (EXPORT, IMPORT, REPLACE_ALL, SET, …) |
Red / bold |
Control flow (IF, ELSE, END-IF, STOP, …) |
Red / bold |
SQL keywords (WHERE, AND, SELECT, FROM, …) |
Blue |
Data types (VARCHAR, NUMBER, DATE, …) |
Green |
Built-in functions (TO_CHAR, NVL, SUBSTR, …) |
Purple |
| PS_ record names |
Green / italic |
PeopleTools system records (PSRECDEFN, PSOPRDEFN, …) |
Bright green |
| Strings |
Light blue |
| Numbers |
Blue |
Comments (REM, /* */, //) |
Grey / italic |
| SET options |
Orange |
| Export/import parameters |
Yellow |
Code Snippets
Type a prefix and press Tab (or select from IntelliSense) to expand a snippet. All snippets use tab stops so you can jump between fields with Tab.
| Prefix |
Expands to |
header |
Full script header with metadata and log setup |
set-input |
SET INPUT path |
set-output |
SET OUTPUT path |
set-log |
SET LOG path |
set-io |
SET INPUT, OUTPUT, and LOG together |
export |
EXPORT record; |
export-where |
EXPORT record WHERE field = 'value'; |
import |
IMPORT record; |
replace-all |
REPLACE_ALL record; |
replace-data |
REPLACE_DATA record; |
replace-none |
REPLACE_NONE record; |
delete-rows |
DELETE_ROWS record; |
delete-rows-where |
DELETE_ROWS record WHERE …; |
if |
IF / END-IF block |
if-else |
IF / ELSE / END-IF block |
if-oracle |
Conditional block for Oracle only |
if-mssql |
Conditional block for SQL Server only |
if-db2 |
Conditional block for DB2 only |
export-db-specific |
Platform-specific export with nested IF/ELSE |
export-block |
Full export block: SET OUTPUT + EXPORT + STOP |
import-block |
Full import block: SET INPUT + REPLACE + STOP |
export-multi |
Export several records in one block |
migration-template |
Complete migration script scaffold |
export-tools |
Export core PeopleTools definition records |
export-security |
Export security records (operators, roles, permissions) |
export-ui |
Export menu and page definition records |
export-peoplecode |
Export PeopleCode program records |
encrypt-password |
ENCRYPT_PASSWORD |
rename |
RENAME RECORD old AS new; |
swap-language |
SWAP_BASE_LANGUAGE |
rem |
Single REM comment |
rem-section |
Section divider comment block |
block-comment |
/* … */ multi-line comment |
stop |
STOP; |
unicode-on / unicode-off |
Enable/disable Unicode mode |
ignore-dups |
SET IGNORE_DUPS; |
set-commit |
SET COMMIT_ENABLED/DISABLED; |
no-locking |
SET NO_RECORD_LOCKING; |
create-table-on |
SET CREATE_TABLE_ON; |
Hover Documentation
Hover over any DataMover command to see its description, syntax, and an example. Supported commands include:
EXPORT · IMPORT · REPLACE_ALL · REPLACE_DATA · REPLACE_NONE · SET · DELETE_ROWS · ENCRYPT_PASSWORD · RENAME · SWAP_BASE_LANGUAGE · IF / END-IF · STOP · REM
DataMover Dark Theme
An optional dark theme tuned for DataMover scripts, based on a GitHub-style dark palette. Enable it from the Command Palette: Preferences: Color Theme → DataMover Dark.
File Types
| Extension |
Description |
.dms |
DataMover Script — the primary script format |
.dmt |
DataMover Template — used for parameterised scripts |
Supported Commands
Data Operations
EXPORT / IMPORTREPLACE_ALL / REPLACE_DATA / REPLACE_NONEDELETE_ROWSRENAMECOPY_FROM_DB / COPY_INTO_DB
Environment / Configuration
SET INPUT / SET OUTPUT / SET LOGSET UNICODE_ENABLE / SET UNICODE_DISABLESET NO_RECORD_LOCKING / SET RECORD_LOCKINGSET IGNORE_DUPSSET COMMIT_ENABLED / SET COMMIT_DISABLEDSET CREATE_TABLE_ON / SET CREATE_TABLE_OFFENCRYPT_PASSWORDSWAP_BASE_LANGUAGE
Control Flow
IF / ELSE / END-IFSTOP / PAUSECALL / RETURN
REM / REMARK (line comment)/* … */ (block comment)// (line comment)
Contributing
Issues and pull requests welcome. Please open an issue for any DataMover commands that are missing.
Icons by Icons8
License
MIT
| |
