Restrictions on using FORTRAN to program embedded SQL applications

Embedded SQL support for FORTRAN are stabilized in Db2® Version 5, and no enhancements are planned for the future.

For example, the FORTRAN precompiler cannot handle SQL object identifiers, such as table names, that are longer than 18 bytes. To use features introduced to Db2 database systems afterDb2 Version 5, such as table names from 19 to 128 bytes long, you must write your applications in a language other than FORTRAN.

FORTRAN database application development is not supported with Db2 instances in Windows or Linux® environments.

FORTRAN does not support multi-threaded database access.

Some FORTRAN compilers treat lines with a 'D' or 'd' in column 1 as conditional lines. These lines can either be compiled for debugging or treated as comments. The precompiler will always treat lines with a 'D' or 'd' in column 1 as comments.

Some API parameters require addresses rather than values in the call variables. The database manager provides the GET ADDRESS, DEREFERENCE ADDRESS, and COPY MEMORY APIs, which simplify your ability to provide these parameters.

The following items affect the precompiling process:
  • The precompiler allows only digits, blanks, and tab characters within columns 1-5 on continuation lines.
  • Hollerith constants are not supported in .sqf source files.