how to prepare the fetch SQL?

Posted in 2012

CHUAN LU — Wed, 08 Aug 2012 05:20:46 — source: IIUG Forums & Mailing Lists

Hi, Do anybody know how to prepare the fetch SQL? thanks for your time.

↪ replying to CHUAN LU

Jonathan Leffler — Wed, 08 Aug 2012 06:43:56 — source: IIUG Forums & Mailing Lists

On Tue, Aug 7, 2012 at 10:20 PM, CHUAN LU <luchuan@cn.ibm.com> wrote: > Do anybody know how to prepare the fetch SQL? > You can't prepare a FETCH statement. It is a client-side statement, and only server-side statements can be prepared. You can't prepare CONNECT statements, either, nor a variety of other statements. There's a partial exception to this rule with dynamic SQL in SPL, but it is still reasonably accurate (if you look at dynamic SQL in SPL in the right light). -- Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> Guardian of DBD::Informix - v2011.0612 - http://dbi.perl.org "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." --e0cb4efe2ae0bec33c04c6bb6eb1

↪ replying to CHUAN LU

Art Kagel — Wed, 08 Aug 2012 11:52:45 — source: IIUG Forums & Mailing Lists

What?? Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Aug 8, 2012 at 1:20 AM, CHUAN LU <luchuan@cn.ibm.com> wrote: > Hi, > Do anybody know how to prepare the fetch SQL? > thanks for your time. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --bcaec51824f42bef2f04c6bfbf06