I use triggers on 10.2 files frequently.
What file type is GVMTA030?
If it's a type 1 or 19, it won't work. If it is a static hashed 2
through 18 it will. Also works on type 30.
However, if it is a distributed file, you have to create the trigger
on each individual partfile; you cannot name the top level DF.
Also, do a tcl
>.L GVMTA030
And see if there is an M in line four. Creating triggers on multi
data level files requires some tricks as the comma is not valid in a
file name for CREATE TRIGGER (SQL syntax restriction).
--
Regards,
Clif
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
W. Clifton Oliver, CCP
CLIFTON OLIVER & ASSOCIATES
Tel: +1 619 460 5678 Web: www.oliver.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
On Sep 11, 2007, at 2:53 PM, Marcos Fogaga wrote:
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: u2-users@listserver.u2ug.org
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: u2-users@listserver.u2ug.org
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
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/