Specifying Where Values Go in Memory

Each value from the select list of the query or the output of the executed user-defined function must be returned into a memory location. You can specify these destinations in one of the following ways:
  • Use the INTO clause of a SELECT statement.
  • Use the INTO clause of an EXECUTE Function (or EXECUTE PROCEDURE) statement.
  • Use the INTO clause of a FETCH statement.
  • Use a system-descriptor area.
  • Use an sqlda structure.