limitations on string-spec used in PREPARE

Posted in 1994

Francis Small — Mon, 25 Apr 1994 19:48:52 GMT — source: Informix-list mailing list archive (1991-1998)

When PREPAREing a statement (specifically, a SELECT statement) using a CHAR variable as the string specification, is there any limitation on how long the string can be? CHAR variables are limited to 32,768 characters (at least in my version), so can you PREPARE a 30,000 character SELECT statement? (I don't really need a 30,000 character statement, but a couple thousand would be nice.) Any other limitations in the complexity of the statement? . | . . . . . . . . . 1 . . . . . . . . . 2 . . . . . . . . . 3 . . . . . . . GIANTS Francis Small - M/S 2LRS Rockies Hewlett-Packard Company Bums Microwave Instruments Div. Padres 1212 Valley House Dr. Rohnert Park CA, 94928 707 794 3305 fthes@sad.hp.com *********************** National League West Standings ************************