Linking ESQL & 4GL
Posted in 1994
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL
We're having a problem doing things in ESQLC, when linked with 4GL code, that we can easily do with programs entirely coded in ESQLC. We think it's a linkage problem. An example is creating a database on a remote machine. The syntax create database "//swconv/" ... to create the database is refused by 4GL, so we wrote it in ESQL, and it works fine. Fine, that is, until we link with the 4GL libraries, and then it fails. We've determined that this syntax requires use of the Relay Module process, which is never started from 4GL. I've hypothesized that the functionality of the Relay Module is built into the 4GL libraries, and externalized in ESQL. Our temporary kludge is to put the tricky code in ESQL, and link it as a stand-alone program, which is RUN from the 4GL code. Could we link the ESQL and 4GL code using the ESQL library, instead of the $INFDIR/lib/libfesql.a that the c4gl script uses? Informix tech support not only doesn't understand what we're talking about, but claims not to even know what libraries c4gl links with. Our configuration is listed below: #---------------------- Informix Configuration -------------------# # # # Network: Twisted Pair Ethernet # # Database space: character file # # # # Server (HP 715-75) uses: # # ONLINE Engine 5.01 UD1 # # I-STAR 5.01 UD1 # # # # Client (HP 715-50) uses: # # I-4GL - 4.11 UC4 # # RDS - 4.11 UC4 # # ESQL/C - 5.01 - UD1 # # I-NET - 5.01 - UD3 # # I-4GL ID - 4.11 UC4 # # I-SQL - 4.11 UC3 # # # #---------------------- Informix Configuration -------------------# Craig Ludington clunding@arlingtonhgts.pamd.cig.mot.com craigl@craigl.pr.mcs.net