Type in LIMIT in TCL. You'll see something like :LIMIT U_MAXFNAME: File name limit = 198. U_NAMESZ: Record id(key) size = 126. U_SELEMAX: Number of select list = 10. U_MAXDATA: Number of DATA statement = 500. U_HEADSZ: HEADER/FOOTER length = 2120. U_MAXHASHTYPES: Number of hash functions = 3. U_MAXSORT: Number of sort fields(BY...) in LIST = 20. U_MAXWITH: WITH stack size = 256. U_MAXWHEN: WHEN stack size = 60. U_MAXCAL: Number of SUM+AVG+PCT+CAL in LIST = 54. U_MAXBREAK: Number of BREAK.ON+BREAK.SUP in LIST = 15. U_MAXLIST: Number of attribute names in LIST = 999. U_LINESZ: Page width in printing = 272. U_PARASIZE: Paragraph name and its parameter size = 256. U_LPCMD: System spooler name = NT Spooler. U_MAXPROMPT: Number of prompts allowed in paragraph = 60. U_FSIZE: Dictionary field name size = 31. U_MAXVALUE: Number of values WHEN can handle = 10240. U_MAXBYEXPVAL: Number of values BY.EXP can handle = 10240. U_SENTLEN: Maximum sentence length = 9247. U_PROCBUFSZ: Proc buffer size = 4095. U_NIDES: Maximum number of virtual fields in query= 256.
You'll notice proc buffer size = 4095 Without getting into a long explanation of the proc buffer system, though it is tempting, just make sure the statement being executed isn't longer than the proc buffer size. Bruce M Neylon Health Care Management Group "Joe Jamison" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/13/2006 09:29 AM Please respond to [email protected] To <[email protected]> cc Subject [U2] The limit of PROCBUFSZ is reached I posted this error to the forum back in June and never received a response. So I am going to try this method. I am running UD 6.1 on HP-UX 11. Can anyone tell me what this message means and how to correct it? I am getting this message when I try to run a report. "The limit of PROCBUFSZ is reached". Thank you, Joe __________________________________________________________________ Joseph Jamison | Application Developer | The Press of Ohio main: 330.678.5868 | direct: 330.677.7765 | fax: 330.677.2626 www.pressofohio.com Leading the web offset printing industry in personal service. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
