Database Limits

Limits of Persistent Agile Business Suite Constructs

The Database Reorganization module of AB Suite translates the persistent constructs of the model into database structures. The naming conventions for the database structures and the corresponding limits is listed in the following table:

Model Construct

DB Construct

DB Naming Convention

Length_Limit

Database Schema (Segment property)

Database Schema

Database Schema

8 characters

Persistent Ispec

Table

SegmentName_IspecName

30 characters

Persistent Attribute

Column

ColumnName

30 characters

Profile

Index

SegmentName_ProfileName

30 characters

Conditional Profile

Materialised View

SegmentName_MaterialisedViewName

30 characters

SQL Scripts

Stored Procedures

Stored Proc Name=CONSTRUCT, PREPARE, MAIN

30 characters