Re: Trigger and remote query

[rob@xxxxxxxxx]

Titus,

I never assume that my trigger programs will always come from one 
particular RPG application running in the perfect library list.  I test my 
trigger programs with UPDDTA and my library list at the time has no 
library that is not in QSYSLIBL or QUSRLIBL.  Sometimes it takes various 
tricks.  One trick may be using the library that is passed into the 
trigger buffer to condition other files, (providing they are in the same 
library).  It's as simple as making the files user open and using the 
EXTFILE keyword.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Titus Kruse" <t_kruse@xxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
07/09/2004 08:44 AM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
"Midrange RPG" <rpg400-l@xxxxxxxxxxxx>
cc

Subject
Trigger and remote query






Hi!

Another short question on triggers. When I do a SQL UPDATE on a physical
file located on a remote system, the trigger program associated to that 
file
is called. But when the program reads another database file, an error 
occurs
on the remote system server job: The second file was not found by 
searching
the library list. Any ideas? Why does the server not looks in the library
with the trigger file or program?

Sorry for a little bit offtopic from the rpg-list.


Titus Kruse
Software-Entwicklung IBM iSeries
ESW Software Warda KG (GmbH & Co.)
Telefon: +49.40.682893.22
E-Mail: t_kruse@xxxxxxxxx
Web: www.esw-kg.de


--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.