ESQLC quoted str error
Why does esql fail on quoted strings over 1022 in length only on the SUN on esql releases 5 and over? I get this error on SUN platforms using ONLINE and ESQLC esqlc: "esqlbug.ec", line 34: Error -33023: Quoted string too long for SQL. 1 error(s) found THIS FAILS!!! SunOS 4.1.3 3 sun4c: ================================= ONLINE INFORMIX-ESQL/C 5.02.UC1 DATE: 10/25/93 ================================= PORT NUMBER: 042213,042212,042211 THIS FAILS!!! SunOS 5.3 Generic_101318-41 sun4m sparc (SOLARIS 2.3): ================================= ONLINE INFORMIX-ESQL/C 5.02.UC1P1 DATE: 02/25/94 ================================= PORT NUMBER: 042649 (3.5 floppy) 042692 (8mm) 042734 (9-Track) 042608 (Cartridge) THIS WORKS!!! SunOS 4.1.3 3 sun4c: ================================= SE INFORMIX-ESQL/C 4.10.UC1 PRODUCT RELEASE DATE: 03/11/91 ================================= PORT NUMBER: 042213,042212,042211 THIS WORKS!!! UNIX_SV 4.2 1.1.1 i386 386/AT: ================================= ONLINE INFORMIX-ESQL/C 5.00.UD1 DATE: 07/10/92 ================================= PORT NUMBER: 001113 (5.25" Floppy), 001114 (3.5" Floppy), 001128 (Cartridge) THIS WORKS!!! UNIX 3.2 2.3 i386 ================================= SE INFORMIX-ESQL/C 5.00.UD1 DATE: 07/10/92 ================================= PORT NUMBER: 001113 (5.25" Floppy), 001114 (3.5" Floppy), 001128 (Cartridge) Here is a test program that demonstrates the problem. Use esql -e FilesName.ec to (maybe) see the error. --------cut here----------- /*compile using esql -e and see if you get a quoted string too long error */ main() { char st[2024]; sprintf(st," \\ This is a really long string. It really bugs me that \\ our code works on R3 and R4 on intel pc, but this is not working \\ on sun !!!!!!!!!!! \\ This is a really long string. It really bugs me that \\ our code works on R3 R4 on intel pc, but this is not working \\ on sun !!!!!!!!!!! \\ This is a really long string. It really bugs me that \\ our code works on R3 R4 on intel pc, but this is not working \\ on sun !!!!!!!!!!! \\ This is a really long string. It really bugs me that \\ our code works on R3 R4 on intel pc, but this is not working \\ on sun !!!!!!!!!!! \\ This is a really long string. It really bugs me that \\ our code works on R3 R4 on intel pc, but this is not working \\ on sun !!!!!!!!!!! \\ This is a really long string. It really bugs me that \\ our code works on R3 R4 on intel pc, but this is not working \\ on sun !!!!!!!!!!! \\ This is a really long string. It really bugs me that \\ our code works on R3 R4 on intel pc, but this is not working \\ on sun !!!!!!!!!!! \\ on sun !!!!!!!!!!! \\ on sun !!!!!!!!!!! \\ on sun !!!!!!!!!!! \\ on sun !!!!!!!!!!! \\ xx \\ \\ " ); printf("the statement it chokes on is %d long \\n", strlen(st) ); } -------end of cut---------- Has anyone seen this? -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Jason Restad | jrestad@ftc.scs.ag.gov USDA, Soil Conservation Service | jasr@ftc.scs.ag.gov 2625 Redwing Rd., Suite 110 | Ft. Collins, Colorado 80526 |