Migrating COBOL DMS


There are two parts to migrating a COBOL DMS (data mover script):

  1. Migrate the data mover script to %PS_HOME%/src/cbl
  2. Run the data mover script in Data mover

Migrating the script ensures that the correct version of the file exists in your target environment. Running the data mover script updates the COBOL SQL statements table PS_SQLSTMT_TBL with the latest version of the data mover script.

It is the PS_SQLSTMT_TBL that stores the version of the SQL statements run by a COBOL process. It is good pratice to have the DMS script files in sync with the version in the SQL statements table to avoid confusion.

When comparing versions of SQL statements (e.g. for comparing patches) use the PS_SQLSTMT_TBL as your definitive source, as the version in %PS_HOME%/src/cbl/ may not be same!


Revision #2
Created Tue, Jul 23, 2019 10:55 PM by PeopleSoft Wiki
Updated Sun, Jul 28, 2019 11:21 PM by PeopleSoft Wiki