SYSTEM command size limit in SPL

Posted in 1997

Jeff So — 10 Feb 1997 14:38:10 -0500 — source: Informix-list mailing list archive (1991-1998)

Is there a limit on the string of SYSTEM call inside SPL? One of my SPL do the following, when there is an insertion occur, my trigger procedure execute another procedure which use the SYSTEM command and echo a line to a data file. This line includes additional information from other tables. The only thing I found out is the SPL won't compile. I know the line being generated is very long, about 2-3 K in size. So, I try to take some of the fields out, and down to a certain point, the SPL works. So, I am wondering is there a size limit on the SYSTEM call? _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ Intersoft System Ltd ( Travelsurf ) JEFF SO URL : http://www.travelsurf.com Email : jcs@travelsurf.com Address : #555, 333, 11th Ave. S.W, Calgary, AB, Ca Tel : (403)5430078 Fax : (403)2337266 _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/