Technical Tip: RC/Migrator : Setting the SQL TERMINATOR Character

[Lucio Basiaco]

Being able to set the SQL Terminator Character for an Analysis was brought in during the R17 Release and placed in the Strategy Analysis Options allowing the user to change the SQL termination character when the default ';' termination character conflicts with the SQL statements used in triggers, indexes and routines.

 

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

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

Solution APAR to look up : R19 : RO79424

The online help on the screen fields has good information to read about also.

[Andrew Badgley]

Thanks for the great tip Lucio.

 

I'd like to add that with our 19.0 release CA RC/Migrator and CA RC/Compare can Import DDL for a Compare strategy that contains --#SET TERMINATOR statements and DDL terminated with the non-';' termination character.  Also CA RC/Migrator Syntax Checker recognizes --#SET TERMINATOR statements and validates DDL terminated with the non-';' termination character.

[Lucio Basiaco]

Hi Andy, thanks for that additional info. I have created a knowledgebase document about this also to show how it is actually used. ( TEC1185532 ). A nice touch I saw was on the Update Options screen and the Analysis Profile where the Terminator Character is entered it has a "(blank defaults to ';')" and I noticed that the character in there changes to reflect what the default is set to so if you have SETTERM ($) in the MIGRATOR member then you see (blank defaults to '$') on update options or analysis profile screen. Saves you actually having to find out what the default is set to via browsing the MIGRATOR member. Cheers, Lucio