USING

Specifies the current DataSet name to be used in subsequent processing.

Syntax:

>>--EXEC ADO---USING-dataset_name----END-EXEC----><

Parameters:

dataset_name The name of the DataSet that becomes the current DataSet for subsequent EXEC ADO processing, or – (dash), which indicates that no default DataSet should be used in subsequent statements.

Comment:

References to DataTables in EXEC ADO statements that have no USING clause use the current DataSet name.

USING – implies that the statement uses a standalone DataTable rather than a DataTable contained within a dataset.

Examples:

     EXEC ADO
        USING ds
     END-EXEC

     EXEC ADO
        USING -
     END-EXEC