• # Aleph table limits (maximum number of lines or characters)

• Article Type: General
• Product: Aleph
• Product Version: 18.01

Description:
Do you know about max lines or known issues related to the size (number of lines) of edit_paragraph?

Also, is there any central place for information about such limits? (The table headers sometimes have this information, but most of the time they do not.)

Resolution:
The "asm copy" files often show the maximum number of lines for Aleph tables. For example:

./alephm/source/copy/TAB_EXPAND has:

02 TAB-EXPAND-LINE OCCURS 1000.

./alephm/source/copy/TAB33 has:

02 TAB33-LINE OCCURS 1000.

./alephm/source/copy/TAB_EDIT_DOC has:

02 TAB33-LINE OCCURS 1000.

(Note: The ./alephm/source/copy files are always unencrypted.)

There is, however, no "asm copy" file for edit_paragraph, since Ex Libris has a policy not to create such a file for tables that are used (i.e. read or loaded into a buffer) by only one program. For these, the limit can be found only in the loading/reading program. E.g. for edit_paragraph, we can see in ./alephm/source/com/edit_paragraph.cbl that there can be up to 4000 lines:

01 TAB-EDIT-MAX-LINES PICTURE 9(9) COMP VALUE 4000.

(Note: Since the source for most of the ./alephm/source programs is encrypted, you will not be able to see this in some cases. Contact Ex Libris in such cases.)

The following search (specifying "All terms") in the Knowledge Base: limit lines <tabxx>

(where 'tabxx' is the table you want to find the limit for) often yields good results.

KB 8192-5113 has certain doc record limits: Maximum record length, maximum number of subfields, maximum field length....

• Article last edited: 10/8/2013