Oninit cdi / Archive
Talk to an expert →

4GL from Stored Procedure?

Posted in 2000

Summary

Matthew asked whether a stored procedure could call an Informix 4GL routine to load blobs. Dennis Pimple said SPL SYSTEM can run OS programs, suggesting a shell script that sets the environment and loads via dbaccess. Matthew said it worked but asked how to get success or failure back; PC User replied that the 4GL program should write a status record into the database.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Stored Procedures & SPL, Connectivity: ODBC / JDBC / .NET, Connectivity: ESQL/C, 4GL & Embedded SQL

Matthew — — source: Informix-list mailing list archive (1991-1998)

Is it possible to run/call an Informix 4GL routine from a stored procedure? I'm trying to get blobs into a database and have only been able to figure out how to do it with 4GL, but i can execute SQL statements or stored procedures via ODBC. So can i have a stored procedure run a 4GL routine to load the blob?

↪ replying to Matthew
Dennis Pimple — — source: Informix-list mailing list archive (1991-1998)

You can run anything on the OS with a SYSTEM call (documented in our SPL sections), but setting up the environment sometimes is complicated. It works similar to a 4gl RUN statement, so you're running a compiled (or rds) program, not just a simple 4gl function. You might want to consider using SYSTEM to run a shell script that sets up environment and does the load via dbaccess/load. Matthew wrote in message <_C_i4.30039$pb2.2120228@tw11.nn.bcandid.com>... >Is it possible to run/call an Informix 4GL routine from a stored procedure? >I'm trying to get blobs into a database and have only been able to figure >out how to do it with 4GL, but i can execute SQL statements or stored >procedures via ODBC. So can i have a stored procedure run a 4GL routine to >load the blob? > >

↪ replying to Matthew
Matthew — — source: Informix-list mailing list archive (1991-1998)

Thank you. It worked. However there is there a way to return the success or failure of the 4GL routine through the stored procedure? It doesn't look like SYSTEM can return anything. Matthew

↪ replying to Matthew
PC User — — source: Informix-list mailing list archive (1991-1998)

The only practical way is to have to 4GL write a status record into the database somewhere. Art S. Kagel Matthew wrote: > Thank you. It worked. However there is there a way to return the success or > failure of the 4GL routine through the stored procedure? It doesn't look > like SYSTEM can return anything. > > Matthew

Glossary