Very Computer

1. Trigger doing UNLOAD to file OR calling Store Procedure doing the UNLOAD to file

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

Dario

2. Need Help with Installation of Oracle 8i Enterprise Ed

3. Need help doing backups

4. CreateObject("UserManager.Server")

5. replacing sql master.mdf with a saved copy (file only) not from sql backup

6. Is OPENXML good ?

7. how to configure the RecoverEDGE2 that can backup the D3 virtual machine from the Master Backup

8. row locking/querying with JDBC

9. need help about autoextend feature

10. Multiple data files set to autoextend

11. Need help about autoextend

12. Need to import a SQL7 database from a file backup into a SQL2000 server

13. Text file records comparaison against a Master text file