Ingres 11.0 | Use of Host Language Variables in a Union

OpenSQL Reference Guide > OpenSQL Reference Guide > OpenSQL Statements > SELECT (embedded) > Use of Host Language Variables in a Union

Was this helpful?

Use of Host Language Variables in a Union

When SELECT statements are combined using the UNION clause, the INTO clause must appear only after the first list of select result expressions, because all result rows of the SELECT statements that are combined by the UNION clause must be identical. The following example shows the correct use of host language variables in a union; result variables are specified only for the first SELECT statement:

EXEC SQL SELECT ename, enumber
              INTO :name, :number
              FROM employee
       UNION
       SELECT dname, dnumber
              FROM directors
              WHERE dnumber < 100;

Last modified date: 01/30/2023