Rule Definition
SQL statements in COBOL provide the best performance when they can be prepared by the DB2 precompiler prior to the COBOL compilation. Using the EGL prepare statement to prepare SQLstatements at runtime bypasses the DB2 precompiler. Recommendation Don’t use the prepare statement in applications intended for COBOL environments.

Remediation
Try to reduce the use of prepare statements.

Violation Code Sample

function test1()
  stringExpression String= "delete from " +
     "CASTTEST T1 "+
    "where "+
     "M= ?";
  prepare preparedStatementIdentifier from stringExpression;  // VIOLATION
  execute preparedStatementIdentifier
   using CASTTEST.T1;
 end

Fixed Code Sample

function test1()
  execute 
   #sql{
    delete from
     CASTTEST1 T1
    where
     M= CASTTESTT1.M
   };
 end

EGL Best Practices: Coding For Performance. November 10, 2009. Edition 2