SQL termination character for SET TERMINATOR
Article ID: 251083
Updated On:
Products
Issue/Introduction
RC/Migrator for Db2 for z/OS (RCM) Analysis options to override the SQL termination character for #SET TERMINATOR statements.
Resolution
The Set Terminator analysis option allows a user to change the SQL termination character when the default ';' termination character conflicts with the SQL statements
used in triggers, indexes and routines.
Similarly, the SQL termination character can be overridden for Recovery Analysis by specifying the SET TERMINATOR value on the RC/M Strategy Recovery Options screen.
The SET TERMINATOR analysis and recovery analysis options will generate the SETTERM and RSETTERM parameters respectively in the PARMFILE DD.
For example:
//PARMFILE DD *
STRTSSID ssid
CREATOR userid
STRATEGY name
SETTERM #
...
RECOVERY
RCVRDSN dsname
RSETTERM #
...
If these analysis options are not specified, then we will use the value specified in the SETTERM and RSETTERM parameters in the MIGRATOR Parmlib member.
If no SETTERM or RSETTERM parameters are specified in the MIGRATOR Parmlib member, then we will use the default value ';'.
Feedback
