Understanding Process, Scripts, and Syntax
Before Change Assistant runs SQL and Data Mover scripts, it determines whether the scripts need updating. This ensures that logs are sent to directories that are known to Change Assistant and that the scripts run properly.
The following table shows the processes, what scripts are updated, and the updated syntax.
|
Process |
Script Files |
Updated Syntax |
|---|---|---|
|
DataMoverBootstrap DataMoverUser LoadBaseData |
<process name>.dms |
SET LOG statements |
|
DB2 z/OS SQL Commands SQL Scripts UpdatePeopleTools |
<process name>.sql |
CONNECT TO … SET CURRENT SQLID = |
|
Oracle SQL Commands SQL Scripts UpdatePeopleTools |
<process name>.sql |
WHENEVER SQLERROR EXIT SET ECHO ON SET TIME ON SPOOL… SPOOL OFF EXIT |
|
DB2 UDB SQL Commands SQL Scripts UpdatePeopleTools |
<process name>.sql |
CONNECT TO … |