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/OSD 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/OSD 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.
