Home
Macros for HCL Unica
Macros can be used in Unica Campaign and Unica Interact to enhance your flowcharts.
Macros Reference
This section describes each available macro that is available for use in Campaign, Interact, or both. Macros are listed in alphabetical order.
Valid Format Keywords
The following table shows the keywords for valid formats, with a description and example of each.

Macros for HCL Unica
Macros can be used in Unica Campaign and Unica Interact to enhance your flowcharts.
- Using Macros in Unica Campaign
  This chapter provides usage information about Unica Campaign macros. Be sure to read this chapter before you attempt to use macros in Unica Campaign.
- Using macros in Unica Interact
  This chapter provides usage information about Unica Interact macros. Be sure to read this chapter before you attempt to use macros in Unica Interact.
- Macros Reference
  This section describes each available macro that is available for use in Campaign, Interact, or both. Macros are listed in alphabetical order.
  - Valid Format Keywords
    The following table shows the keywords for valid formats, with a description and example of each.
  - ABS macro
    The ABS macro is available only in Unica Campaign.
  - ACOS macro
    The ACOS macro is available only in Unica Campaign.
  - ACOT macro
    The ACOT macro is available only in Unica Campaign.
  - ADD_MONTHS macro
    The ADD_MONTHS macro is available in Unica Campaign. For ORACLE, DB2 and MSSQLServer databases execution is preferred on the database instead of Campaign Server.
  - AND macro
    The AND macro is available in Unica Campaign and Unica Interact.
  - ASIN macro
    The ASIN macro is available only in Unica Campaign.
  - ATAN macro
    The ATAN macro is available only in Unica Campaign.
  - AVG macro
    The AVG macro is available in Unica Campaign and Unica Interact.
  - BETWEEN macro
    The BETWEEN macro is available only in Unica Campaign.
  - BIT_AND
    The BIT_AND macro is available in Unica Campaign and Unica Interact.
  - BIT_NOT
    The BIT_NOT macro is available in Unica Campaign and Unica Interact.
  - BIT_OR
    The BIT_OR macro is available in Unica Campaign and Unica Interact.
  - BIT_XOR
    The BIT_XOR macro is available in Unica Campaign and Unica Interact.
  - CEILING macro
    The CEILING macro is available only in Unica Campaign.
  - COLUMN macro
    The COLUMN macro is available only in Unica Campaign.
  - COS macro
    The COS macro is available only in Unica Campaign.
  - COSH macro
    The COSH macro is available only in Unica Campaign.
  - COT macro
    The COT macro is available only in Unica Campaign.
  - COUNT macro
    The COUNT macro is available only in Unica Campaign.
  - CURRENT_DATE macro
    The CURRENT_DATE macro is available in Unica Campaign and Unica Interact.
  - CURRENT_DAY macro
    The CURRENT_DAY macro is available in Unica Campaign and Unica Interact.
  - CURRENT_JULIAN macro
    The CURRENT_JULIAN macro is available only in Unica Campaign.
  - CURRENT_MONTH macro
    The CURRENT_MONTH macro is available in Unica Campaign and Unica Interact.
  - CURRENT_TIME macro
    The CURRENT_TIME macro is available only in Unica Campaign.
  - CURRENT_WEEKDAY macro
    The CURRENT_WEEKDAY macro is available in Unica Campaign and Unica Interact.
  - CURRENT_YEAR macro
    The CURRENT_YEAR macro is available in Unica Campaign and Unica Interact.
  - DATE
  - DATE_FORMAT macro
    The DATE_FORMAT macro is available in Unica Campaign and Unica Interact.
  - DATE_JULIAN macro
    The DATE_JULIAN macro is available only in Unica Campaign.
  - DATE_STRING macro
    The DATE_STRING macro is available only in Unica Campaign.
  - DAY_BETWEEN macro
    The DAY_BETWEEN macro is available only in Unica Campaign.
  - DAY_FROMNOW macro
    The DAY_FROMNOW macro is available only in Unica Campaign.
  - DAY_INTERVAL macro
    The DAY_INTERVAL macro is available only in Unica Campaign.
  - DAYOF macro
    The DAYOF macro is available only in Unica Campaign.
  - DISTANCE
    The DISTANCE macro is available in Unica Campaign and Unica Interact.
  - DIV macro
    The DIV macro is available in Unica Campaign and Unica Interact.
  - EQ macro
    The EQ macro is available in Unica Campaign and Unica Interact.
  - EXP macro
    The EXP macro is available only in Unica Campaign.
  - EXTERNALCALLOUT macro
    The EXTERNALCALLOUT macro is available only in Unica Interact.
  - FACTORIAL macro
    The FACTORIAL macro is available only in Unica Campaign.
  - FLOOR macro
    The FLOOR macro is available only in Unica Campaign.
  - FORMAT macro
    The FORMAT macro is available in both Unica Campaign and Unica Interact (from version 12.1.1).
  - FRACTION macro
    The FRACTION macro is available only in Unica Campaign.
  - GE macro
    The GE macro is available in Unica Campaign and Unica Interact.
  - GET macro
    The GET macro is available in Unica Interact.
  - GROUPBY macro
    The GROUPBY macro is available only in Unica Campaign.
  - GROUPBY_WHERE macro
    The GROUPBY_WHERE macro is available only in Unica Campaign.
  - GT macro
    The GT macro is available in Unica Campaign and Unica Interact.
  - IF macro
    The IF macro is available in Unica Campaign and Unica Interact.
  - IN macro
    The IN macro is available in Unica Campaign and Unica Interact.
  - INCLUDE macro
    The [NOT] INCLUDE macro is available in Unica Interact.
  - INT macro
    The INT macro is available only in Unica Campaign.
  - INVERSE macro
    The INVERSE macro is available only in Unica Campaign.
  - IS macro
    The IS macro is available in Unica Campaign and Unica Interact.
  - ISERROR macro
    The ISERROR macro is available only in Unica Campaign.
  - ISODD macro
    The ISODD macro is available only in Unica Campaign.
  - ISEVEN macro
    The ISEVEN macro is available only in Unica Campaign.
  - ISODD macro
    The ISODD macro is available only in Unica Campaign.
  - LE macro
    The LE macro is available in Unica Campaign and Unica Interact.
  - LIKE macro
    The LIKE macro is available in Unica Campaign and Unica Interact.
  - LN or LOG macro
    The LN or LOG macro is available only in Unica Campaign.
  - LOG2 macro
    The LOG2 macro is available only in Unica Campaign.
  - LOG10 macro
    The LOG10 macro is available only in Unica Campaign.
  - LOWER macro
    The LOWER macro is available in Unica Campaign and Unica Interact.
  - LT macro
    The LT macro is available in Unica Campaign and Unica Interact.
  - LTRIM macro
    The LTRIM macro is available in Unica Campaign and Unica Interact.
  - MAX macro
    The MAX macro is available in Unica Campaign and Unica Interact.
  - MEAN macro
    The MEAN macro is available in Unica Campaign and Unica Interact.
  - MIN macro
    The MIN macro is available in Unica Campaign and Unica Interact.
  - MINUS
    The MINUS macro is available in Unica Campaign and Unica Interact.
  - MOD macro
    The MOD macro is available in Unica Campaign and Unica Interact.
  - MONTHOF macro
    The MONTHOF macro is available only in Unica Campaign.
  - MULT macro
    The MULT macro is available in Unica Campaign and Unica Interact.
  - NE macro
    The NE macro is available in Unica Campaign and Unica Interact.
  - NOT macro
    The NOT macro is available in Unica Campaign and Unica Interact.
  - NUMBER macro
    The NUMBER macro is available in Unica Campaign and Unica Interact.
  - OR
    The OR macro is available in Unica Campaign and Unica Interact.
  - POSITION macro
    The POSITION macro is available only in Unica Campaign.
  - PLUS macro
    The PLUS macro is available in Unica Campaign and Unica Interact.
  - POW
    The POWER macro is available in Unica Campaign and Unica Interact.
  - RANDOM macro
    The RANDOM macro is available only in Unica Campaign.
  - RANDOM_GAUSS macro
    The RANDOM_GAUSS macro is available only in Unica Campaign.
  - ROUND macro
    The ROUND macro is available only in Unica Campaign.
  - ROWNUM macro
    The ROWNUM macro is available only in Unica Campaign.
  - RTRIM macro
    The RTRIM macro is available in Unica Campaign and Unica Interact.
  - SIGN macro
    The SIGN macro is available only in Unica Campaign.
  - SIN macro
    The SIN macro is available only in Unica Campaign.
  - SINH macro
    The SINH macro is available only in Unica Campaign.
  - COUNT_DIM macro
    The COUNT_DIM macro is available in Unica Interact.
  - SORT macro
    The SORT macro is available in Unica Interact.
  - SQRT macro
    The SQRT macro is available only in Unica Campaign.
  - STDV or STDEV macro
    The STDV or STDEV macro is available in Unica Campaign and Unica Interact.
  - STRING_CONCAT macro
    The STRING_CONCAT macro is available in Unica Campaign and Unica Interact.
  - STRING_HEAD macro
    The STRING_HEAD macro is available only in Unica Campaign.
  - STRING_LENGTH macro
    The STRING_LENGTH macro is available only in Unica Campaign.
  - STRING_PROPER macro
    The STRING_PROPER macro is available only in Unica Campaign.
  - STRING_SEG macro
    The STRING_SEG macro is available only in Unica Campaign.
  - STRING_TAIL macro
    The STRING_TAIL macro is available only in Unica Campaign.
  - SUBSTR or SUBSTRING macro
    The SUBSTR or SUBSTRING macro is available in Unica Campaign and Unica Interact.
  - SUM macro
    The SUM macro is available in Unica Campaign and Unica Interact.
  - TAN macro
    The TAN macro is available only in Unica Campaign.
  - TANH macro
    The TANH macro is available only in Unica Campaign.
  - TOTAL macro
    The TOTAL macro is available in Unica Campaign and Unica Interact.
  - TRUNCATE macro
    The TRUNCATE macro is available only in Unica Campaign.
  - UPPER macro
    The UPPER macro is available in Unica Campaign and Unica Interact.
  - VARIANCE macro
    The VARIANCE macro is available only in Unica Campaign.
  - WEEKDAY macro
    The WEEKDAY macro is available only in Unica Campaign.
  - WEEKDAYOF macro
    The WEEKDAYOF macro is available only in Unica Campaign.
  - XOR
    The XOR macro is available in Unica Campaign and Unica Interact.
  - YEAROF macro
    The YEAROF macro is available only in Unica Campaign.

Valid Date Format Keywords

The following table shows the keywords for valid formats, with a description and example of each.


Keyword	Description	Example(s)
`MM`	2-digit month	01, 02, 03, ..., 12
`MMDD`	2-digit month and 2-digit day	March 31 is 0331
`MMDDYY`	2-digit month, 2-digit day, and 2-digit year	March 31, 1970 is 033170
`MMDDYYYY`	2-digit month, 2-digit day, and 4-digit year	March 31, 1970 is 03311970
`DELIM_M_D`	Any delimited month followed by day	March 31, 3/31, or 03-31
`DELIM_M_D_Y`	Any delimited month, day, and year	March 31, 1970 or 3/31/70
`DELIM_M_D_YYYY`	Any delimited month, day, and 4-digit year	March 31, 1970 or 3/31/1970
`DELIM_Y_M`	Any delimited year followed by month	March, 70; 3-70; or 3/1970
`DELIM_Y_M_D`	Any delimited year, month, and day	1970 Mar 31 or 70/3/31
`YYMMM`	2-digit year and 3-letter month	70MAR
`YYMMMDD`	2-digit year, 3-letter month, and 2-digit day	70MAR31
`YY`	2-digit year	70
`YYMM`	2-digit year and 2-digit month	7003
`YYMMDD`	2-digit year, 2-digit month, and 2-digit day	700331
`YYYYMMM`	4-digit year and 3-letter month	1970MAR
`YYYYMMMDD`	4-digit year, 3-letter month, and 2-digit day	1970MAR31
`YYYY`	4-digit year	1970
`YYYYMM`	4-digit year and 2-digit month	197003
`YYYYMMDD`	4-digit year, 2-digit month, and 2-digit day	19700331
`DELIM_M_Y`	Any delimited month followed by year	3-70, 3/70, Mar 70, March 1970
`DELIM_D_M`	Any delimited day followed by month	31-3, 31/3, 31 March
`DELIM_D_M_Y`	Any delimited day, month, and year	31-MAR-70, 31/3/1970, 31 03 70
`DD`	2-digit day	31
`DDMMM`	2-digit day and 3-letter month	31MAR
`DDMMMYY`	2-digit day, 3-letter month, and 2-digit year	31MAR70
`DDMMMYYYY`	2-digit day, 3-letter month, and 4-digit year	31MAR1970
`DDMM`	2-digit day and 2-digit month	3103
`DDMMYY`	2-digit day, 2-digit month, and 2-digit year	310370
`DDMMYYYY`	2-digit day, 2-digit month, and 4-digit year	31031970
`MMYY`	2-digit month and 2-digit year	0370
`MMYYYY`	2-digit month and 4-digit year	031970
`MMM`	3-letter month	MAR
`MMMDD`	3-letter month and 2-digit day	MAR31
`MMMDDYY`	3-letter month, 2-digit day, and 2-digit year	MAR3170
`MMMDDYYYY`	3-letter month, 2-digit day, and 4-digit year	MAR311970
`MMMYY`	3-letter month and 2-digit year	MAR70
`MMMYYYY`	3-letter month and 4-digit year	MAR1970
`MONTH`	Month of the year	January, February, March, and so on or Jan, Feb, Mar, and so on
`WEEKDAY`	Day of the week	Sunday, Monday, Tuesday, and so on (Sunday = 0)
`WKD`	Abbreviated day of the week	Sun, Mon, Tues, and so on (Sun = 0)

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.