*FILE is in use message from executesql command

[mpace25]

I have a script that writes records via ODBC to an AS/400 (db2) through an executesql command in paradox. Occasionally there is a file lock on the AS/400 that causes the paradox script to receive an error message. The first "page" of the message says "an error was triggered in the 'executeSQL' method on an object of SQL type. (Then it give the line number of the error).

It also has the >> button where it tells me that "[IBM][client access ODBC driver (32-bit)][db2/400 SQL]SQL0913 - row or object ECP250 in WATCOMM type *FILE in use."

Where ECP250 is the file, WATCOMM is the library that is locked.

What I would like to do is put a wait loop and try the command again, knowing that this file will be released almost immediately.

 

[Langley]

Use sleep(number in ms) to get the delay you need. I'd start with sleep(500) then adjust from there.

Mac

"Do not delve too deeply in the arts of your enemy and so become ensnared by them"

langley_mckelvy@cd4.co.harris.tx.us