Re: limitations on string-spec used in PREPARE

Hello. In article <2pjeih$kn5@emory.mathcs.emory.edu> johnl@informix.com (Jonathan Leffler) writes: > Yes, you can prepare statements up to 32k - 1 characters long. If you're > sure you know what you're up to, you can have more than one SQL statement > in the string you prepare, with statements separated by semi-colons. In > general, don't try mixing SELECT statements with other statements -- it'll > give you headaches workig out which thing does what. > > Yours, > Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> The 32K limit doesn't matter at all while you are generating SQL statements by brain. But if you're going to involve a generator that creates DML and/or SELECT/PREPAREs for you, 32K could turn out to be a serious limitation. In our project, the lagest queries in application programs are up to 4K, which is, I guess, more than you can maintain without appropriate tools, anyway. If you let end users generate their own queries over a complex, but widely normalized data model, e.g. using some clickety-clackety Windoof-based query generator, you will soon have queries with more that 32K size. Just my 2 Pfennige.