ASA Programming Guide
Embedded SQL Programming
Static and dynamic SQL
All standard SQL data manipulation and data definition statements can be embedded in a C program by prefixing them with EXEC SQL and suffixing the command with a semicolon (;). These statements are referred to as static statements.
Static statements can contain references to host variables, as described in Using host variables. All examples to this point have used static embedded SQL statements.
Host variables can only be used in place of string or numeric constants. They cannot be used to substitute column names or table names; dynamic statements are required to perform those operations.