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 IBM® Marketing Operations 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 IBM® Marketing Operations and IBM® Campaign, avoid CLOB fields, as 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.