Macro Definitions and Server Character Sets - Advanced SQL Engine - Teradata Database

For example, if the creator user default server character set is Unicode, then the macro is expanded as shown in the immediately following example:

Original macro definition:

     CREATE MACRO mm AS (
       column_a CHARACTER(5))
       (SELECT :column_a;);

Expanded macro definition:

     CREATE MACRO mm AS (
       column_a CHARACTER(5) CHARACTER SET  UNICODE)
      (SELECT :column_a;);

For example, if the creator user default server character set is UNICODE, then the macro is qualified as shown in the immediately following example when it is performed.

Original macro definition:

     CREATE TABLE table_2 (
       ck CHARACTER(5) CHARACTER SET KANJI1);

     CREATE MACRO mm AS (
       SELECT ck (CHARACTER(6))
       FROM table_2;);

Qualified macro definition:

     SELECT ck (CHARACTER(6), CHARACTER SET KANJI1)
     FROM table_2;

When the following macro is performed, it is qualified as seen in the SELECT request that immediately follows it.

Original macro definition:

     CREATE MACRO mm AS (
       SELECT 123 (CHARACTER(12)););

Qualified macro definition:

     SELECT 123 (CHARACTER(6), CHARACTER SET  UNICODE);

For example, suppose the creator user default server character set is UNICODE. When the macro definition below is performed by a different user having a user default server character set of LATIN, then table_1 is created as shown in the immediately following example.

Original macro definition:

     CREATE MACRO tt AS (
       CREATE TABLE table_1
       (column_l CHARACTER(5)););

Expanded macro definition:

     CREATE TABLE table_1 (
       column_l CHARACTER(5) CHARACTER SET LATIN NOT CASESPECIFIC);

The same applies to a CREATE VIEW statement within a CREATE MACRO statement.