Hi,
My UV is release 10.2 and if I try convert a regular pick file there are the
error message :
CREATE TRIGGER T_TRIGGER AFTER INSERT OR UPDATE ON GVMTA030 FOR EACH ROW
CALLING '*T_TRIGGER';
UniVerse/SQL: Invalid file type specified.
Warning: SICA information could not be read properly!!
T_TRIGGER
001 SUBROUTINE
T_TRIGGER(PAR1,PAR2,PAR3,PAR4,PAR5,PAR6,PAR7,PAR8,PAR9,PAR10,PAR1
1,PAR12,PAR13,PAR14)
002 RETURN
What type of file are you using?
Thanks in advance.
Regards,
Marcos Fogaca
-----Mensagem original-----
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Em nome de gerry-u2ug
Enviada em: terga-feira, 11 de setembro de 2007 18:26
Para: [email protected]
Assunto: RE: [U2] Universe and triggers
Hi Marcos, what version of universe are you running ?
We used to use the index w subroutine method you describe but this is
now gone in favour of native universe triggers. We have many files in
universe with triggers on them , there is no requirement to SQL'ize the
table and believe me these tables would take a LOT of work to make them
sql conformant.
Universe will add a SICA for the table but that's it, any garbage hashed
file works just fine afaik.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: September 11, 2007 04:07 PM
To: [email protected]
Subject: Re: [U2] Universe and triggers
Hi Marcos,
Universe seems hellbent on invoking the entire SQL system in order to
put a simple trigger on a file. UniData is MUCH more forgiving in that
regard.
With Universe, I have had a certain amount of success making what I call
'indexed subroutines' where by an index on a file calls a virtual
Dictionary subroutine which does, in fact, operate as a rudimentary
trigger. You CANNOT affect data going to the actual file record update
as you might with an actual trigger, but you can write information to a
tracking database and then I have a background phantom in operation
which manages email distribution from the triggered events and what not.
I *could* even write back to the originating file record that initiated
the trigger -- I've closed off the mortal embrace between phantom and
virtual subroutine -- but that will always have a lag time between the
actual record update event and the final conclusion of the trigger, so I
would not consider it a particularly clean solution for true database
triggering. It does work well as a tracking and reporting system,
though.
Trey
-------------- Original message ----------------------
From: Marcos Fogaga <[EMAIL PROTECTED]>
> Hi,
>
>
>
> It is possible create a trigger (subroutine) for a pick file (non SQL
> table)?
>
> On D3 we have CALLX, is there a feature like this in Universe?
>
>
>
> Thanks in advance.
>
>
>
> Best Regards,
>
>
>
> Marcos Fogaca
>
> Integral Sistemas
>
> Sao Paulo / Brazil
> -------
> u2-users mailing list
> [email protected]
> To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
