WebDocs Home | Show Navigation Hide Navigation

Database Functions

SQL Connection database functions are directly related to SQLbased operations and data access. Each database function returns a value and can be used any place a literal can be used in a Synergy program.

%INIT_SSQL – Initialize SQL Connection

%SSC_BIND – Bind host variables for nonSELECT statement

%SSC_CANCEL – Cancel outstanding requests

%SSC_CLOSE – Hard close one or more open cursors

%SSC_CMD – Set databasespecific options

%SSC_COMMIT – Start or commit a transaction

%SSC_CONNECT – Connect to a database channel

%SSC_DEFINE – Define host variables for the SELECT statement

%SSC_DESCSQL – Describe an SQL statement

%SSC_EXECIO – Execute a stored procedure with I/O parameters

%SSC_EXECUTE – Execute a nonSELECT statement (no I/O parameters)

%SSC_INDICATOR – Retrieve indicator variables

%SSC_INIT – Initialize a database channel

%SSC_LARGECOL – Get or put a large binary or char column

%SSC_MOVE – Fetch rows of data

%SSC_OPEN – Open a cursor

%SSC_REBIND – Rebind host variables for a new query

%SSC_RELEASE – Release a database channel

%SSC_ROLLBACK – Roll back a transaction

%SSC_SCLOSE – Soft close one or more open cursors

%SSC_SQLLINK – Link a nonSELECT statement to cursor for a SELECT statement

%SSC_STRDEF – Define a structure