× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Hi,

I have a PF (say file1) with some fields like empno, name, city etc which is
keyed on EMPNO.
When a record gets inserted into this file, I want to execute a simple
trigger program ( thats the RPG program) which updates a field from another
file (say file2) with 'I'.
Now, I added this RPG program as a trigger to PF thru ADDPFTRG and tried to
check whether my RPG workes fine by simply inserting a record thru STRSQL.
The record gets added to file1, but the RPG trigger program gets some error
- 
"Trigger program or external routine detected an error."

I initiated STRDBG UPDPROD(*YES) to get into details.  The JOBLOG says - 

CONNECT to relational database PCSAS400 completed.      
Current connection is to relational database PCSAS400.  
Current connection is to relational database PCSAS400.  
Unable to retrieve query options file.                  
**** Starting optimizer debug message for query .       
Arrival sequence access was used for file TSTKEY.       
**** Ending debug message for query .                   
ODP created.                                            
Error occurred in trigger program.                      
Error occurred in trigger program.                      
ODP deleted.                                            
Trigger program or external routine detected an error.  
Connection to relational database PCSAS400 ended.       
SQL cursors closed.                                     


Please Help me executing my RPG trigger code.


Thanks and Regards,
Gauri.

http://www.patni.com
World-Wide Partnerships. World-Class Solutions.
_____________________________________________________________________

This e-mail message may contain proprietary, confidential or legally
privileged information for the sole use of the person or entity to
whom this message was originally addressed. Any review, e-transmission
dissemination or other use of or taking of any action in reliance upon
this information by persons or entities other than the intended
recipient is prohibited. If you have received this e-mail in error
kindly delete  this e-mail from your records. If it appears that this
mail has been forwarded to you without proper authority, please notify
us immediately at netadmin@xxxxxxxxx and delete this mail. 
_____________________________________________________________________

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.