HOW CALL PROCEDURE DEFINED IN INFORMIX DATABASE?

Posted in 1999

Topics: Connectivity: ESQL/C, 4GL & Embedded SQL

Liu Jiachuan — Sun, 10 Jan 1999 14:07:49 -0000 — source: Informix-list mailing list archive (1991-1998)

Hi, everybody. I want to ask you a question. Informix can define procedure in database. But I don't know whether the procedure defined in database can be called in esql/c program, can you tell me? If so, can you tell me how call it? Thank you.

↪ replying to Liu Jiachuan

Madison Pruet — Sun, 10 Jan 1999 16:34:22 -0600 — source: Informix-list mailing list archive (1991-1998)

You can excute the procedure via the execute statement or as part of a select. Liu Jiachuan wrote: > Hi, everybody. > I want to ask you a question. > > Informix can define procedure in database. But I don't know whether the > procedure defined in database can be called in esql/c program, can you tell > me? If so, can you tell me how call it? > > Thank you.

↪ replying to Liu Jiachuan

Dalius Masalas — Mon, 11 Jan 1999 12:00:40 +0100 — source: Informix-list mailing list archive (1991-1998)

Liu Jiachuan wrote: > Hi, everybody. > I want to ask you a question. > > Informix can define procedure in database. But I don't know whether the > procedure defined in database can be called in esql/c program, can you tell > me? If so, can you tell me how call it? > > Thank you. In esql/c program: EXEC SQL execute procedure prc() into :some_var; See also http://www.informix.com/answers/oldsite/answers/english/esqlc.htm for ESQL/C doc. Dalius Masalas -- Sidabrinis tinklas J.Jasinskio 16, 2600 Vilnius, Lithuania Tel.: 370-2-235926 Fax.: 370-2-235917 E-mail: stinklas@post.omnitel.net

Glossary

ESQL/C