DB2 Server for VSE & VM: Application Programming

Restrictions When Using the FORTRAN Preprocessor

The FORTRAN preprocessor is an extended dynamic preprocessor that uses the NOMODIFY and DESCRIBE options of the extended CREATE PACKAGE statement. The other extended CREATE PACKAGE options that are used are taken from the parameters specified when invoking the preprocessor.

FORTRAN programs are preprocessed and executed using extended dynamic SQL. Those that are preprocessed with the DB2 Server for VSE & VM FORTRAN preprocessor must, therefore, comply with the same restrictions that apply to extended dynamic SQL, or programs preprocessed or executed using extended dynamic SQL.

The following is a partial list of restrictions when using the FORTRAN preprocessor.

• The BIND preprocessing parameter is ignored by the FORTRAN preprocessor. (DB2 Server for VSE)
• When declaring a dynamic cursor, if you are using the following format of the PREPARE statement, you must code it in your program before the DECLARE CURSOR statement:

      PREPARE statement_name FROM string_constant
  

  This restriction does not apply when using the following format of the PREPARE statement:

      PREPARE statement_name FROM host_variable
  

• When using DRDA protocol, the following statements are not supported:

      SELECT INTO
  

      Positioned UPDATE
  

      Positioned DELETE
  

• When switching between SQLDS protocol and DRDA protocol, you cannot do the following:
  • Preprocess a program using one protocol and then execute it using another protocol.
  • Preprocess a DB2 Server for VM program using one protocol, and then repreprocess the program using another protocol. If the original program is dropped with the DROP PACKAGE statement, you can repreprocess the program using a different protocol.