IC81107: PREPARED AND DYNAMIC SQL STATEMENTS NOT DESCRIBED FOR STANDARD SPL

APAR status

• Closed as documentation error.

Error description

• You want to create a stored procedure with a prepared statement
  and a dynamic SQL statement and execute the procedure as a
  stand-alone statement called from SQL. You find documentation
  within the context of application programming tools, such as
  esql/c, but not for simple SQL calls.
  

Local fix

• Reference:
  
  http://www.ibm.com/developerworks/data/library/techarticle/dm-08
  06mottupalli/index.html
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users of version 11.70xC4 and earlier versions.          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description: Prepared and dynamic SQL Statements   *
  * not Described for Standard SPL                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * See:                                                         *
  * http://www.ibm.com/developerworks/data/library/techarticle/d *
  * m-0806mottupalli/index.html                                  *
  ****************************************************************
  

Problem conclusion

• Dynamic SQL support in the Informix SPL language
  
  The IBM Informix SPL language supports Dynamic SQL and prepared
  objects. For an overview with complete examples of how to create
  and use Dynamic
  SQL in SPL routines, view or download the IBM developerWorks
  article by Srinivasan R. Mottupalli, Rahul M. Dhuvad, and Archit
  Arya at this link:
  
  http://www.ibm.com/developerworks/data/library/techarticle/dm-08
  06mottupalli/index.html
  

Temporary fix

Comments

• For download information, go to:
  http://www.ibm.com/support/fixcentral
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels