SE, Stored Procedures, ESQL C, ODBC problem

Posted in 2000

Topics: Stored Procedures & SPL, Connectivity: ODBC / JDBC / .NET, Connectivity: ESQL/C, 4GL & Embedded SQL, Triggers, Constraints & Referential Integrity, Platform-Specific Issues

Kate Juliff — Mon, 10 Apr 2000 13:32:24 GMT — source: Informix-list mailing list archive (1991-1998)

I have a complicated problem. I have AIX Unix and SE 7.3. I have a stored procedure that makes a system call to a program compiled with ESQL C. This program reads CISAM files and loads records into the SE database. All works fine on the AIX box, where the DB resides. HOWEVER when I execute this SP using ODBC from an NT machine (SDK) it just hangs. I can execute other SPs from ODBC but THIS one has a problem. I expect it is something to to with it getting confused with environment variables. I've tried putting the program that is called with the system call, in a shell script that sets up the environment variables, and executing that. I've tried triggers... Can't get anywhere. Any pointers at all appreciated. Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to Kate Juliff

Matt Pierce — Wed, 12 Apr 2000 11:57:58 +0100 — source: Informix-list mailing list archive (1991-1998)

Is the system call being backgrounded with a "&" ? Kate Juliff wrote in message <8csl58$sen$1@nnrp1.deja.com>... >snip

Glossary

ESQL/C