1  –  INTO_DESCRIPTOR

    Specifies an SQLDA descriptor that contains addresses and data
    types that specify output parameters or variables.

    The descriptor must be a structure declared in the host language
    program as an SQLDA. If the program is precompiled and uses the
    embedded SQL statement INCLUDE SQLDA, the name of the structure
    is simply SQLDA. Programs can use multiple SQLDAs, but must
    explicitly declare them with names other than SQLDA.

    Programs can always use the INTO DESCRIPTOR clause of the EXECUTE
    statement whether or not the statement string contains output
    parameter markers, as long as the value of the SQLD field in
    the SQLDA corresponds to the number of output parameter markers.
    SQL updates the SQLD field with the correct number of output
    parameter markers when it processes the DESCRIBE statement for
    the statement string.

2  –  INTO clause

    Syntax options:

    INTO parameter | INTO qualified-parameter | INTO variable

    Specifies output parameters or variables whose values are
    returned by a successful EXECUTE statement.

    When you specify a list of parameters or variables, the number
    of parameters in the list must be the same as the number of
    output parameter markers in the statement string of the prepared
    statement. If SQL determines that a statement string had no
    output parameter markers, the INTO clause is not allowed.

3  –  statement-name

    Specifies the name of a prepared statement. You can supply either
    a parameter or a compile-time statement name. Specifying a
    parameter lets SQL supply identifiers to programs at run time.
    Use an integer parameter to contain the statement identifier
    returned by SQL or a character string parameter to contain the
    name of the statement that you pass to SQL.

    If the PREPARE statement for the dynamically executed statement
    specifies a parameter, use that same parameter in the EXECUTE
    statement instead of an explicit statement name.

4  –  statement-id-parameter

    Specifies the name of a prepared statement. You can supply either
    a parameter or a compile-time statement name. Specifying a
    parameter lets SQL supply identifiers to programs at run time.
    Use an integer parameter to contain the statement identifier
    returned by SQL or a character string parameter to contain the
    name of the statement that you pass to SQL.

    If the PREPARE statement for the dynamically executed statement
    specifies the same parameter, use that parameter in the EXECUTE
    statement instead of an explicit statement name. If an SQLCA is
    used to capture completion conditions and row count information,
    an SQLCA must be used with the PREPARE statement. See the PREPARE
    statement for more information.

5  –  USING_DESCRIPTOR

    Specifies an SQLDA descriptor that contains addresses and data
    types of input parameters or variables.

    The descriptor must be a structure declared in the host language
    program as an SQLDA. If the program is precompiled and uses the
    embedded SQL statement INCLUDE SQLDA, the name of the structure
    is simply SQLDA. Programs can use multiple SQLDAs, but must
    explicitly declare them with names other than SQLDA.

    Programs can always use the USING DESCRIPTOR clause of the
    EXECUTE statement whether or not the statement string contains
    input parameter markers, as long as the value of the SQLD
    field in the SQLDA corresponds to the number of input parameter
    markers. SQL updates the SQLD field with the correct number of
    input parameter markers when it processes the DESCRIBE statement
    for the statement string.

6  –  USING clause

    Syntax options:

    USING parameter | USING qualified-parameter | USING variable

    Specifies input parameters or variables whose values SQL uses to
    replace parameter markers in the prepared statement string.

    When you specify a list of parameters or variables, the number
    of parameters in the list must be the same as the number of
    input parameter markers in the statement string of the prepared
    statement. If SQL determines that a statement string had no input
    parameter markers, the USING clause is not allowed.