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.
Mark D. Stock — — source: Informix-list mailing list archive (1991-1998)
Dario Rossa wrote:
>
> Hi,
>
> I don't if its possible to do the following on Informix 7.30 NT I get a SQL
> ERROR -201, probably wrong version or syntax error.
> Is this supported on IDS2000 ?
>
> create trigger TGU_getrws
> UPDATE of statcond ON COM_RWS_LST
> REFERENCING NEW AS val
> FOR EACH ROW WHEN(val.statcond = 'L')
> (UNLOAD TO 'D:\\data\\blabla' DELIMITER '|' SELECT statid from COM_RWS_LST
> WHERE statcond = 'L')>
> OR
>
> create trigger TGU_getrws
> UPDATE of statcond ON COM_RWS_LST
> REFERENCING NEW AS val
> FOR EACH ROW WHEN(val.statcond = 'L')
> (EXECUTE PROCEDURE P_tst_rws())>
> CREATE PROCEDURE P_tst_rws()
> ...
> UNLOAD TO 'D:\\data\\blabla' DELIMITER '|' SELECT statid from> COM_RWS_LST WHERE statcond = 'L'
> END PROCEDURE;
>
> Thanks for any comment on this
No, UNLOAD is not an SQL command, it is a built-in function in the isql,
i4gl/r4gl & dbaccess products.
Why don't you INSERT the records into another table and UNLOAD them at
your leisure?
Cheers,
--
Mark.
+----------------------------------------------------------+-----------+
| Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /|
| http://www.informix.comhttp://www.informixhandbook.com |///// / //|
| http://www.iiug.org +-----------------------------------+//// / ///|
| |This email will self-destruct in |/// / ////|
| |10 sec. If you received this email |// / /////|
| |in error, sorry about the mess. |/ ////////|
+----------------------+-----------------------------------+-----------+
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.