dbTalk Databases Forums  

File Triggers

comp.databases.pick comp.databases.pick


Discuss File Triggers in the comp.databases.pick forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
AT
 
Posts: n/a

Default File Triggers - 05-16-2006 , 10:16 PM






Dear All,

Does universe file triggers work in PICK flavor account and has anyone
used them?

Thanks,
Guna


Reply With Quote
  #2  
Old   
B Faux
 
Posts: n/a

Default Re: File Triggers - 05-17-2006 , 01:37 PM







<gunasegeran (AT) gmail (DOT) com> wrote

Quote:
Dear All,

Does universe file triggers work in PICK flavor account and has anyone
used them?

Thanks,
Guna

Guna,

Check out openQM at http://www.ladybridge.com/

I believe their triggers work just fine with the Pick style switches turned
on... good luck...

BFaux




Reply With Quote
  #3  
Old   
 
Posts: n/a

Default Re: File Triggers - 05-20-2006 , 04:53 AM



Hi,

Yes, we use Universe triggers under pick flavor (uv on unix or uv on nt).
It works very fine.

Triggers a linked into the file'es header and the flavor is not relevant to
define it.
When you prepare your trigger subroutine, you can specify the compilation
flavor via $OPTIONS PICK and you need to global catalog it.
To make a global catalog from a pick flavor account, you must define a
CATALOG verb for INFORMATION format. Do this :

on your pick flavor set a pointer to uv VOC
SET.FILE UV VOC UVVOC

the copy the UVVOC CATALOG verb localy under another name
COPYI FROM UVVOC TO VOC CATALOG,CATALOG.INFORMATION

the you can global catalog your subroutine
CATALOG.INFORMATION yourprogfile *TRIGSUBROUTINE yourtrigsubroutinename

the CREATE TRIGGER is a part of uv's SQL.
see the uv's doc to CREATE TRIGGER ... syntax

Manu
<gunasegeran (AT) gmail (DOT) com> a écrit dans le message de news:
1147835798.691893.67160 (AT) 38g2000...oglegroups.com...
Quote:
Dear All,

Does universe file triggers work in PICK flavor account and has anyone
used them?

Thanks,
Guna




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.