Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: Informix
Expertise: Beginner
Aug 11, 2000



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Store Procedure and View Creation

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?

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.

DevX Pro
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date