I need to create a delay before the translation that contains a DB table lookup executes in order to give the DB time to update. Is there someway in TCL to create this delay as pre-proc?
How do you know how long to delay? What indication do you have that the DB is ready?
Write messages to a file or sqlite DB (preferable). Have another thread that reads the file/DB and checks if DB is ready. if not leave as is if so send it through the engine.
I have done this in the past where the inbound thread did a select on the external Database table and if it returned with a good answer then it read from the local sqlite db table and processed each data message. If not a good answer, the inbound UPOC did not read from the local sqlite db table. The thread was setup as a UPOC on a schedule and ran every 2 minutes.
.
.