Database considerations for attribute database columns

Be careful when setting the Attribute Database Column Name value for an attribute. Your database has a set of reserved words, and using any of them for attribute names can cause errors when Unica Plan writes to the database.

Each database management system has a different set of reserved words. It is not feasible to list them all here, as they can change. The following is a short list to illustrate the issue; for an exhaustive list, refer to your database documentation.

DBMS

Some reserved words

MS SQL

Boolean, Browse, File, Group, Plan, Primary

Oracle

Cluster, Group, Immediate, Session, User

DB2®

Blob, Column, Group, Rollback, Values

If you are using an Oracle database, there is a 30-character limit for the Attribute Database Column Name value. For all other databases, the limit is 32 characters.

If you are integrating Unica Plan and Unica Campaign, avoid CLOB fields, as Unica Campaign does not support them.

If you are using a Microsoft SQL Server database, note that the Identity option for the primary key field is not supported.