%SSC_SQLLINK

Link a non-SELECT statement to cursor for a SELECT statement

WTSupported in traditional Synergy on Windows
WNSupported in Synergy .NET on Windows
USupported on UNIX
VSupported on OpenVMS
value = %SSC_SQLLINK(dbchannel, dbcursor, statement[, numvars][, var, ...])

Return value

value

This function returns SSQL_NORMAL (success). (i)

Arguments

dbchannel

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

dbcursor

The logical cursor number within the range from 1 through the maximum number specified by maxcur during %SSC_INIT. The cursor must have been opened by %SSC_OPEN. (n)

statement

The SQL statement. (a)

numvars

(optional) The number of bound host variables that follow. Note that numvars cannot exceed the value of maxcol passed in the %SSC_INIT call. (n)

var

(optional) Host variables to be bound to the non-SELECT statement. If numvars is passed, the number of var arguments passed must equal the value of numvars. (n)

Discussion

%SSC_SQLLINK links a new non-SELECT statement to an already opened SELECT statement cursor, clears all defined variables and bound variables, and rebinds variables for the new non-SELECT statement to follow. The primary use of %SSC_SQLLINK is to update the current row just fetched through %SSC_MOVE (with the SSQL_POSITION and SSQL_FORUPDATE options set in the %SSC_OPEN for the cursor).

Note the following:

For more information on binding host variables, see Binding data.

Examples

For an example, see exam_fetch_update.dbl, which is in the connect\synsqlx subdirectory of the main Synergy/DE installation directory.