Trigger Perormance Issues when Journalling Started
I have an external trigger program (RPGIV) that is added to about 50 files. Its task is to store record images upon insert, delete, update in any of the 50 files. It stores the images in another file (the monitor file) which also contains an identity field (generated always as identity). All files, including the [...]

Answer Question   |  August 11, 2012  12:57 PM
Journal, performance, TRIGGER

AS400 Triggers
I have some triggers set up on our AS400. A record gets written to a physical file each time one of the triggered files has an add, update or delete performed against it. The problem is that we have a few batch programs that do not write to the trigger file when run (and update [...]

Answer Question   |  May 27, 2011  7:58 PM
AS/400 administration, AS/400 Parameters, AS/400 triggers, CL batch program, TRIGGER, Trigger failure

Database Update database
I will whole database all tables, procedures, triggers, functions defination in one file. i want to use that file to upgrade another database. is it possible ?

Answer Question   |  July 30, 2010  5:02 AM
Database management, Sunrise, TRIGGER

remove a trigger file record lock
I have a CLLE trigger program that is trying to set a job environment. I am manipulating the LIBL on the fly based on the location of the order and if it’s TEST or LIVE. I get the info from the trigger input parms which has the order#, location, TEST or LIVE, order# and order [...]

Answer Question   |  April 8, 2010  4:23 PM
CLLE, Record lock, RPGLE Program, TRIGGER

Trigger errors
Why is my trigger program failing? It’s a CL program and it appears it is not even getting to the early part of the program where I have a halt to check job attributes. I created a physical file on our iSeries and added a trigger using the following command. ADDPFTRG FILE(EXTRANET/WCTLH) TRGTIME(*AFTER) TRGEVENT(*INSERT) PGM(EXTRANET/WXTRAOE) TRGLIB(EXTRANET). [...]

Answer Question   |  April 1, 2010  6:20 PM
ILE RPG, TRIGGER, Trigger failure

Working TRIGGER and TRANSACTIONS QUESTION
Hello all, My company purchased an operations software (called [strong]darwin[/strong]) that works with SQL 2005 Server. I need to extract some data and save it in my Own Database, which is located in the same SQL Server. On the darwin software there is a screen that updates a field X in a table, which fires an an AFTER [...]

Answer Question   |  October 1, 2009  6:25 PM
SQL Server 2005, SQL Trigger, Transactions Per Second, TRIGGER