Function Syntax

The database server and the application both partially implement each client function. You can execute a client function with either SQLPrepare() and SQLExecute() or with SQLExecDirect(). You need to call SQLBindParameter() or SQLBindCol() to bind each parameter before you call SQLExecute() or SQLExecDirect().

The following code examples illustrates these steps for ifx_lo_open():

rc = SQLPrepare(hstmt, "{? = call ifx_lo_open(?, ?, ?)}",
   SQL_NTS); 
rc = SQLBindParameter(...); 
rc = SQLExecute(hstmt); 

The following code example illustrates these steps for ifx_lo_open():

rc = SQLBindParameter(...); 
rc = SQLExecDirect(hstmt, "{? = call ifx_lo_open(?, ?, ?)}",
   SQL_NTS);