%SSC_BIND

Bind host variables for non-SELECT statement

value = %SSC_BIND(dbchannel, stcursor, numvars, var[, ...])

Return value

value

This function returns SSQL_NORMAL (success) or SSQL_FAILURE (failure). (i)

Arguments

dbchannel

An internal database channel previously initialized using %SSC_INIT and connected by %SSC_CONNECT. (n)

stcursor

The ID number of an open statement cursor (opened with %SSC_OPEN). This must be in the range 1 through the number specified by maxcur when the database channel was initialized (with %SSC_INIT). (n)

numvars

The number of bind variables in the non-SELECT statement, up to the maximum number of columns specified by the maxcol argument in %SSC_INIT. If numvars is negative, the bind variables are overwritten rather than appended. If numvars is positive, the bind variables are appended to the variables for the non-SELECT statement. (n)

var

Host variable(s) to be bound to the non-SELECT statement parameter. The number of var variables passed must equal the value of numvars. (a, n, or String)

Discussion

%SSC_BIND binds host variables to variables for a non-SELECT statement. It affects only variables that are used when %SSC_EXECUTE is called. See Binding data for more information on binding, and note the following:

The total number of bind variables defined with %SSC_BIND must match the number of columns in the non-SELECT statement. For example, if there are 20 host variables in an UPDATE statement, you could use one %SSC_BIND call to append definitions for all 20 variables, or two %SSC_BIND calls with 10 variables each, or any other combination, as long as the number of variables defined by %SSC_BIND exactly matches the number of variables described by %SSC_OPEN in the non-SELECT statement before %SSC_EXECUTE is called.
The String data type (System.String) is not supported for var for array-based operations.
If you use ^VARARGARRAY, note that numvars is the last declared argument for this routine.

Examples

The following example shows how to bind two Synergy DBL variables associated with cur1.

record order_rec
       ord_num            ,d6
       ord_cust           ,d6
.
.
.
sqlp = "UPDATE orders SET or_number = :1 WHERE or_customer = :2
if (%ssc_open(dbchn, cur1, sqlp, SSQL_NONSEL))
  goto err_exit
if (%ssc_bind(dbchn, cur1, 2, ord_num, ord_cust))
  goto err_exit
if (%ssc_execute(dbchn, cur1, 1))
  goto err_exit