Universe Trigger in a Distributed Files

[Ramon Ribo]

Hi

I'm working on Universe 11.1 and Solaris.

I would create a trigger in a distributed file. 

When I execute the command :

>CREATE TRIGGER TRIG_NAME AFTER INSERT OR UPDATE OR DELETE ON FILE_NAME FOR EACH ROW CALLING '*SUB_NAME';

UniVerse/SQL: Invalid file type specified.
Warning: SICA information could not be read properly!!

The same command executed on a non distributed file works fine.

Anybody kwows why ?

Thanks

[Brian Speirs]

Hi Ramon,

Triggers (like indices) work on individual files - not on a compound file like a distributed file. You will need to apply the trigger to each individual file that makes up the distributed file.

Try reading the notes on triggers that I wrote up - see www.rushflat.co.nz

Cheers,

Brian

[Ramon Ribo]

Thank you Brian for your information

El dimarts, 16 maig de 2017 10:28:44 UTC+2, Brian Speirs va escriure: