Host Variable Usage
Host variables are used in SQL statements to pass values between the database and the application program.
· to manipulate information taken from the database or contained in other variables (in expressions)
In all these contexts, the data type of the host variable or database column must be compatible with the data type of the corresponding database value or host variable.
Note: The colon is not part of the host variable name, and should not be used when the variable is referenced in host language statements.
Do write me @ iSeriesblogs@gmail.com for any query or you can simply post comments below.