Question:
We need to create a view based on about 1600 tables. One of the problems is that we cannot enter all of the query into the buffer because the query takes too much space (more than 32k).
Can we create a view by calling some store procedure? If so, can we use the same technique for the insert, update, and delete into that view?
Answer:
That’s insane. Even if you manage to get it to work (assuming that Informix can even handle a view of that size, and I doubt that Informix can join so many tables) your performance will be awful.
You need some serious database redesign if that’s the best way you can figure out how to get the data you need. Talk to your DBA or data architect and figure out another way to do this.