RE: Record already locked by the job

Hello,

please find my answers below.

Regards

Pascal

-----Original Message-----
From: Wilt, Charles [mailto:CWilt@xxxxxxxxxxxx]
Sent: 25 May 2005 13:34
To: RPG Programming Mailing List (E-mail)
Subject: RE: Record already locked by the job


Pascal,

When does the program that causes the trigger to fire do a commit? 

------> After having done as many updates or writes it is supposed to.

 Is it possible that the same record is updated, causing the trigger to fire
multiple times for the same record, without having done a commit before
hand?

------> Most likely no, but the same record in the file that is written and
updated by the trigger will be updated several times within a commit cycle.


Does the process that fires the trigger also do I/O to the file the trigger
program is doing I/O to?

------->

No.


Charles Wilt
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  
-----Original Message-----
From: pascal.jacquemain@xxxxxxxxxxxxxx
[mailto:pascal.jacquemain@xxxxxxxxxxxxxx]
Sent: Wednesday, May 25, 2005 7:55 AM
To: Wilt, Charles
Subject: RE: Record already locked by the job


Hi, 
thanks for your answer but no, I am not trying to do what you suggest... 
Regards 
Pascal Jacquemain 


-----Original Message----- 
From: Wilt, Charles  
Sent: 25 May 2005 12:36 
To: RPG programming on the AS400 / iSeries 
Subject: RE: Record already locked by the job 


Are you saying that your trigger program does I/O to the file that the
trigger program is attached to? 
You can't do that. 
What are you trying to accomplish? 
Charles Wilt 
iSeries Systems Administrator / Developer 
Mitsubishi Electric Automotive America 
ph: 513-573-4343 
fax: 513-398-1121 
  



The opinions expressed within this email represent those of the
individual and not necessarily those of Gullivers Travel Associates (GTA).

This email and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify postmaster@xxxxxxxxxxxxxx

Should you wish to use email as a form of communication, GTA are unable to
guarantee the security of email content outside of our own computer systems.


______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
______________________________________________________________________