Re: Locking across processes

Gerard Tynen (gtynen@flowbee.interaccess.com) wrote: : as our database back end. When an exclusive table lock is placed : on a table on the AS/400, the process that placed the lock as well : as all of its subprocesses can still write that table. Much of the : logic in the programs we are porting depend on this behavior, where : a lock is placed by one process, then a new process is spawned, and : the child process writes the table. AFAIK a child process has the choice of inheriting the existing connection to the database server or closing it and starting up a new server (thereby losing any right to a lock established by the parent). The ESQL-C calls to accomplish this are not particularly well documented. I would add that my experience of passing database servers to child processes have not been exactly trouble free. :-) Mike.