Re: limitations on string-spec used in PREPARE

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> Jonathan: I know of a client that is doing a PREPARE from a TEXT data type. The SQL statement is stored in a table. He developed his own report processing scheduler. Is he still limited to the 32k statement size? Ron Delpiere-Smith, CSE reds@infomrix.com