Re: using a select.
>Date: Tue, 28 Jan 1997 15:31:50 +0100
>From: Keith bugeja <keith.bugeja@magnet.mt>
>X-Informix-List-Id: <list.12850>
>
>does anyone know if it is possible to get the name of the columns of a table
>using the 'execute procedure' to execute a procedure that contains a select
>statement.
No, it isn't. I'm assuming that you have something like:
CREATE PROCEDURE FetchIt() RETURNING INT, CHAR(30), ...;DEFINE i INT, j CHAR(30), ...;
FOREACH SELECT * INTO i, j, ... FROM SomeTable
RETURN i, j, ... WITH RESUME;
END FOREACH;
END PROCEDURE;
The return columns are all designated '(expression)' by the DESCRIBE
statement.
Yours,
Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>