Hi Clif,
My file is type 18 and it is multi data level.
DICT GVMTA030 D_GVMTA030 18
7
DATA GVMTA030,BAIXADOS GVMTA030/BAIXADOS 18
3001
DATA GVMTA030,DELETADOS GVMTA030/DELETADOS 18
3001
DATA GVMTA030,GVMTA030 GVMTA030/GVMTA030 18
5001
>.L GVMTA030
GVMTA030
001 F
002 GVMTA030
003 D_GVMTA030
004 M
005
006
007 BAIXADOS}DELETADOS}GVMTA030
008 BAIXADOS}DELETADOS}GVMTA030
Do you know what must I do to create a trigger in a file with these
features?
Thank you.
Regards
Marcos Fogaga
-----Mensagem original-----
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Em nome de Clifton Oliver
Enviada em: terga-feira, 11 de setembro de 2007 19:54
Para: u2-users@listserver.u2ug.org
Assunto: Re: RES: [U2] Universe and triggers
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/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
