A host variable name must conform to C naming conventions.
You can use a host variable in an Embedded SQL statement wherever a Transact-SQL literal can be used in a Transact-SQL statement at the same location.
A host variable must conform to the valid precompiler datatypes. The datatype of a host variable must be compatible with the datatype of the database column values returned. See Table 4-5 and Table 4-6 for details. You cannot use host language reserved words and Embedded SQL keywords as variable names.
A host variable cannot represent Embedded SQL keywords or database objects, except as specified in dynamic SQL. For more information on using host variables to represent keywords for database objects, see “Chapter 7, “Using Dynamic SQL.”
When a host variable represents a character string in a SQL statement, do not place it within quotes.
The following example is invalid because the precompiler inserts quotes around values when necessary. You should not type the quotes.
strcpy (p_id, "12345");
exec sql select pub_id into :p_id from publishers
where pub_id like “:p_id”;
The following example is valid:
strcpy (p_id, “12345”);
exec sql select pub_id into :p_id from publishers
where pub_id like :p_id;
