Hello everybody,
maybe it's an informix specific question. Unfortunately I don't know (google search was unfortunately not successful )
and I'm hoping now somebody of you guys can give me a hint.
Our database environment is Informix 14.10 with client SDK 4.1
The users have a form for entering search criteria for a database selection. So far so normal.
The table to be selected is pretty wide (about 230 columns) and the users are entering a lot of OR-criteria separated by <GOLD><PIPE> into a particular field as a search profile.
Debugger shows me a pretty large SQL-Statement of about 12000 characters.
Trying to perform a retrieve now results in a "Informix: Driver ERROR (50): Sql command buffer overflow"
As I can successfully perform that generated SQL-Statement via informix dbaccess or via Squirrel (jdbc) I'm not sure where my (uniface) problem comes from.
What's causing the error? A Uniface limitation itselves, or is it caused by client sdk?
What is the maximum sql command buffer size?
BTW: It's even possible to get uniface crashing (tested with 9.7 and 10.3.03) if the search profile is getting larger :-(
Best regards
------------------------------
Michael Rösch
Abrechnungszentrum Emmendingen
------------------------------