CustomizePrdid

The CustomizePrdid parameter customizes the behavior of a DB2 for z/OS host that is using a double-byte character set (DBCS). DB2 for z/OS does not support the ESCAPE clause in SQL syntax when the LIKE argument uses a mixed-byte character set.

When the CustomizePrdid parameter is set to Mixed, StarSQL will strip the backslash escape character (\) from both the catalog SQL that is used to bind catalog packages and from dynamic catalog SQL calls. You must enable the CustomizePrdid parameter prior to binding packages, and it must be enabled in the DSN that is used to connect to the host from the StarSQL client.

The escape character precedes a special character, such as the underscore (_) character, to treat the character as a literal. To work with tables that include an underscore in the name, such as MY_TABLE, create an ALIAS, SYNONYM, or VIEW for the table with a name that includes no special characters instead of working directly with the table.