I have a program that will copy one file (file 1) to another (file 2) when the user is satisfied that the file is correct. File 2 is being used in many different programs as IF, not UF. These programs have a few reads/chains to File 2 that do not have the (N) for not locking the record. The copy program is not able to copy file 1 to file 2 while these programs are running. I thought if a file was opened as IF it wouldn't lock it. Some of the programs also use SQL to access the file, which I also thought wouldn't lock the file.
Is my only recourse to use a USROPN on file 2 and thus reducing the window time the file is actually open and is locked? Would this solution also work for the SQL statements?