Utilizing SQLite table within an Xlate

[Joe Halbrook]

I’ve got a lab system that will be sending a new order description file nightly, for which I will pick up, drop the previous SQLite table that I’m building from it, and then recreate that table from the new nightly file.

My quesions is:  Will my process need to be bounced after I recreate the SQLite table so that my Xlate used between threads in that process will always pick up the correct values from the SQLite table, i.e. is there a cache to have to worry about?

Thanks, in advance.

Joe

Topic

[Rob Abbott]

Hi Joe, sqlite doesn’t cache so you shouldn’t have to bounce anything to pick up changes.

You would want to handle the possible condition where an xlate is running while the table is being dropped and recreated…

Rob Abbott
Cloverleaf Emeritus

[Joe Halbrook]

Excellent.  Thanks, Rob.  I appreciate the prompt feedback.

[Author]

Replies