How to interpret the DBINFO entry in the data dictionary file

Problem or error: What does the DBINFO entry in the data dictionary (.dct file) mean?

Solution: The DBINFO entry stores field definition information from the database. When creating a new table in the same database, Campaign uses the DBINFO values to create the table with the correct field definitions.

The DBINFO definition is:

(Source type / native type / data type / precision / scale)

*

Here is a sample .dct file.

CUSTID, ASCII string, 25, 0, DBINFO(1/1/17/-2147483647/-2147483647),
RELATIONSHIP, ASCII string, 25, 0, DBINFO(1/1/17/-2147483647/-2147483647),
RELID, ASCII string, 25, 0, DBINFO(1/1/17/-2147483647/-2147483647),
KEYDATE, ASCII string, 25, 0, DBINFO(1/1/17/-2147483647/-2147483647),
OCCASION, ASCII string, 25, 0, DBINFO(1/1/17/-2147483647/-2147483647),
PREVPURCHASE, ASCII string, 25, 0, DBINFO(1/1/17/-2147483647/-2147483647),
PURCHAMT, ASCII Numeric, 15/22, 0, DBINFO(1/2/12/126/-2147483647),


IBM Unica Campaign
 
8.5.0
For more information, see our support and community site: Customer Central