I have a RPG IV program that uses DDM files and local files at the same time. This program is being called from...
a CL that starts commitment control with level of record locking *CHG and scope *ACTGRP.The program crashes when it's trying to open a local file, and the error message says that I can't place a local file under commitment control when commitment control is active at a remote, one-phase, updateable location.
The DDM files are being accessed through TCP/IP (RMTLOCNAME = IpAddress *IP). V5R1 is the release level of the system. How can I solve this problem?
Since DDM does not support two-phase commitment control, the only way to solve the problem is to use DRDA & SQL instead of DDM files. The Distributed Database Programming manual, should get you started.
MORE INFORMATION ON THIS TOPIC
Search400.com's targeted search engine: Get relevant information on DB2/400.
The Best Web Links: tips, tutorials and more.
Check out this Search400.com Featured Topic: Database issues resolved
Related Q&A from Kent Milligan
To solve the SQL error -321 on IBM i6.1, use the new values statement to overcome the error. If you are using an older release, declare a cursor ...continue reading
Create a host variable of the where in statement on the fly with dynamic SQL.continue reading
To monitor members stuck within a physical file on AS/400, you can periodically use the display file description (DSPFD) command to create an output ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.