Host Variables

This section describes how to use host variables to pass data between C programs and embedded SQL programs. In C programs with embedded SQL statements, we use the C language as the host language and regard EXEC SQL [Command] statements as embedded SQL statements of the host language. Therefore, variables used for embedded SQL statements in C programs are called host variables.

• Overview
  
• DECLARE Section
  
• Retrieving Query Results
  
• Type Mapping
  
• Handling Character Strings
  
• Host Variables with Non-primitive Types
  
• Accessing Special Data Types
  
• Handling Non-primitive SQL Data Types