Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Programming » SQL Anywhere Embedded SQL » Using host variables

Host variable usage Next Page

Indicator variables

Indicator variables are C variables that hold supplementary information when you are fetching or putting data. There are several distinct uses for indicator variables:

An indicator variable is a host variable of type short int that is placed immediately following a regular host variable in a SQL statement. For example, in the following INSERT statement, :ind_phone is an indicator variable:

 VALUES (:employee_number, :employee_name,
 :employee_initials, :employee_phone:ind_phone );

Using indicator variables to handle NULL
Using indicator variables for truncated values
Using indicator values for conversion errors
Summary of indicator variable values