Iam using a unix script to unload data from informix table every hour(unload command). The script works fine but sometimes when the unload command is executind and their is a entry going on in informix table, the unload command aborts giving a index error.
This problem is similar if we use sacego to unload data. but for sacego we can set SACEISOL="dirty read" and the problem is solved.
In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!