RE: Record already locked by the job

["Wilt, Charles" <CWilt@xxxxxxxxxxxx>]

Pascal,

Please reply to the list so that others may follow the discussion...

When does the program that causes the trigger to fire do a commit?  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?

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


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