REOPT requests

The REOPT general request element can be used to override the setting of the REOPT bind parameter, which affects the optimization of statements that contain parameter markers or host variables. It is defined by the complex type reoptType.

XML Schema

   <xs:complexType name="reoptType">
      <xs:attribute name="VALUE" use="required">
         <xs:simpleType>
            <xs:restriction base="xs:string">
               <xs:enumeration value="ONCE"/>
               <xs:enumeration value="ALWAYS"/>
            </xs:restriction>
         </xs:simpleType>
      </xs:attribute>
   </xs:complexType>

Description

The REOPT general request element has a required VALUE attribute that specifies the setting of the REOPT option. The attribute can take the value ONCE or ALWAYS. ONCE specifies that the statement should be optimized for the first set of host variable or parameter marker values. ALWAYS specifies that the statement should be optimized for each set of host variable or parameter marker values.