IBM Informix Embedded SQLJ User's Guide
Chapter 4: The Embedded SQLJ Language
Contents
Index
Host Variables
Host variables are variables of the host language (in this case Java) that appear within SQL statements. A host variable represents a parameter, variable, or field and is prefixed by a colon ( : ), as in the following example:
#sql [ctx] { DELETE FROM customer WHERE customer_num = :cust_no };
You use the SELECT...INTO statement (as shown in this example), the FETCH...INTO statement (described in
"Positional Iterators"
), or an accessor method (described in
"Named Iterators"
) to retrieve data into host variables.
IBM Informix Embedded SQLJ User's Guide
, Version 1.0
Copyright © 1999, IBM Corporation. All rights reserved.