Set SQL Terminator Character

Document ID : KB000030427
Last Modified Date : 14/02/2018
Show Technical Document Details

The R17 release of RC/Migrator provided an additional UPDATE OPTION to set the SQL Terminator Character for generated Analysis SQL.

SET TERMINATOR    ==>       (blank defaults to ';')

The character displayed above between the braces reflects the current global default character.

In the R19 release a new hlq.cdbaparm(MIGRATOR) or (RCMIGxx) global parm has been added to make it a global default. This is the SETTERM parm.

The parm is added in the top section of the hlq.cdbaparm(MIGRATOR) or (RCMIGxx) member so it covers all SSID's listed in the member.

E.g.

SETTERM ($)

A SET TERMINATOR field has also been added to the RCM Analysis Profile so that this value can be saved for later use.

- Control Options:
.
.
.
    SET TERMINATOR          ===>   @        (blank defaults to '$')

If the hlq.cdbaparm(MIGRATOR) or (RCMIGxx) SETTERM is used it is the global default.

This can be overridden by the use of the SET TERMINATOR in Update options or the SET TERMINATOR if using an Analysis profile.