Fetch and insert with host variables

If you try to fetch a value from a database column into a host variable that you do not declare according to the correspondence shown in Corresponding SQL and host variable data types, Informix® ESQL/C attempts to convert the data types. Similarly, if you try to insert a value from a host variable into a database column, Informix ESQL/C might need to convert data types if the host variable and database column do not use the correspondences in Corresponding SQL and host variable data types. Informix ESQL/C converts the data types only if the conversion is meaningful.