Re: Dynamic query inside the stored procedure

ayyasamy subramanian wrote: > I am trying to write a dynamic query inside a stored procedure and > try to execute that . I don't have any idea about If u guys know > anything about that kindly share the knowledge with me , it would be > grateful. Actually what i want is > > select * from <table_name> where <fld1> = param1 {or|and} > <fld2> = param2 {or|and} <fld3> = param1 ......> > This "or" and "and" vary from time to time . Basically i want > write a dynamical select statment inside the stored procedure and > to execute the same. I want to find an algorithm which lets me draw a square with the same area as a given cirle - commonly called 'squaring the circle'. I also want to find a perpetual motion machine other than my son. I'm unlikely to be successful in either endeavour, unfortunately :-( Similarly, all existing versions of SPL do not support dynamic SQL in any shape or form. SPL is the wrong tool for the job you are trying to do. One day, maybe. But that day has not yet been scheduled to the best of my knowledge. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>