Understanding the maximum sizes for specific Datacom data fields (columns)

Products

• Datacom
• Datacom/AD
• Datacom/DB
• Datacom/Server

Issue/Introduction

Designing a Datacom table is much easier when knowing if the desired fields (also called columns) have any specific size limits, based on the data type definition. This article explains where to find this information in the Datacom documentation.

Resolution

All of the information about field size limits and particular data types can be found in the Datacom documentation.

First, here is the link for the SQL Create Table statement. You can find "Data Types" about 2/3 down this webpage.

Next, there is a separate section specifically dealing with SQL Language Data Types. This contains information about the attributes used for each of the SQL data types.

Finally, a useful topic in the documentation is the Datacom Database Limits Quick Reference, which gives great information that is useful whether you are creating a Datacom database entity using the Datadictionary component or whether you are using SQL.

I expect that these will help you to answer your questions. Please let me know if you need anything else here.

Additional Information

As always, please contact Broadcom support for Datacom if you have further questions.