Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Peter Groarke — — source: Informix-list mailing list archive (1991-1998)
Hi,
an unload command that works fine using dbaccess interactively
wont work within a stored procedure. When I try to create the stored
procedure it generates a syntax error, pointing at the first char
of the unload statement. Is it the case that some SQL statements
are not allowed within stored procedures ? I checked the UNLOAD TO
documentation but could find nothing about this.
-Peter Groarke
BTW, here is the stored proc:
create procedure sac()unload to '/tmp/sac' delimiter '!'
select * from blah;
end procedure;
( informix 7.23.UC7 for solaris 2.6)
Your privacy choices
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.