Here is what I have that is causing the error........
CREATE MULTISET TABLE DLAB_MARKETING.Click,
NO FALLBACK,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT,
DEFAULT MERGEBLOCKRATIO
(
AccountID INTEGER,
OYBAccountID INTEGER,
JobID INTEGER,
ListID INTEGER,
BatchID INTEGER,
SubscriberID INTEGER,
SubscriberKey VARCHAR(100),
EventDate DATE,
URL VARCHAR(900),
LinkName VARCHAR(1024),
LinkContent VARCHAR(1000),
TriggeredSendDefinitionObjectID VARCHAR(36),
TriggeredSendCustomerKey VARCHAR(36)
)
PRIMARY INDEX (AccountID);
Hi realrx7,
Te problem is with the column name TriggeredSendDefinitionObjectID , this has more than 30 characters.
3737 - Name is longer than 30 characters.
Regards.
Thanks!!
Here is what I have that is causing the error........
CREATE MULTISET TABLE DLAB_MARKETING.Click,
NO FALLBACK,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT,
DEFAULT MERGEBLOCKRATIO
(
AccountID INTEGER,
OYBAccountID INTEGER,
JobID INTEGER,
ListID INTEGER,
BatchID INTEGER,
SubscriberID INTEGER,
SubscriberKey VARCHAR(100),
EventDate DATE,
URL VARCHAR(900),
LinkName VARCHAR(1024),
LinkContent VARCHAR(1000),
TriggeredSendDefinitionObjectID VARCHAR(36),
TriggeredSendCustomerKey VARCHAR(36)
)
PRIMARY INDEX (AccountID);