Skip to Main Content
Return to Navigation

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

Informix SQL Commands

SQL Scripts

UpdatePeopleTools

<process name>.sql

CONNECT TO …

DB2 UDB SQL Commands

SQL Scripts

UpdatePeopleTools

<process name>.sql

CONNECT TO …