MACRO DEFAULT VALUE

Database

MACRO DEFAULT VALUE

While creating macro its giving error in default key field

CREATE MACRO DWH_DMG_ENT.M_ADMIN_SMARDT_PARAMETER
(
PARAMETER_GROUP VARCHAR(30) NOT NULL
,PARAMETER_VALUE VARCHAR(20) NOT NULL
,DWH_STATUS CHAR(2) DEFAULT 'AC'
,DWH_VALID_FROM DATE DEFAULT CURRENT_DATE+1 //why error here in default key

)

.

.
.
.

.
.
.
1 REPLY
Enthusiast

Re: MACRO DEFAULT VALUE

The syntax for the DEFAULT phrase does not allow arithmetic expressions.