Ways to access DB2 data that is not in a table

You can access DB2® data even if it is not in a table.

This method of data access can be accomplished in two ways.

• Set the contents of a host variable to the value of an expression by using the SET host-variable assignment statement.
  Example:

  EXEC SQL SET :HVRANDVAL = RAND(:HVRAND);

• In addition, you can use the VALUES INTO statement to return the value of an expression in a host variable.
  Example:

  EXEC SQL VALUES RAND(:HVRAND)
  INTO :HVRANDVAL;