Micro Focus Visual COBOL 2.3 Update 2 for Visual Studio 2015 > Programming > Data Access > Database Access > Reference > OpenESQL > Embedded ADO Statements > BIND

BIND

Allows an ADO.NET DataSet or DataTable to be shared with OpenESQL.

Syntax:

>>--EXEC ADO---.--------------------------.-BIND TO :dataobject_hv-------->
               +-USING dataset_name-------+
               +-DATATABLE datatable_name-+

 >--.-------------------.---END-EXEC----><
    +-WITH SCHEMA CHECK-+

Parameters:

`dataset_name`	The name of the DataSet to be used, or - (dash), which specifies a standalone DataSet. If you do not specify dataset_name, the current DataSet is used.
`datatable_name`	The name of the DataTable you want to share with OpenESQL.
`dataobject_hv`	Host variable which identifies an ADO.NET DataSet or DataTable object.
WITH SCHEMA CHECK	Runtime check that verifies that the current schema is the same as one declared at compile-time.

Comments:

Subsequent EXEC ADO statements in OpenESQL referencing dataset_name (or the current OpenESQL DataSet if dataset_name is not specified) use the current ADO.NET DataSet if it has been defined.

Examples:

     EXEC ADO
        USING changesDS BIND TO :changesDSobj
     END-EXEC

     EXEC ADO 
        BIND DATATABLE TABLE1 TO :HVCHGS  
     END-EXEC