Just joined the U2 group but for some reason the search of email
archive isnt working so I shall ask the question here if you dont mind
:-)

So I copied a bunch of files to the test account at the Unix Shell. I
know, thou shalt not, but I've done it many a time in UniData & I
didint have time to copy items.
The files LIST okay but if I update it complains that of a common
mismatch in a subroutine starting with *liveaccountname*. I guess I've
most likely copied triggers across but darned if I can find out how to
even list the triggers in Universe in any of the PDFs I've downloaded
from IBM.

So how to list the triggers in Universe 10.0?
How to change the subroutine called?
I've searched the dictionary of the live & test files for the
subroutine name but found no match.

Thanx for any help
Jeremy Thomson

panzerboy (AT) gmail (DOT) com wrote:
<http://www.mail-archive.com/u2-users%40listserver.u2ug.org/>

Ron White

--
Posted via NewsDemon.com - Premium Uncensored Newsgroup Service
------->>>>>>http://www.NewsDemon.com<<<<<<------
Unlimited Access, Anonymous Accounts, Uncensored Broadband Access

Ron White wrote:
Thank you Ron.

In case anyone else is interested (or searches the Archive).
LIST.SICA filename - lists UNIVERSE TRIGGERS
(SICA "Security and Integrity Constraints Area", obvious? NOT)
CREATE TRIGGER triggername AFTER INSERT OR UPDATE OR DELETE ON filename
FOR EACH ROW CALLING 'somesubroutine';
DROP TRIGGER filename triggername;