Re: UNLOAD statement in stored procedure?
Mahesh wrote :-
> Hi,
> Will UNLOAD statement work in a stored procedure?
> I am getting a error 201 when compiled in Informix 7.14.
> Advance thanks.
> Regards,
> Mahesh G, Motorola.
> Email: ind018@email.mot.com
I'm afraid not. According to the Informix Guide to SQL:Syntax Version
6.0, the following statements are NOT allowed within SPL :-
CHECK TABLE FREE
CLOSE GET DESCRIPTOR
CLOSE DATABASE INFO
CONNECT LOAD
CREATE DATABASE OPEN
CREATE PROCEDURE OUTPUT
CREATE PROCEDURE FROM PREPARE
DATABASE PUT
DECLARE REPAIR
DESCRIBE ROLLFORWARD DATABASE
EXECUTE SET DESCRIPTOR
EXECUTE IMMEDIATE START DATABASE
FETCH UNLOAD
FLUSH WHENEVER
(Make sure you use dbaccess to create the procedure, rather then
I-SQL!).
Regards
Glyn Balmer
I.T. Consultant
BICC Cables Limited
Erith Kent UK