Executing Dynamic SQL Statements

In most cases, the SQL statements executed by an application are known when the application is written. However, in some cases, SQL statements are constructed at run time or provided by external sources. In these cases, the SQL statements cannot be directly embedded into the C source code, but dynamic SQL statements allow you to call the provided SQL statements in a string variable.

• Executing a Statement Without a Result Set
  
• Executing a Statement with Input Parameters
  
• Executing a Statement with a Result Set