APPENDIX A - SIZE LIMITATIONS

The standard version of Adabas Native SQL is limited to the following maximum sizes:

  • Length of an Adabas Native SQL source statement: 100 lines.

    Note:
    If the length of the statement exceeds 15 lines, then only the first 11 lines, a line of dots, and the last 3 lines will be stored for the purposes of TRACE, FLOW and runtime error reporting.

  • Number of fields mentioned by name in the SELECT clause: 300.

  • Number of fields contained in a file that is referenced with SELECT *: 500. (This number includes also the Redefinition fields within this file).

  • Number of distinct field names used within the program (these are the field names that will be written into the data dictionary by the cross-reference facility): 2000.

  • Number of distinct external subroutines used within the programs (their names will be written into the data dictionary by the cross-reference facility): 500.

  • Number of variable indices used within the program: 99.

  • Number of elements of redefinitions in one SELECT (PL/I only): 99.

  • Number of Adabas Native SQL SELECT statements without a 'CURSOR' : 100

  • Number of Adabas Native SQL statements that use 'CURSOR FOR' (multiple record processing): 120 (only applicable to operating systems z/OS, BS2000 and VMS).

  • Number of Adabas Native SQL statements that use 'CURSOR' (including statements that use 'CURSOR FOR'): 150 (only applicable to operating systems z/OS, BS2000 and VMS).

  • Number of files mentioned in the CONNECT statement: 100.

  • Number of declarations without a 'CURSOR': 100

  • Number of lines of ADA, COBOL, FORTRAN or PL/I code generated for one Adabas Native SQL statement, not including the direct calls: 200.

  • Maximum numbers supported for DBID: 32767.

  • Size of format buffer generated: 32767 bytes.

  • Number of selection criteria in a 'WHERE' clause: 30.

  • Number of constants (literals) used in selection criteria throughout the program: 250.

  • Number of constants (literals) used in selection criteria within one Adabas Native SQL statement: 69.

  • Number of variables in SET clause of UPDATE/INSERT statement: 300.

  • Number of characters in a literal within an Adabas Native SQL statement: 38.

Restrictions in ADA:

  • No redefinition.

  • No groups generated.

  • Periodic groups are always generated with STRUCT=N.

  • PACKED and UNPACKED fields are generated as alpha.

  • Superdescriptors are not divided into parts in the value buffer.

  • The DBID option is not supported.

  • FIND COUPLED is not supported.

  • The GLOBAL FORMAT-ID option is not supported.